PageRenderTime 34ms CodeModel.GetById 13ms app.highlight 12ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 678 lines | 638 code | 40 blank | 0 comment | 0 complexity | 2229da30a221fb92f9b523d6faf8563c MD5 | raw file
  1PREHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@smb_bucket_1
  6PREHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@smb_bucket_2
 11PREHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
 12PREHOOK: type: CREATETABLE
 13POSTHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
 14POSTHOOK: type: CREATETABLE
 15POSTHOOK: Output: default@smb_bucket_3
 16PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
 17PREHOOK: type: LOAD
 18POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
 19POSTHOOK: type: LOAD
 20POSTHOOK: Output: default@smb_bucket_1
 21PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
 22PREHOOK: type: LOAD
 23POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
 24POSTHOOK: type: LOAD
 25POSTHOOK: Output: default@smb_bucket_2
 26PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
 27PREHOOK: type: LOAD
 28POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
 29POSTHOOK: type: LOAD
 30POSTHOOK: Output: default@smb_bucket_3
 31PREHOOK: query: explain
 32select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
 33PREHOOK: type: QUERY
 34POSTHOOK: query: explain
 35select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
 36POSTHOOK: type: QUERY
 37ABSTRACT SYNTAX TREE:
 38  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
 39
 40STAGE DEPENDENCIES:
 41  Stage-1 is a root stage
 42  Stage-0 is a root stage
 43
 44STAGE PLANS:
 45  Stage: Stage-1
 46    Map Reduce
 47      Alias -> Map Operator Tree:
 48        b 
 49          TableScan
 50            alias: b
 51            Sorted Merge Bucket Map Join Operator
 52              condition map:
 53                   Inner Join 0 to 1
 54              condition expressions:
 55                0 {key} {value}
 56                1 {key} {value}
 57              handleSkewJoin: false
 58              keys:
 59                0 [Column[key]]
 60                1 [Column[key]]
 61              outputColumnNames: _col0, _col1, _col4, _col5
 62              Position of Big Table: 1
 63              Select Operator
 64                expressions:
 65                      expr: _col0
 66                      type: int
 67                      expr: _col1
 68                      type: string
 69                      expr: _col4
 70                      type: int
 71                      expr: _col5
 72                      type: string
 73                outputColumnNames: _col0, _col1, _col4, _col5
 74                Select Operator
 75                  expressions:
 76                        expr: _col0
 77                        type: int
 78                        expr: _col1
 79                        type: string
 80                        expr: _col4
 81                        type: int
 82                        expr: _col5
 83                        type: string
 84                  outputColumnNames: _col0, _col1, _col2, _col3
 85                  File Output Operator
 86                    compressed: false
 87                    GlobalTableId: 0
 88                    table:
 89                        input format: org.apache.hadoop.mapred.TextInputFormat
 90                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 91
 92  Stage: Stage-0
 93    Fetch Operator
 94      limit: -1
 95
 96
 97PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
 98PREHOOK: type: QUERY
 99PREHOOK: Input: default@smb_bucket_2
