PageRenderTime 16ms CodeModel.GetById 13ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input14.q.out

#
text | 223 lines | 217 code | 6 blank | 0 comment | 0 complexity | 3c1c21b9386990380046f8d7f42871ed MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM (
  8  FROM src
  9  SELECT TRANSFORM(src.key, src.value)
 10         USING '/bin/cat' AS (tkey, tvalue) 
 11  CLUSTER BY tkey 
 12) tmap
 13INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
 14PREHOOK: type: QUERY
 15POSTHOOK: query: EXPLAIN
 16FROM (
 17  FROM src
 18  SELECT TRANSFORM(src.key, src.value)
 19         USING '/bin/cat' AS (tkey, tvalue) 
 20  CLUSTER BY tkey 
 21) tmap
 22INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
 23POSTHOOK: type: QUERY
 24ABSTRACT SYNTAX TREE:
 25  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) 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))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL tmap) tkey) 100))))
 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 
 37          TableScan
 38            alias: src
 39            Select Operator
 40              expressions:
 41                    expr: key
 42                    type: string
 43                    expr: value
 44                    type: string
 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          Filter Operator
 68            predicate:
 69                expr: (_col0 < 100)
 70                type: boolean
 71            Select Operator
 72              expressions:
 73                    expr: _col0
 74                    type: string
 75                    expr: _col1
 76                    type: string
 77              outputColumnNames: _col0, _col1
 78              Select Operator
 79                expressions:
 80                      expr: UDFToInteger(_col0)
 81                      type: int
 82                      expr: _col1
 83                      type: string
 84                outputColumnNames: _col0, _col1
 85                File Output Operator
 86                  compressed: false
 87                  GlobalTableId: 1
 88                  table:
 89                      input format: org.apache.hadoop.mapred.TextInputFormat
 90                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 91                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 92                      name: default.dest1
 93
 94  Stage: Stage-0
 95    Move Operator
 96      tables:
 97          replace: true
 98          table:
 99              input format: org.apache.hadoop.mapred.TextInputFormat
100              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
101              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
102              name: default.dest1
103
104  Stage: Stage-2
105    Stats-Aggr Operator
106
107
108PREHOOK: query: FROM (
109  FROM src
110  SELECT TRANSFORM(src.key, src.value)
111         USING '/bin/cat' AS (tkey, tvalue) 
112  CLUSTER BY tkey 
113) tmap
114INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
115PREHOOK: type: QUERY
116PREHOOK: Input: default@src
117PREHOOK: Output: default@dest1
118POSTHOOK: query: FROM (
119  FROM src
120  SELECT TRANSFORM(src.key, src.value)
121         USING '/bin/cat' AS (tkey, tvalue) 
122  CLUSTER BY tkey 
123) tmap
124INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
125POSTHOOK: type: QUERY
126POSTHOOK: Input: default@src
127POSTHOOK: Output: default@dest1
128POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
129POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
130PREHOOK: query: SELECT dest1.* FROM dest1
131PREHOOK: type: QUERY
132PREHOOK: Input: default@dest1
133PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-29_559_2350793027602595084/-mr-10000
134POSTHOOK: query: SELECT dest1.* FROM dest1
135POSTHOOK: type: QUERY
136POSTHOOK: Input: default@dest1
137POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-53-29_559_2350793027602595084/-mr-10000
138POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
139POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
1400	val_0
1410	val_0
1420	val_0
14310	val_10
14411	val_11
14512	val_12
14612	val_12
14715	val_15
14815	val_15
14917	val_17
15018	val_18
15118	val_18
15219	val_19
1532	val_2
15420	val_20
15524	val_24
15624	val_24
15726	val_26
15826	val_26
15927	val_27
16028	val_28
16130	val_30
16233	val_33
16334	val_34
16435	val_35
16535	val_35
16635	val_35
16737	val_37
16837	val_37
1694	val_4
17041	val_41
17142	val_42
17242	val_42
17343	val_43
17444	val_44
17547	val_47
1765	val_5
1775	val_5
1785	val_5
17951	val_51
18051	val_51
18153	val_53
18254	val_54
18357	val_57
18458	val_58
18558	val_58
18664	val_64
18765	val_65
18866	val_66
18967	val_67
19067	val_67
19169	val_69
19270	val_70
19370	val_70
19470	val_70
19572	val_72
19672	val_72
19774	val_74
19876	val_76
19976	val_76
20077	val_77
20178	val_78
2028	val_8
20380	val_80
20482	val_82
20583	val_83
20683	val_83
20784	val_84
20884	val_84
20985	val_85
21086	val_86
21187	val_87
2129	val_9
21390	val_90
21490	val_90
21590	val_90
21692	val_92
21795	val_95
21895	val_95
21996	val_96
22097	val_97
22197	val_97
22298	val_98
22398	val_98