PageRenderTime 22ms CodeModel.GetById 11ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/join27.q.out

#
text | 209 lines | 199 code | 10 blank | 0 comment | 0 complexity | 31c98968031ebb28892cfd6b7d1bf993 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING, val2 STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING, val2 STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest_j1
  6PREHOOK: query: EXPLAIN
  7INSERT OVERWRITE TABLE dest_j1 
  8SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
  9FROM src1 x JOIN src y ON (x.value = y.value)
 10PREHOOK: type: QUERY
 11POSTHOOK: query: EXPLAIN
 12INSERT OVERWRITE TABLE dest_j1 
 13SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
 14FROM src1 x JOIN src y ON (x.value = y.value)
 15POSTHOOK: type: QUERY
 16ABSTRACT SYNTAX TREE:
 17  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) value) (. (TOK_TABLE_OR_COL y) value)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)))))
 18
 19STAGE DEPENDENCIES:
 20  Stage-7 is a root stage
 21  Stage-1 depends on stages: Stage-7
 22  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 23  Stage-4
 24  Stage-0 depends on stages: Stage-4, Stage-3
 25  Stage-2 depends on stages: Stage-0
 26  Stage-3
 27
 28STAGE PLANS:
 29  Stage: Stage-7
 30    Map Reduce Local Work
 31      Alias -> Map Local Tables:
 32        x 
 33          Fetch Operator
 34            limit: -1
 35      Alias -> Map Local Operator Tree:
 36        x 
 37          TableScan
 38            alias: x
 39            HashTable Sink Operator
 40              condition expressions:
 41                0 {key} {value}
 42                1 {value}
 43              handleSkewJoin: false
 44              keys:
 45                0 [Column[value]]
 46                1 [Column[value]]
 47              Position of Big Table: 1
 48
 49  Stage: Stage-1
 50    Map Reduce
 51      Alias -> Map Operator Tree:
 52        y 
 53          TableScan
 54            alias: y
 55            Map Join Operator
 56              condition map:
 57                   Inner Join 0 to 1
 58              condition expressions:
 59                0 {key} {value}
 60                1 {value}
 61              handleSkewJoin: false
 62              keys:
 63                0 [Column[value]]
 64                1 [Column[value]]
 65              outputColumnNames: _col0, _col1, _col5
 66              Position of Big Table: 1
 67              Select Operator
 68                expressions:
 69                      expr: _col0
 70                      type: string
 71                      expr: _col1
 72                      type: string
 73                      expr: _col5
 74                      type: string
 75                outputColumnNames: _col0, _col1, _col5
 76                Select Operator
 77                  expressions:
 78                        expr: _col0
 79                        type: string
 80                        expr: _col1
 81                        type: string
 82                        expr: _col5
 83                        type: string
 84                  outputColumnNames: _col0, _col1, _col2
 85                  Select Operator
 86                    expressions:
 87                          expr: UDFToInteger(_col0)
 88                          type: int
 89                          expr: _col1
 90                          type: string
 91                          expr: _col2
 92                          type: string
 93                    outputColumnNames: _col0, _col1, _col2
 94                    File Output Operator
 95                      compressed: false
 96                      GlobalTableId: 1
 97                      table:
 98                          input format: org.apache.hadoop.mapred.TextInputFormat
 99                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
100                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
101                          name: default.dest_j1
102      Local Work:
103        Map Reduce Local Work
104
105  Stage: Stage-5
106    Conditional Operator
107
108  Stage: Stage-4
109    Move Operator
110      files:
111          hdfs directory: true
112          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-08_290_5231941166795202890/-ext-10000
113
114  Stage: Stage-0
115    Move Operator
116      tables:
117          replace: true
118          table:
119              input format: org.apache.hadoop.mapred.TextInputFormat
120              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
121              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
122              name: default.dest_j1
123
124  Stage: Stage-2
125    Stats-Aggr Operator
126
127  Stage: Stage-3
128    Map Reduce
129      Alias -> Map Operator Tree:
130        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-08_290_5231941166795202890/-ext-10002 
131            File Output Operator
132              compressed: false
133              GlobalTableId: 0
134              table:
135                  input format: org.apache.hadoop.mapred.TextInputFormat
136                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
137                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
138                  name: default.dest_j1
139
140
141PREHOOK: query: INSERT OVERWRITE TABLE dest_j1 
142SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
143FROM src1 x JOIN src y ON (x.value = y.value)
144PREHOOK: type: QUERY
145PREHOOK: Input: default@src
146PREHOOK: Input: default@src1
147PREHOOK: Output: default@dest_j1
148POSTHOOK: query: INSERT OVERWRITE TABLE dest_j1 
149SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
150FROM src1 x JOIN src y ON (x.value = y.value)
151POSTHOOK: type: QUERY
152POSTHOOK: Input: default@src
153POSTHOOK: Input: default@src1
154POSTHOOK: Output: default@dest_j1
155POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
156POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
157POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
158PREHOOK: query: select * from dest_j1 x order by x.key, x.value
159PREHOOK: type: QUERY
160PREHOOK: Input: default@dest_j1
161PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-15_076_7667701666661422377/-mr-10000
162POSTHOOK: query: select * from dest_j1 x order by x.key, x.value
163POSTHOOK: type: QUERY
164POSTHOOK: Input: default@dest_j1
165POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-15_076_7667701666661422377/-mr-10000
166POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
167POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
168POSTHOOK: Lineage: dest_j1.value SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
169NULL	val_165	val_165
170NULL	val_165	val_165
171NULL	val_193	val_193
172NULL	val_193	val_193
173NULL	val_193	val_193
174NULL	val_265	val_265
175NULL	val_265	val_265
176NULL	val_27	val_27
177NULL	val_409	val_409
178NULL	val_409	val_409
179NULL	val_409	val_409
180NULL	val_484	val_484
18166	val_66	val_66
18298	val_98	val_98
18398	val_98	val_98
184146	val_146	val_146
185146	val_146	val_146
186150	val_150	val_150
187213	val_213	val_213
188213	val_213	val_213
189238	val_238	val_238
190238	val_238	val_238
191255	val_255	val_255
192255	val_255	val_255
193273	val_273	val_273
194273	val_273	val_273
195273	val_273	val_273
196278	val_278	val_278
197278	val_278	val_278
198311	val_311	val_311
199311	val_311	val_311
200311	val_311	val_311
201401	val_401	val_401
202401	val_401	val_401
203401	val_401	val_401
204401	val_401	val_401
205401	val_401	val_401
206406	val_406	val_406
207406	val_406	val_406
208406	val_406	val_406
209406	val_406	val_406