PageRenderTime 18ms CodeModel.GetById 9ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/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
  1PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM (
  8  FROM src_thrift
  9  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
 10         USING '/bin/cat' AS (tkey, tvalue) 
 11  CLUSTER BY tkey 
 12) tmap
 13INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
 14PREHOOK: type: QUERY
 15POSTHOOK: query: EXPLAIN
 16FROM (
 17  FROM src_thrift
 18  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
 19         USING '/bin/cat' AS (tkey, tvalue) 
 20  CLUSTER BY tkey 
 21) tmap
 22INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
 23POSTHOOK: type: QUERY
 24ABSTRACT SYNTAX TREE:
 25  (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)))))
 26
 27STAGE DEPENDENCIES:
 28  Stage-1 is a root stage
 29  Stage-0 depends on stages: Stage-1
 30  Stage-2 depends on stages: Stage-0
 31
 32STAGE PLANS:
 33  Stage: Stage-1
 34    Map Reduce
 35      Alias -> Map Operator Tree:
 36        tmap:src_thrift 
 37          TableScan
 38            alias: src_thrift
 39            Select Operator
 40              expressions:
 41                    expr: lint
 42                    type: array<int>
 43                    expr: lintstring
 44                    type: array<struct<myint:int,mystring:string,underscore_int:int>>
 45              outputColumnNames: _col0, _col1
 46              Transform Operator
 47                command: /bin/cat
 48                output info:
 49                    input format: org.apache.hadoop.mapred.TextInputFormat
 50                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 51                Reduce Output Operator
 52                  key expressions:
 53                        expr: _col0
 54                        type: string
 55                  sort order: +
 56                  Map-reduce partition columns:
 57                        expr: _col0
 58                        type: string
 59                  tag: -1
 60                  value expressions:
 61                        expr: _col0
 62                        type: string
 63                        expr: _col1
 64                        type: string
 65      Reduce Operator Tree:
 66        Extract
 67          Select Operator
 68            expressions:
 69                  expr: _col0
 70                  type: string
 71                  expr: _col1
 72                  type: string
 73            outputColumnNames: _col0, _col1
 74            File Output Operator
 75              compressed: false
 76              GlobalTableId: 1
 77              table:
 78                  input format: org.apache.hadoop.mapred.TextInputFormat
 79                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 80                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 81                  name: default.dest1
 82
 83  Stage: Stage-0
 84    Move Operator
 85      tables:
 86          replace: true
 87          table:
 88              input format: org.apache.hadoop.mapred.TextInputFormat
 89              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 90              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 91              name: default.dest1
 92
 93  Stage: Stage-2
 94    Stats-Aggr Operator
 95
 96
 97PREHOOK: query: FROM (
 98  FROM src_thrift
 99  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
100         USING '/bin/cat' AS (tkey, tvalue) 
101  CLUSTER BY tkey 
102) tmap
103INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
104PREHOOK: type: QUERY
105PREHOOK: Input: default@src_thrift
106PREHOOK: Output: default@dest1
107POSTHOOK: query: FROM (
108  FROM src_thrift
109  SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
110         USING '/bin/cat' AS (tkey, tvalue) 
111  CLUSTER BY tkey 
112) tmap
113INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
114POSTHOOK: type: QUERY
115POSTHOOK: Input: default@src_thrift
116POSTHOOK: Output: default@dest1
117POSTHOOK: 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), ]
118POSTHOOK: 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), ]
119PREHOOK: query: SELECT dest1.* FROM dest1
120PREHOOK: type: QUERY
121PREHOOK: Input: default@dest1
122PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-11_675_5799458023080781546/-mr-10000
123POSTHOOK: query: SELECT dest1.* FROM dest1
124POSTHOOK: type: QUERY
125POSTHOOK: Input: default@dest1
126POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-58-11_675_5799458023080781546/-mr-10000
127POSTHOOK: 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), ]
128POSTHOOK: 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), ]
129[0,0,0]	[{"myint":0,"mystring":"0","underscore_int":0}]
130[1,2,3]	[{"myint":1,"mystring":"1","underscore_int":1}]
131[2,4,6]	[{"myint":4,"mystring":"8","underscore_int":2}]
132[3,6,9]	[{"myint":9,"mystring":"27","underscore_int":3}]
133[4,8,12]	[{"myint":16,"mystring":"64","underscore_int":4}]
134[5,10,15]	[{"myint":25,"mystring":"125","underscore_int":5}]
135[6,12,18]	[{"myint":36,"mystring":"216","underscore_int":6}]
136[7,14,21]	[{"myint":49,"mystring":"343","underscore_int":7}]
137[8,16,24]	[{"myint":64,"mystring":"512","underscore_int":8}]
138[9,18,27]	[{"myint":81,"mystring":"729","underscore_int":9}]
139null	null