100PREHOOK: Input: default@smb_bucket_3
101PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-33_903_1138693698506673924/-mr-10000
102POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
103POSTHOOK: type: QUERY
104POSTHOOK: Input: default@smb_bucket_2
105POSTHOOK: Input: default@smb_bucket_3
106POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-33_903_1138693698506673924/-mr-10000
10720	val_20	20	val_20
10823	val_23	23	val_23
109PREHOOK: query: explain
110select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
111PREHOOK: type: QUERY
112POSTHOOK: query: explain
113select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
114POSTHOOK: type: QUERY
115ABSTRACT SYNTAX TREE:
116  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
117
118STAGE DEPENDENCIES:
119  Stage-1 is a root stage
120  Stage-0 is a root stage
121
122STAGE PLANS:
123  Stage: Stage-1
124    Map Reduce
125      Alias -> Map Operator Tree:
126        b 
127          TableScan
128            alias: b
129            Sorted Merge Bucket Map Join Operator
130              condition map:
131                   Left Outer Join0 to 1
132              condition expressions:
133                0 {key} {value}
134                1 {key} {value}
135              handleSkewJoin: false
136              keys:
137                0 [Column[key]]
138                1 [Column[key]]
139              outputColumnNames: _col0, _col1, _col4, _col5
140              Position of Big Table: 1
141              Select Operator
142                expressions:
143                      expr: _col0
144                      type: int
145                      expr: _col1
146                      type: string
147                      expr: _col4
148                      type: int
149                      expr: _col5
150                      type: string
151                outputColumnNames: _col0, _col1, _col4, _col5
152                Select Operator
153                  expressions:
154                        expr: _col0
155                        type: int
156                        expr: _col1
157                        type: string
158                        expr: _col4
159                        type: int
160                        expr: _col5
161                        type: string
162                  outputColumnNames: _col0, _col1, _col2, _col3
163                  File Output Operator
164                    compressed: false
165                    GlobalTableId: 0
166                    table:
167                        input format: org.apache.hadoop.mapred.TextInputFormat
168                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
169
170  Stage: Stage-0
171    Fetch Operator
172      limit: -1
173
174
175PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
176PREHOOK: type: QUERY
177PREHOOK: Input: default@smb_bucket_2
178PREHOOK: Input: default@smb_bucket_3
179PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-37_686_8728396124278664970/-mr-10000
180POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
181POSTHOOK: type: QUERY
182POSTHOOK: Input: default@smb_bucket_2
183POSTHOOK: Input: default@smb_bucket_3
184POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-37_686_8728396124278664970/-mr-10000
18520	val_20	20	val_20
18623	val_23	23	val_23
18725	val_25	NULL	NULL
18830	val_30	NULL	NULL
189PREHOOK: query: explain
190select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
191PREHOOK: type: QUERY
192POSTHOOK: query: explain
193select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
194POSTHOOK: type: QUERY
195ABSTRACT SYNTAX TREE:
196  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
197
198STAGE DEPENDENCIES:
199  Stage-1 is a root stage
200  Stage-0 is a root stage
201
202STAGE PLANS:
203  Stage: Stage-1
204    Map Reduce
205      Alias -> Map Operator Tree:
206        b 
207          TableScan
208            alias: b
209            Sorted Merge Bucket Map Join Operator
210              condition map:
211                   Right Outer Join0 to 1
212              condition expressions:
213                0 {key} {value}
214                1 {key} {value}
215              handleSkewJoin: false
216              keys:
217                0 [Column[key]]
218                1 [Column[key]]
219              outputColumnNames: _col0, _col1, _col4, _col5
220              Position of Big Table: 1
221              Select Operator
222                expressions:
223                      expr: _col0
224                      type: int
225                      expr: _col1
226                      type: string
227                      expr: _col4
228                      type: int
229                      expr: _col5
230                      type: string
231                outputColumnNames: _col0, _col1, _col4, _col5
232                Select Operator
233                  expressions:
234                        expr: _col0
235                        type: int
236                        expr: _col1
237                        type: string
238                        expr: _col4
239                        type: int
240                        expr: _col5
241                        type: string
242                  outputColumnNames: _col0, _col1, _col2, _col3
243                  File Output Operator
244                    compressed: false
245                    GlobalTableId: 0
246                    table:
247                        input format: org.apache.hadoop.mapred.TextInputFormat
248                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
249
250  Stage: Stage-0
251    Fetch Operator
252      limit: -1
253
254
255PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
256PREHOOK: type: QUERY
257PREHOOK: Input: default@smb_bucket_2
258PREHOOK: Input: default@smb_bucket_3
259PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-41_395_2162571660794845709/-mr-10000
260POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
261POSTHOOK: type: QUERY
262POSTHOOK: Input: default@smb_bucket_2
263POSTHOOK: Input: default@smb_bucket_3
264POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-41_395_2162571660794845709/-mr-10000
265NULL	NULL	4	val_4
266NULL	NULL	10	val_10
267NULL	NULL	17	val_17
268NULL	NULL	19	val_19
26920	val_20	20	val_20
27023	val_23	23	val_23
271PREHOOK: query: explain
272select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
273PREHOOK: type: QUERY
274POSTHOOK: query: explain
275select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
276POSTHOOK: type: QUERY
277ABSTRACT SYNTAX TREE:
278  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
279
280STAGE DEPENDENCIES:
281  Stage-1 is a root stage
282  Stage-0 is a root stage
283
284STAGE PLANS:
285  Stage: Stage-1
286    Map Reduce
287      Alias -> Map Operator Tree:
288        b 
289          TableScan
290            alias: b
291            Sorted Merge Bucket Map Join Operator
292              condition map:
293                   Outer Join 0 to 1
294              condition expressions:
295                0 {key} {value}
296                1 {key} {value}
297              handleSkewJoin: false
298              keys:
299                0 [Column[key]]
300                1 [Column[key]]
301              outputColumnNames: _col0, _col1, _col4, _col5
302              Position of Big Table: 1
303              Select Operator
304                expressions:
305                      expr: _col0
306                      type: int
307                      expr: _col1
308                      type: string
309                      expr: _col4
310                      type: int
311                      expr: _col5
312                      type: string
313                outputColumnNames: _col0, _col1, _col4, _col5
314                Select Operator
315                  expressions:
316                        expr: _col0
317                        type: int
318                        expr: _col1
319                        type: string
320                        expr: _col4
321                        type: int
322                        expr: _col5
323                        type: string
324                  outputColumnNames: _col0, _col1, _col2, _col3
325                  File Output Operator
326                    compressed: false
327                    GlobalTableId: 0
328                    table:
329                        input format: org.apache.hadoop.mapred.TextInputFormat
330                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
331
332  Stage: Stage-0
333    Fetch Operator
334      limit: -1
335
336
337PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
338PREHOOK: type: QUERY
339PREHOOK: Input: default@smb_bucket_2
340PREHOOK: Input: default@smb_bucket_3
341PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-45_157_7985034747002218509/-mr-10000
342POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
343POSTHOOK: type: QUERY
344POSTHOOK: Input: default@smb_bucket_2
345POSTHOOK: Input: default@smb_bucket_3
346POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-45_157_7985034747002218509/-mr-10000
347NULL	NULL	4	val_4
348NULL	NULL	10	val_10
349NULL	NULL	17	val_17
350NULL	NULL	19	val_19
35120	val_20	20	val_20
35223	val_23	23	val_23
35325	val_25	NULL	NULL
35430	val_30	NULL	NULL
355PREHOOK: query: explain
356select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
357PREHOOK: type: QUERY
358POSTHOOK: query: explain
359select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
360POSTHOOK: type: QUERY
361ABSTRACT SYNTAX TREE:
362  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b))) (TOK_SELEXPR TOK_ALLCOLREF))))
363
364STAGE DEPENDENCIES:
365  Stage-1 is a root stage
366  Stage-0 is a root stage
367
368STAGE PLANS:
369  Stage: Stage-1
370    Map Reduce
371      Alias -> Map Operator Tree:
372        a 
373          TableScan
374            alias: a
375            Sorted Merge Bucket Map Join Operator
376              condition map:
377                   Inner Join 0 to 1
378              condition expressions:
379                0 {key} {value}
380                1 {key} {value}
381              handleSkewJoin: false
382              keys:
383                0 [Column[key]]
384                1 [Column[key]]
385              outputColumnNames: _col0, _col1, _col4, _col5
386              Position of Big Table: 0
387              Select Operator
388                expressions:
389                      expr: _col0
390                      type: int
391                      expr: _col1
392                      type: string
393                      expr: _col4
394                      type: int
395                      expr: _col5
396                      type: string
397                outputColumnNames: _col0, _col1, _col4, _col5
398                Select Operator
399                  expressions:
400                        expr: _col0
401                        type: int
402                        expr: _col1
403                        type: string
404                        expr: _col4
405                        type: int
406                        expr: _col5
407                        type: string
408                  outputColumnNames: _col0, _col1, _col2, _col3
409                  File Output Operator
410                    compressed: false
411                    GlobalTableId: 0
412                    table:
413                        input format: org.apache.hadoop.mapred.TextInputFormat
414                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
415
416  Stage: Stage-0
417    Fetch Operator
418      limit: -1
419
420
421PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
422PREHOOK: type: QUERY
423PREHOOK: Input: default@smb_bucket_2
424PREHOOK: Input: default@smb_bucket_3
425PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-48_908_4881349610971628783/-mr-10000
426POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a join smb_bucket_3 b on a.key = b.key
427POSTHOOK: type: QUERY
428POSTHOOK: Input: default@smb_bucket_2
429POSTHOOK: Input: default@smb_bucket_3
430POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-48_908_4881349610971628783/-mr-10000
43120	val_20	20	val_20
43223	val_23	23	val_23
433PREHOOK: query: explain
434select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
435PREHOOK: type: QUERY
436POSTHOOK: query: explain
437select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
438POSTHOOK: type: QUERY
439ABSTRACT SYNTAX TREE:
440  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b))) (TOK_SELEXPR TOK_ALLCOLREF))))
441
442STAGE DEPENDENCIES:
443  Stage-1 is a root stage
444  Stage-0 is a root stage
445
446STAGE PLANS:
447  Stage: Stage-1
448    Map Reduce
449      Alias -> Map Operator Tree:
450        a 
451          TableScan
452            alias: a
453            Sorted Merge Bucket Map Join Operator
454              condition map:
455                   Left Outer Join0 to 1
456              condition expressions:
457                0 {key} {value}
458                1 {key} {value}
459              handleSkewJoin: false
460              keys:
461                0 [Column[key]]
462                1 [Column[key]]
463              outputColumnNames: _col0, _col1, _col4, _col5
464              Position of Big Table: 0
465              Select Operator
466                expressions:
467                      expr: _col0
468                      type: int
469                      expr: _col1
470                      type: string
471                      expr: _col4
472                      type: int
473                      expr: _col5
474                      type: string
475                outputColumnNames: _col0, _col1, _col4, _col5
476                Select Operator
477                  expressions:
478                        expr: _col0
479                        type: int
480                        expr: _col1
481                        type: string
482                        expr: _col4
483                        type: int
484                        expr: _col5
485                        type: string
486                  outputColumnNames: _col0, _col1, _col2, _col3
487                  File Output Operator
488                    compressed: false
489                    GlobalTableId: 0
490                    table:
491                        input format: org.apache.hadoop.mapred.TextInputFormat
492                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
493
494  Stage: Stage-0
495    Fetch Operator
496      limit: -1
497
498
499PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
500PREHOOK: type: QUERY
501PREHOOK: Input: default@smb_bucket_2
502PREHOOK: Input: default@smb_bucket_3
503PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-52_664_2358717432796091697/-mr-10000
504POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a left outer join smb_bucket_3 b on a.key = b.key
505POSTHOOK: type: QUERY
506POSTHOOK: Input: default@smb_bucket_2
507POSTHOOK: Input: default@smb_bucket_3
508POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-52_664_2358717432796091697/-mr-10000
50920	val_20	20	val_20
51023	val_23	23	val_23
51125	val_25	NULL	NULL
51230	val_30	NULL	NULL
513PREHOOK: query: explain
514select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
515PREHOOK: type: QUERY
516POSTHOOK: query: explain
517select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
518POSTHOOK: type: QUERY
519ABSTRACT SYNTAX TREE:
520  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b))) (TOK_SELEXPR TOK_ALLCOLREF))))
521
522STAGE DEPENDENCIES:
523  Stage-1 is a root stage
524  Stage-0 is a root stage
525
526STAGE PLANS:
527  Stage: Stage-1
528    Map Reduce
529      Alias -> Map Operator Tree:
530        a 
531          TableScan
532            alias: a
533            Sorted Merge Bucket Map Join Operator
534              condition map:
535                   Right Outer Join0 to 1
536              condition expressions:
537                0 {key} {value}
538                1 {key} {value}
539              handleSkewJoin: false
540              keys:
541                0 [Column[key]]
542                1 [Column[key]]
543              outputColumnNames: _col0, _col1, _col4, _col5
544              Position of Big Table: 0
545              Select Operator
546                expressions:
547                      expr: _col0
548                      type: int
549                      expr: _col1
550                      type: string
551                      expr: _col4
552                      type: int
553                      expr: _col5
554                      type: string
555                outputColumnNames: _col0, _col1, _col4, _col5
556                Select Operator
557                  expressions:
558                        expr: _col0
559                        type: int
560                        expr: _col1
561                        type: string
562                        expr: _col4
563                        type: int
564                        expr: _col5
565                        type: string
566                  outputColumnNames: _col0, _col1, _col2, _col3
567                  File Output Operator
568                    compressed: false
569                    GlobalTableId: 0
570                    table:
571                        input format: org.apache.hadoop.mapred.TextInputFormat
572                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
573
574  Stage: Stage-0
575    Fetch Operator
576      limit: -1
577
578
579PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
580PREHOOK: type: QUERY
581PREHOOK: Input: default@smb_bucket_2
582PREHOOK: Input: default@smb_bucket_3
583PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-56_419_7043985017130316144/-mr-10000
584POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a right outer join smb_bucket_3 b on a.key = b.key
585POSTHOOK: type: QUERY
586POSTHOOK: Input: default@smb_bucket_2
587POSTHOOK: Input: default@smb_bucket_3
588POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-14-56_419_7043985017130316144/-mr-10000
589NULL	NULL	4	val_4
590NULL	NULL	10	val_10
591NULL	NULL	17	val_17
592NULL	NULL	19	val_19
59320	val_20	20	val_20
59423	val_23	23	val_23
595PREHOOK: query: explain
596select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
597PREHOOK: type: QUERY
598POSTHOOK: query: explain
599select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
600POSTHOOK: type: QUERY
601ABSTRACT SYNTAX TREE:
602  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) a) (TOK_TABREF (TOK_TABNAME smb_bucket_3) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST b))) (TOK_SELEXPR TOK_ALLCOLREF))))
603
604STAGE DEPENDENCIES:
605  Stage-1 is a root stage
606  Stage-0 is a root stage
607
608STAGE PLANS:
609  Stage: Stage-1
610    Map Reduce
611      Alias -> Map Operator Tree:
612        a 
613          TableScan
614            alias: a
615            Sorted Merge Bucket Map Join Operator
616              condition map:
617                   Outer Join 0 to 1
618              condition expressions:
619                0 {key} {value}
620                1 {key} {value}
621              handleSkewJoin: false
622              keys:
623                0 [Column[key]]
624                1 [Column[key]]
625              outputColumnNames: _col0, _col1, _col4, _col5
626              Position of Big Table: 0
627              Select Operator
628                expressions:
629                      expr: _col0
630                      type: int
631                      expr: _col1
632                      type: string
633                      expr: _col4
634                      type: int
635                      expr: _col5
636                      type: string
637                outputColumnNames: _col0, _col1, _col4, _col5
638                Select Operator
639                  expressions:
640                        expr: _col0
641                        type: int
642                        expr: _col1
643                        type: string
644                        expr: _col4
645                        type: int
646                        expr: _col5
647                        type: string
648                  outputColumnNames: _col0, _col1, _col2, _col3
649                  File Output Operator
650                    compressed: false
651                    GlobalTableId: 0
652                    table:
653                        input format: org.apache.hadoop.mapred.TextInputFormat
654                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
655
656  Stage: Stage-0
657    Fetch Operator
658      limit: -1
659
660
661PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
662PREHOOK: type: QUERY
663PREHOOK: Input: default@smb_bucket_2
664PREHOOK: Input: default@smb_bucket_3
665PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-15-00_136_2243433820879030156/-mr-10000
666POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_2 a full outer join smb_bucket_3 b on a.key = b.key
667POSTHOOK: type: QUERY
668POSTHOOK: Input: default@smb_bucket_2
669POSTHOOK: Input: default@smb_bucket_3
670POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-15-00_136_2243433820879030156/-mr-10000
671NULL	NULL	4	val_4
672NULL	NULL	10	val_10
673NULL	NULL	17	val_17
674NULL	NULL	19	val_19
67520	val_20	20	val_20
67623	val_23	23	val_23
67725	val_25	NULL	NULL
67830	val_30	NULL	NULL