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

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

#
text | 311 lines | 301 code | 10 blank | 0 comment | 0 complexity | ed939c3d45e6ce22a332d7b6282ba554 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest_j1(key STRING, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest_j1(key STRING, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest_j1
  6PREHOOK: query: EXPLAIN
  7INSERT OVERWRITE TABLE dest_j1 
  8SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
  9FROM
 10(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
 11 FROM src1 x JOIN src y ON (x.key = y.key)) subq
 12 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
 13PREHOOK: type: QUERY
 14POSTHOOK: query: EXPLAIN
 15INSERT OVERWRITE TABLE dest_j1 
 16SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
 17FROM
 18(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
 19 FROM src1 x JOIN src y ON (x.key = y.key)) subq
 20 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
 21POSTHOOK: type: QUERY
 22ABSTRACT SYNTAX TREE:
 23  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key) key1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value) value1) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key) key2) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value) value2)))) subq) (TOK_TABREF (TOK_TABNAME srcpart) z) (and (and (= (. (TOK_TABLE_OR_COL subq) key1) (. (TOK_TABLE_OR_COL z) key)) (= (. (TOK_TABLE_OR_COL z) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL z) hr) 11)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST z))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL subq) key1)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL z) value)))))
 24
 25STAGE DEPENDENCIES:
 26  Stage-8 is a root stage
 27  Stage-1 depends on stages: Stage-8
 28  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 29  Stage-4
 30  Stage-0 depends on stages: Stage-4, Stage-3
 31  Stage-2 depends on stages: Stage-0
 32  Stage-3
 33
 34STAGE PLANS:
 35  Stage: Stage-8
 36    Map Reduce Local Work
 37      Alias -> Map Local Tables:
 38        subq:x 
 39          Fetch Operator
 40            limit: -1
 41        z 
 42          Fetch Operator
 43            limit: -1
 44      Alias -> Map Local Operator Tree:
 45        subq:x 
 46          TableScan
 47            alias: x
 48            HashTable Sink Operator
 49              condition expressions:
 50                0 {key}
 51                1 
 52              handleSkewJoin: false
 53              keys:
 54                0 [Column[key]]
 55                1 [Column[key]]
 56              Position of Big Table: 1
 57        z 
 58          TableScan
 59            alias: z
 60            HashTable Sink Operator
 61              condition expressions:
 62                0 {_col0}
 63                1 {value}
 64              handleSkewJoin: false
 65              keys:
 66                0 [Column[_col0]]
 67                1 [Column[key]]
 68              Position of Big Table: 0
 69
 70  Stage: Stage-1
 71    Map Reduce
 72      Alias -> Map Operator Tree:
 73        subq:y 
 74          TableScan
 75            alias: y
 76            Map Join Operator
 77              condition map:
 78                   Inner Join 0 to 1
 79              condition expressions:
 80                0 {key}
 81                1 
 82              handleSkewJoin: false
 83              keys:
 84                0 [Column[key]]
 85                1 [Column[key]]
 86              outputColumnNames: _col0
 87              Position of Big Table: 1
 88              Select Operator
 89                expressions:
 90                      expr: _col0
 91                      type: string
 92                outputColumnNames: _col0
 93                Select Operator
 94                  expressions:
 95                        expr: _col0
 96                        type: string
 97                  outputColumnNames: _col0
 98                  Map Join Operator
 99                    condition map:
