/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/index_auto_file_format.q.out
text | 288 lines | 268 code | 20 blank | 0 comment | 0 complexity | a6d299258e304d26b23aa5affa49d306 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: -- test automatic use of index on different file formats
- CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
- PREHOOK: type: CREATEINDEX
- POSTHOOK: query: -- test automatic use of index on different file formats
- CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
- POSTHOOK: type: CREATEINDEX
- PREHOOK: query: ALTER INDEX src_index ON src REBUILD
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: default@default__src_src_index__
- POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: default@default__src_src_index__
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 ORDER BY key
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 ORDER BY key
- POSTHOOK: type: QUERY
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
- STAGE DEPENDENCIES:
- Stage-3 is a root stage
- Stage-6 depends on stages: Stage-3 , consists of Stage-5, Stage-4
- Stage-5
- Stage-2 depends on stages: Stage-5, Stage-4
- Stage-1 depends on stages: Stage-2
- Stage-4
- Stage-0 is a root stage
- STAGE PLANS:
- Stage: Stage-3
- Map Reduce
- Alias -> Map Operator Tree:
- default__src_src_index__
- TableScan
- alias: default__src_src_index__
- filterExpr:
- expr: (key = 86)
- type: boolean
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: _bucketname
- type: string
- expr: _offsets
- type: array<bigint>
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-6
- Conditional Operator
- Stage: Stage-5
- Move Operator
- files:
- hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-40_411_4815505312955631583/-ext-10000
- Stage: Stage-2
- Move Operator
- files:
- hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_275_2821007696524201513/-mr-10002
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- filterExpr:
- expr: (key = 86)
- type: boolean
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-4
- Map Reduce
- Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-40_411_4815505312955631583/-ext-10001
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-0
- Fetch Operator
- limit: -1
- PREHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
- PREHOOK: type: QUERY
- PREHOOK: Input: default@default__src_src_index__
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_552_3841543983008204664/-mr-10000
- POSTHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@default__src_src_index__
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-40_552_3841543983008204664/-mr-10000
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- 86 val_86
- PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 ORDER BY key
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 ORDER BY key
- POSTHOOK: type: QUERY
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))
- STAGE DEPENDENCIES:
- Stage-3 is a root stage
- Stage-6 depends on stages: Stage-3 , consists of Stage-5, Stage-4
- Stage-5
- Stage-2 depends on stages: Stage-5, Stage-4
- Stage-1 depends on stages: Stage-2
- Stage-4
- Stage-0 is a root stage
- STAGE PLANS:
- Stage: Stage-3
- Map Reduce
- Alias -> Map Operator Tree:
- default__src_src_index__
- TableScan
- alias: default__src_src_index__
- filterExpr:
- expr: (key = 86)
- type: boolean
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: _bucketname
- type: string
- expr: _offsets
- type: array<bigint>
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-6
- Conditional Operator
- Stage: Stage-5
- Move Operator
- files:
- hdfs directory: true
- destination: file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-55_117_7145184773994968051/-ext-10000
- Stage: Stage-2
- Move Operator
- files:
- hdfs directory: true
- destination: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-54_980_8246330207973926102/-mr-10002
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- filterExpr:
- expr: (key = 86)
- type: boolean
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-4
- Map Reduce
- Alias -> Map Operator Tree:
- file:/Users/salbiz/dev/hive/build/ql/scratchdir/hive_2011-06-15_16-16-55_117_7145184773994968051/-ext-10001
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Stage: Stage-0
- Fetch Operator
- limit: -1
- PREHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
- PREHOOK: type: QUERY
- PREHOOK: Input: default@default__src_src_index__
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-55_246_5645043276355070579/-mr-10000
- POSTHOOK: query: SELECT key, value FROM src WHERE key=86 ORDER BY key
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@default__src_src_index__
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-16-55_246_5645043276355070579/-mr-10000
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
- 86 val_86
- PREHOOK: query: DROP INDEX src_index on src
- PREHOOK: type: DROPINDEX
- POSTHOOK: query: DROP INDEX src_index on src
- POSTHOOK: type: DROPINDEX
- POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
- POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]