/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input5.q.out
text | 139 lines | 133 code | 6 blank | 0 comment | 0 complexity | 5617bd7bf9b17110f9959a546b54f4f9 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@dest1
- PREHOOK: query: EXPLAIN
- FROM (
- FROM src_thrift
- SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
- USING '/bin/cat' AS (tkey, tvalue)
- CLUSTER BY tkey
- ) tmap
- INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN
- FROM (
- FROM src_thrift
- SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
- USING '/bin/cat' AS (tkey, tvalue)
- CLUSTER BY tkey
- ) tmap
- INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
- POSTHOOK: type: QUERY
- ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src_thrift) lint) (. (TOK_TABLE_OR_COL src_thrift) lintstring)) TOK_SERDE TOK_RECORDWRITER '/bin/cat' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue)))))
- STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
- STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- tmap:src_thrift
- TableScan
- alias: src_thrift
- Select Operator
- expressions:
- expr: lint
- type: array<int>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- outputColumnNames: _col0, _col1
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- Reduce Operator Tree:
- Extract
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- 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
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- Stage: Stage-0
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- Stage: Stage-2
- Stats-Aggr Operator
- PREHOOK: query: FROM (
- FROM src_thrift
- SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
- USING '/bin/cat' AS (tkey, tvalue)
- CLUSTER BY tkey
- ) tmap
- INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src_thrift
- PREHOOK: Output: default@dest1
- POSTHOOK: query: FROM (
- FROM src_thrift
- SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
- USING '/bin/cat' AS (tkey, tvalue)
- CLUSTER BY tkey
- ) tmap
- INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src_thrift
- POSTHOOK: Output: default@dest1
- POSTHOOK: Lineage: dest1.key SCRIPT [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
- POSTHOOK: Lineage: dest1.value SCRIPT [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
- PREHOOK: query: SELECT dest1.* FROM dest1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@dest1
- PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-11_675_5799458023080781546/-mr-10000
- POSTHOOK: query: SELECT dest1.* FROM dest1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@dest1
- POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-11_675_5799458023080781546/-mr-10000
- POSTHOOK: Lineage: dest1.key SCRIPT [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
- POSTHOOK: Lineage: dest1.value SCRIPT [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), (src_thrift)src_thrift.FieldSchema(name:lintstring, type:array<org.apache.hadoop.hive.serde2.thrift.test.IntString>, comment:from deserializer), ]
- [0,0,0] [{"myint":0,"mystring":"0","underscore_int":0}]
- [1,2,3] [{"myint":1,"mystring":"1","underscore_int":1}]
- [2,4,6] [{"myint":4,"mystring":"8","underscore_int":2}]
- [3,6,9] [{"myint":9,"mystring":"27","underscore_int":3}]
- [4,8,12] [{"myint":16,"mystring":"64","underscore_int":4}]
- [5,10,15] [{"myint":25,"mystring":"125","underscore_int":5}]
- [6,12,18] [{"myint":36,"mystring":"216","underscore_int":6}]
- [7,14,21] [{"myint":49,"mystring":"343","underscore_int":7}]
- [8,16,24] [{"myint":64,"mystring":"512","underscore_int":8}]
- [9,18,27] [{"myint":81,"mystring":"729","underscore_int":9}]
- null null