100                         Inner Join 0 to 1
101                    condition expressions:
102                      0 {_col0}
103                      1 {value}
104                    handleSkewJoin: false
105                    keys:
106                      0 [Column[_col0]]
107                      1 [Column[key]]
108                    outputColumnNames: _col0, _col5
109                    Position of Big Table: 0
110                    Select Operator
111                      expressions:
112                            expr: _col0
113                            type: string
114                            expr: _col5
115                            type: string
116                      outputColumnNames: _col0, _col5
117                      Select Operator
118                        expressions:
119                              expr: _col0
120                              type: string
121                              expr: _col5
122                              type: string
123                        outputColumnNames: _col0, _col1
124                        File Output Operator
125                          compressed: false
126                          GlobalTableId: 1
127                          table:
128                              input format: org.apache.hadoop.mapred.TextInputFormat
129                              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
130                              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
131                              name: default.dest_j1
132      Local Work:
133        Map Reduce Local Work
134
135  Stage: Stage-5
136    Conditional Operator
137
138  Stage: Stage-4
139    Move Operator
140      files:
141          hdfs directory: true
142          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-18_666_8729563590191203713/-ext-10000
143
144  Stage: Stage-0
145    Move Operator
146      tables:
147          replace: true
148          table:
149              input format: org.apache.hadoop.mapred.TextInputFormat
150              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
151              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
152              name: default.dest_j1
153
154  Stage: Stage-2
155    Stats-Aggr Operator
156
157  Stage: Stage-3
158    Map Reduce
159      Alias -> Map Operator Tree:
160        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-04-18_666_8729563590191203713/-ext-10002 
161            File Output Operator
162              compressed: false
163              GlobalTableId: 0
164              table:
165                  input format: org.apache.hadoop.mapred.TextInputFormat
166                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
167                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
168                  name: default.dest_j1
169
170
171PREHOOK: query: INSERT OVERWRITE TABLE dest_j1 
172SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
173FROM
174(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
175 FROM src1 x JOIN src y ON (x.key = y.key)) subq
176 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
177PREHOOK: type: QUERY
178PREHOOK: Input: default@src
179PREHOOK: Input: default@src1
180PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
181PREHOOK: Output: default@dest_j1
182POSTHOOK: query: INSERT OVERWRITE TABLE dest_j1 
183SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
184FROM
185(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
186 FROM src1 x JOIN src y ON (x.key = y.key)) subq
187 JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
188POSTHOOK: type: QUERY
189POSTHOOK: Input: default@src
190POSTHOOK: Input: default@src1
191POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
192POSTHOOK: Output: default@dest_j1
193POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
194POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
195PREHOOK: query: select * from dest_j1 x order by x.key
196PREHOOK: type: QUERY
197PREHOOK: Input: default@dest_j1
198PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-25_901_2052252208804412968/-mr-10000
199POSTHOOK: query: select * from dest_j1 x order by x.key
200POSTHOOK: type: QUERY
201POSTHOOK: Input: default@dest_j1
202POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-04-25_901_2052252208804412968/-mr-10000
203POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
204POSTHOOK: Lineage: dest_j1.value SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
205128	val_128
206128	val_128
207128	val_128
208128	val_128
209128	val_128
210128	val_128
211128	val_128
212128	val_128
213128	val_128
214146	val_146
215146	val_146
216146	val_146
217146	val_146
218150	val_150
219213	val_213
220213	val_213
221213	val_213
222213	val_213
223224	val_224
224224	val_224
225224	val_224
226224	val_224
227238	val_238
228238	val_238
229238	val_238
230238	val_238
231255	val_255
232255	val_255
233255	val_255
234255	val_255
235273	val_273
236273	val_273
237273	val_273
238273	val_273
239273	val_273
240273	val_273
241273	val_273
242273	val_273
243273	val_273
244278	val_278
245278	val_278
246278	val_278
247278	val_278
248311	val_311
249311	val_311
250311	val_311
251311	val_311
252311	val_311
253311	val_311
254311	val_311
255311	val_311
256311	val_311
257369	val_369
258369	val_369
259369	val_369
260369	val_369
261369	val_369
262369	val_369
263369	val_369
264369	val_369
265369	val_369
266401	val_401
267401	val_401
268401	val_401
269401	val_401
270401	val_401
271401	val_401
272401	val_401
273401	val_401
274401	val_401
275401	val_401
276401	val_401
277401	val_401
278401	val_401
279401	val_401
280401	val_401
281401	val_401
282401	val_401
283401	val_401
284401	val_401
285401	val_401
286401	val_401
287401	val_401
288401	val_401
289401	val_401
290401	val_401
291406	val_406
292406	val_406
293406	val_406
294406	val_406
295406	val_406
296406	val_406
297406	val_406
298406	val_406
299406	val_406
300406	val_406
301406	val_406
302406	val_406
303406	val_406
304406	val_406
305406	val_406
306406	val_406
30766	val_66
30898	val_98
30998	val_98
31098	val_98
31198	val_98