PageRenderTime 29ms CodeModel.GetById 15ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 674 lines | 634 code | 40 blank | 0 comment | 0 complexity | 247714c900be891dd8510f4cf9d04957 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_1 a join smb_bucket_2 b on a.key = b.key
 33PREHOOK: type: QUERY
 34POSTHOOK: query: explain
 35select /*+mapjoin(a)*/ * from smb_bucket_1 a join smb_bucket_2 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_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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_1 a join smb_bucket_2 b on a.key = b.key
 98PREHOOK: type: QUERY
 99PREHOOK: Input: default@smb_bucket_1
100PREHOOK: Input: default@smb_bucket_2
101PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-29_167_752156727267780024/-mr-10000
102POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
103POSTHOOK: type: QUERY
104POSTHOOK: Input: default@smb_bucket_1
105POSTHOOK: Input: default@smb_bucket_2
106POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-29_167_752156727267780024/-mr-10000
107PREHOOK: query: explain
108select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
109PREHOOK: type: QUERY
110POSTHOOK: query: explain
111select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
112POSTHOOK: type: QUERY
113ABSTRACT SYNTAX TREE:
114  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
115
116STAGE DEPENDENCIES:
117  Stage-1 is a root stage
118  Stage-0 is a root stage
119
120STAGE PLANS:
121  Stage: Stage-1
122    Map Reduce
123      Alias -> Map Operator Tree:
124        b 
125          TableScan
126            alias: b
127            Sorted Merge Bucket Map Join Operator
128              condition map:
129                   Left Outer Join0 to 1
130              condition expressions:
131                0 {key} {value}
132                1 {key} {value}
133              handleSkewJoin: false
134              keys:
135                0 [Column[key]]
136                1 [Column[key]]
137              outputColumnNames: _col0, _col1, _col4, _col5
138              Position of Big Table: 1
139              Select Operator
140                expressions:
141                      expr: _col0
142                      type: int
143                      expr: _col1
144                      type: string
145                      expr: _col4
146                      type: int
147                      expr: _col5
148                      type: string
149                outputColumnNames: _col0, _col1, _col4, _col5
150                Select Operator
151                  expressions:
152                        expr: _col0
153                        type: int
154                        expr: _col1
155                        type: string
156                        expr: _col4
157                        type: int
158                        expr: _col5
159                        type: string
160                  outputColumnNames: _col0, _col1, _col2, _col3
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
168  Stage: Stage-0
169    Fetch Operator
170      limit: -1
171
172
173PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
174PREHOOK: type: QUERY
175PREHOOK: Input: default@smb_bucket_1
176PREHOOK: Input: default@smb_bucket_2
177PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-32_889_1812554462573131330/-mr-10000
178POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
179POSTHOOK: type: QUERY
180POSTHOOK: Input: default@smb_bucket_1
181POSTHOOK: Input: default@smb_bucket_2
182POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-32_889_1812554462573131330/-mr-10000
1831	val_1	NULL	NULL
1843	val_3	NULL	NULL
1854	val_4	NULL	NULL
1865	val_5	NULL	NULL
18710	val_10	NULL	NULL
188PREHOOK: query: explain
189select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
190PREHOOK: type: QUERY
191POSTHOOK: query: explain
192select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
193POSTHOOK: type: QUERY
194ABSTRACT SYNTAX TREE:
195  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
196
197STAGE DEPENDENCIES:
198  Stage-1 is a root stage
199  Stage-0 is a root stage
200
201STAGE PLANS:
202  Stage: Stage-1
203    Map Reduce
204      Alias -> Map Operator Tree:
205        b 
206          TableScan
207            alias: b
208            Sorted Merge Bucket Map Join Operator
209              condition map:
210                   Right Outer Join0 to 1
211              condition expressions:
212                0 {key} {value}
213                1 {key} {value}
214              handleSkewJoin: false
215              keys:
216                0 [Column[key]]
217                1 [Column[key]]
218              outputColumnNames: _col0, _col1, _col4, _col5
219              Position of Big Table: 1
220              Select Operator
221                expressions:
222                      expr: _col0
223                      type: int
224                      expr: _col1
225                      type: string
226                      expr: _col4
227                      type: int
228                      expr: _col5
229                      type: string
230                outputColumnNames: _col0, _col1, _col4, _col5
231                Select Operator
232                  expressions:
233                        expr: _col0
234                        type: int
235                        expr: _col1
236                        type: string
237                        expr: _col4
238                        type: int
239                        expr: _col5
240                        type: string
241                  outputColumnNames: _col0, _col1, _col2, _col3
242                  File Output Operator
243                    compressed: false
244                    GlobalTableId: 0
245                    table:
246                        input format: org.apache.hadoop.mapred.TextInputFormat
247                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
248
249  Stage: Stage-0
250    Fetch Operator
251      limit: -1
252
253
254PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
255PREHOOK: type: QUERY
256PREHOOK: Input: default@smb_bucket_1
257PREHOOK: Input: default@smb_bucket_2
258PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-36_589_5275939814587625173/-mr-10000
259POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
260POSTHOOK: type: QUERY
261POSTHOOK: Input: default@smb_bucket_1
262POSTHOOK: Input: default@smb_bucket_2
263POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-36_589_5275939814587625173/-mr-10000
264NULL	NULL	20	val_20
265NULL	NULL	23	val_23
266NULL	NULL	25	val_25
267NULL	NULL	30	val_30
268PREHOOK: query: explain
269select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
270PREHOOK: type: QUERY
271POSTHOOK: query: explain
272select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
273POSTHOOK: type: QUERY
274ABSTRACT SYNTAX TREE:
275  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
276
277STAGE DEPENDENCIES:
278  Stage-1 is a root stage
279  Stage-0 is a root stage
280
281STAGE PLANS:
282  Stage: Stage-1
283    Map Reduce
284      Alias -> Map Operator Tree:
285        b 
286          TableScan
287            alias: b
288            Sorted Merge Bucket Map Join Operator
289              condition map:
290                   Outer Join 0 to 1
291              condition expressions:
292                0 {key} {value}
293                1 {key} {value}
294              handleSkewJoin: false
295              keys:
296                0 [Column[key]]
297                1 [Column[key]]
298              outputColumnNames: _col0, _col1, _col4, _col5
299              Position of Big Table: 1
300              Select Operator
301                expressions:
302                      expr: _col0
303                      type: int
304                      expr: _col1
305                      type: string
306                      expr: _col4
307                      type: int
308                      expr: _col5
309                      type: string
310                outputColumnNames: _col0, _col1, _col4, _col5
311                Select Operator
312                  expressions:
313                        expr: _col0
314                        type: int
315                        expr: _col1
316                        type: string
317                        expr: _col4
318                        type: int
319                        expr: _col5
320                        type: string
321                  outputColumnNames: _col0, _col1, _col2, _col3
322                  File Output Operator
323                    compressed: false
324                    GlobalTableId: 0
325                    table:
326                        input format: org.apache.hadoop.mapred.TextInputFormat
327                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
328
329  Stage: Stage-0
330    Fetch Operator
331      limit: -1
332
333
334PREHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
335PREHOOK: type: QUERY
336PREHOOK: Input: default@smb_bucket_1
337PREHOOK: Input: default@smb_bucket_2
338PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-40_382_2221552534542776306/-mr-10000
339POSTHOOK: query: select /*+mapjoin(a)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
340POSTHOOK: type: QUERY
341POSTHOOK: Input: default@smb_bucket_1
342POSTHOOK: Input: default@smb_bucket_2
343POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-40_382_2221552534542776306/-mr-10000
3441	val_1	NULL	NULL
3453	val_3	NULL	NULL
3464	val_4	NULL	NULL
3475	val_5	NULL	NULL
34810	val_10	NULL	NULL
349NULL	NULL	20	val_20
350NULL	NULL	23	val_23
351NULL	NULL	25	val_25
352NULL	NULL	30	val_30
353PREHOOK: query: explain
354select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
355PREHOOK: type: QUERY
356POSTHOOK: query: explain
357select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
358POSTHOOK: type: QUERY
359ABSTRACT SYNTAX TREE:
360  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
361
362STAGE DEPENDENCIES:
363  Stage-1 is a root stage
364  Stage-0 is a root stage
365
366STAGE PLANS:
367  Stage: Stage-1
368    Map Reduce
369      Alias -> Map Operator Tree:
370        a 
371          TableScan
372            alias: a
373            Sorted Merge Bucket Map Join Operator
374              condition map:
375                   Inner Join 0 to 1
376              condition expressions:
377                0 {key} {value}
378                1 {key} {value}
379              handleSkewJoin: false
380              keys:
381                0 [Column[key]]
382                1 [Column[key]]
383              outputColumnNames: _col0, _col1, _col4, _col5
384              Position of Big Table: 0
385              Select Operator
386                expressions:
387                      expr: _col0
388                      type: int
389                      expr: _col1
390                      type: string
391                      expr: _col4
392                      type: int
393                      expr: _col5
394                      type: string
395                outputColumnNames: _col0, _col1, _col4, _col5
396                Select Operator
397                  expressions:
398                        expr: _col0
399                        type: int
400                        expr: _col1
401                        type: string
402                        expr: _col4
403                        type: int
404                        expr: _col5
405                        type: string
406                  outputColumnNames: _col0, _col1, _col2, _col3
407                  File Output Operator
408                    compressed: false
409                    GlobalTableId: 0
410                    table:
411                        input format: org.apache.hadoop.mapred.TextInputFormat
412                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
413
414  Stage: Stage-0
415    Fetch Operator
416      limit: -1
417
418
419PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
420PREHOOK: type: QUERY
421PREHOOK: Input: default@smb_bucket_1
422PREHOOK: Input: default@smb_bucket_2
423PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-44_147_1762397188594212273/-mr-10000
424POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key
425POSTHOOK: type: QUERY
426POSTHOOK: Input: default@smb_bucket_1
427POSTHOOK: Input: default@smb_bucket_2
428POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-44_147_1762397188594212273/-mr-10000
429PREHOOK: query: explain
430select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
431PREHOOK: type: QUERY
432POSTHOOK: query: explain
433select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
434POSTHOOK: type: QUERY
435ABSTRACT SYNTAX TREE:
436  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
437
438STAGE DEPENDENCIES:
439  Stage-1 is a root stage
440  Stage-0 is a root stage
441
442STAGE PLANS:
443  Stage: Stage-1
444    Map Reduce
445      Alias -> Map Operator Tree:
446        a 
447          TableScan
448            alias: a
449            Sorted Merge Bucket Map Join Operator
450              condition map:
451                   Left Outer Join0 to 1
452              condition expressions:
453                0 {key} {value}
454                1 {key} {value}
455              handleSkewJoin: false
456              keys:
457                0 [Column[key]]
458                1 [Column[key]]
459              outputColumnNames: _col0, _col1, _col4, _col5
460              Position of Big Table: 0
461              Select Operator
462                expressions:
463                      expr: _col0
464                      type: int
465                      expr: _col1
466                      type: string
467                      expr: _col4
468                      type: int
469                      expr: _col5
470                      type: string
471                outputColumnNames: _col0, _col1, _col4, _col5
472                Select Operator
473                  expressions:
474                        expr: _col0
475                        type: int
476                        expr: _col1
477                        type: string
478                        expr: _col4
479                        type: int
480                        expr: _col5
481                        type: string
482                  outputColumnNames: _col0, _col1, _col2, _col3
483                  File Output Operator
484                    compressed: false
485                    GlobalTableId: 0
486                    table:
487                        input format: org.apache.hadoop.mapred.TextInputFormat
488                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
489
490  Stage: Stage-0
491    Fetch Operator
492      limit: -1
493
494
495PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
496PREHOOK: type: QUERY
497PREHOOK: Input: default@smb_bucket_1
498PREHOOK: Input: default@smb_bucket_2
499PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-47_941_502078495225567485/-mr-10000
500POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key
501POSTHOOK: type: QUERY
502POSTHOOK: Input: default@smb_bucket_1
503POSTHOOK: Input: default@smb_bucket_2
504POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-47_941_502078495225567485/-mr-10000
5051	val_1	NULL	NULL
5063	val_3	NULL	NULL
5074	val_4	NULL	NULL
5085	val_5	NULL	NULL
50910	val_10	NULL	NULL
510PREHOOK: query: explain
511select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
512PREHOOK: type: QUERY
513POSTHOOK: query: explain
514select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
515POSTHOOK: type: QUERY
516ABSTRACT SYNTAX TREE:
517  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
518
519STAGE DEPENDENCIES:
520  Stage-1 is a root stage
521  Stage-0 is a root stage
522
523STAGE PLANS:
524  Stage: Stage-1
525    Map Reduce
526      Alias -> Map Operator Tree:
527        a 
528          TableScan
529            alias: a
530            Sorted Merge Bucket Map Join Operator
531              condition map:
532                   Right Outer Join0 to 1
533              condition expressions:
534                0 {key} {value}
535                1 {key} {value}
536              handleSkewJoin: false
537              keys:
538                0 [Column[key]]
539                1 [Column[key]]
540              outputColumnNames: _col0, _col1, _col4, _col5
541              Position of Big Table: 0
542              Select Operator
543                expressions:
544                      expr: _col0
545                      type: int
546                      expr: _col1
547                      type: string
548                      expr: _col4
549                      type: int
550                      expr: _col5
551                      type: string
552                outputColumnNames: _col0, _col1, _col4, _col5
553                Select Operator
554                  expressions:
555                        expr: _col0
556                        type: int
557                        expr: _col1
558                        type: string
559                        expr: _col4
560                        type: int
561                        expr: _col5
562                        type: string
563                  outputColumnNames: _col0, _col1, _col2, _col3
564                  File Output Operator
565                    compressed: false
566                    GlobalTableId: 0
567                    table:
568                        input format: org.apache.hadoop.mapred.TextInputFormat
569                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
570
571  Stage: Stage-0
572    Fetch Operator
573      limit: -1
574
575
576PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
577PREHOOK: type: QUERY
578PREHOOK: Input: default@smb_bucket_1
579PREHOOK: Input: default@smb_bucket_2
580PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-51_651_8103397847246451132/-mr-10000
581POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key
582POSTHOOK: type: QUERY
583POSTHOOK: Input: default@smb_bucket_1
584POSTHOOK: Input: default@smb_bucket_2
585POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-51_651_8103397847246451132/-mr-10000
586NULL	NULL	20	val_20
587NULL	NULL	23	val_23
588NULL	NULL	25	val_25
589NULL	NULL	30	val_30
590PREHOOK: query: explain
591select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
592PREHOOK: type: QUERY
593POSTHOOK: query: explain
594select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
595POSTHOOK: type: QUERY
596ABSTRACT SYNTAX TREE:
597  (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) 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))))
598
599STAGE DEPENDENCIES:
600  Stage-1 is a root stage
601  Stage-0 is a root stage
602
603STAGE PLANS:
604  Stage: Stage-1
605    Map Reduce
606      Alias -> Map Operator Tree:
607        a 
608          TableScan
609            alias: a
610            Sorted Merge Bucket Map Join Operator
611              condition map:
612                   Outer Join 0 to 1
613              condition expressions:
614                0 {key} {value}
615                1 {key} {value}
616              handleSkewJoin: false
617              keys:
618                0 [Column[key]]
619                1 [Column[key]]
620              outputColumnNames: _col0, _col1, _col4, _col5
621              Position of Big Table: 0
622              Select Operator
623                expressions:
624                      expr: _col0
625                      type: int
626                      expr: _col1
627                      type: string
628                      expr: _col4
629                      type: int
630                      expr: _col5
631                      type: string
632                outputColumnNames: _col0, _col1, _col4, _col5
633                Select Operator
634                  expressions:
635                        expr: _col0
636                        type: int
637                        expr: _col1
638                        type: string
639                        expr: _col4
640                        type: int
641                        expr: _col5
642                        type: string
643                  outputColumnNames: _col0, _col1, _col2, _col3
644                  File Output Operator
645                    compressed: false
646                    GlobalTableId: 0
647                    table:
648                        input format: org.apache.hadoop.mapred.TextInputFormat
649                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
650
651  Stage: Stage-0
652    Fetch Operator
653      limit: -1
654
655
656PREHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
657PREHOOK: type: QUERY
658PREHOOK: Input: default@smb_bucket_1
659PREHOOK: Input: default@smb_bucket_2
660PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-55_403_7769905140031147317/-mr-10000
661POSTHOOK: query: select /*+mapjoin(b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key
662POSTHOOK: type: QUERY
663POSTHOOK: Input: default@smb_bucket_1
664POSTHOOK: Input: default@smb_bucket_2
665POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-13-55_403_7769905140031147317/-mr-10000
6661	val_1	NULL	NULL
6673	val_3	NULL	NULL
6684	val_4	NULL	NULL
6695	val_5	NULL	NULL
67010	val_10	NULL	NULL
671NULL	NULL	20	val_20
672NULL	NULL	23	val_23
673NULL	NULL	25	val_25
674NULL	NULL	30	val_30