PageRenderTime 33ms CodeModel.GetById 8ms app.highlight 14ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 827 lines | 797 code | 30 blank | 0 comment | 0 complexity | b9b8ec71c0790dbd85979c4e7303dcbc MD5 | raw file
  1PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@T1
  6PREHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@T2
 11PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
 12PREHOOK: type: CREATETABLE
 13POSTHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
 14POSTHOOK: type: CREATETABLE
 15POSTHOOK: Output: default@T3
 16PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
 17PREHOOK: type: LOAD
 18PREHOOK: Output: default@t1
 19POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
 20POSTHOOK: type: LOAD
 21POSTHOOK: Output: default@t1
 22PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
 23PREHOOK: type: LOAD
 24PREHOOK: Output: default@t2
 25POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
 26POSTHOOK: type: LOAD
 27POSTHOOK: Output: default@t2
 28PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
 29PREHOOK: type: LOAD
 30PREHOOK: Output: default@t3
 31POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
 32POSTHOOK: type: LOAD
 33POSTHOOK: Output: default@t3
 34PREHOOK: query: EXPLAIN FROM T1 a JOIN src c ON c.key+1=a.key
 35SELECT a.key, a.val, c.key
 36PREHOOK: type: QUERY
 37POSTHOOK: query: EXPLAIN FROM T1 a JOIN src c ON c.key+1=a.key
 38SELECT a.key, a.val, c.key
 39POSTHOOK: type: QUERY
 40ABSTRACT SYNTAX TREE:
 41  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME src) c) (= (+ (. (TOK_TABLE_OR_COL c) key) 1) (. (TOK_TABLE_OR_COL a) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) val)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key)))))
 42
 43STAGE DEPENDENCIES:
 44  Stage-1 is a root stage
 45  Stage-0 is a root stage
 46
 47STAGE PLANS:
 48  Stage: Stage-1
 49    Map Reduce
 50      Alias -> Map Operator Tree:
 51        a 
 52          TableScan
 53            alias: a
 54            Reduce Output Operator
 55              key expressions:
 56                    expr: UDFToDouble(key)
 57                    type: double
 58              sort order: +
 59              Map-reduce partition columns:
 60                    expr: UDFToDouble(key)
 61                    type: double
 62              tag: 0
 63              value expressions:
 64                    expr: key
 65                    type: string
 66                    expr: val
 67                    type: string
 68        c 
 69          TableScan
 70            alias: c
 71            Reduce Output Operator
 72              key expressions:
 73                    expr: (key + 1)
 74                    type: double
 75              sort order: +
 76              Map-reduce partition columns:
 77                    expr: (key + 1)
 78                    type: double
 79              tag: 1
 80              value expressions:
 81                    expr: key
 82                    type: string
 83      Reduce Operator Tree:
 84        Join Operator
 85          condition map:
 86               Inner Join 0 to 1
 87          condition expressions:
 88            0 {VALUE._col0} {VALUE._col1}
 89            1 {VALUE._col0}
 90          handleSkewJoin: false
 91          outputColumnNames: _col0, _col1, _col4
 92          Select Operator
 93            expressions:
 94                  expr: _col0
 95                  type: string
 96                  expr: _col1
 97                  type: string
 98                  expr: _col4
 99                  type: string
100            outputColumnNames: _col0, _col1, _col2
101            File Output Operator
102              compressed: false
103              GlobalTableId: 0
104              table:
105                  input format: org.apache.hadoop.mapred.TextInputFormat
106                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
107
108  Stage: Stage-0
109    Fetch Operator
110      limit: -1
111
112
113PREHOOK: query: EXPLAIN FROM T1 a JOIN src c ON c.key+1=a.key
114SELECT /*+ STREAMTABLE(a) */ a.key, a.val, c.key
115PREHOOK: type: QUERY
116POSTHOOK: query: EXPLAIN FROM T1 a JOIN src c ON c.key+1=a.key
117SELECT /*+ STREAMTABLE(a) */ a.key, a.val, c.key
118POSTHOOK: type: QUERY
119ABSTRACT SYNTAX TREE:
120  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME src) c) (= (+ (. (TOK_TABLE_OR_COL c) key) 1) (. (TOK_TABLE_OR_COL a) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) val)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key)))))
121
122STAGE DEPENDENCIES:
123  Stage-1 is a root stage
124  Stage-0 is a root stage
125
126STAGE PLANS:
127  Stage: Stage-1
128    Map Reduce
129      Alias -> Map Operator Tree:
130        a 
131          TableScan
132            alias: a
133            Reduce Output Operator
134              key expressions:
135                    expr: UDFToDouble(key)
136                    type: double
137              sort order: +
138              Map-reduce partition columns:
139                    expr: UDFToDouble(key)
140                    type: double
141              tag: 1
142              value expressions:
143                    expr: key
144                    type: string
145                    expr: val
146                    type: string
147        c 
148          TableScan
149            alias: c
150            Reduce Output Operator
151              key expressions:
152                    expr: (key + 1)
153                    type: double
154              sort order: +
155              Map-reduce partition columns:
156                    expr: (key + 1)
157                    type: double
158              tag: 0
159              value expressions:
160                    expr: key
161                    type: string
162      Reduce Operator Tree:
163        Join Operator
164          condition map:
165               Inner Join 0 to 1
166          condition expressions:
167            0 {VALUE._col0} {VALUE._col1}
168            1 {VALUE._col0}
169          handleSkewJoin: false
170          outputColumnNames: _col0, _col1, _col4
171          Select Operator
172            expressions:
173                  expr: _col0
174                  type: string
175                  expr: _col1
176                  type: string
177                  expr: _col4
178                  type: string
179            outputColumnNames: _col0, _col1, _col2
180            File Output Operator
181              compressed: false
182              GlobalTableId: 0
183              table:
184                  input format: org.apache.hadoop.mapred.TextInputFormat
185                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
186
187  Stage: Stage-0
188    Fetch Operator
189      limit: -1
190
191
192PREHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
193SELECT a.key, a.val, c.key
194PREHOOK: type: QUERY
195PREHOOK: Input: default@src
196PREHOOK: Input: default@t1
197PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-31_623_2837080214858318814/-mr-10000
198POSTHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
199SELECT a.key, a.val, c.key
200POSTHOOK: type: QUERY
201POSTHOOK: Input: default@src
202POSTHOOK: Input: default@t1
203POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-31_623_2837080214858318814/-mr-10000
2041	11	0
2051	11	0
2061	11	0
2073	13	2
208PREHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
209SELECT /*+ STREAMTABLE(a) */ a.key, a.val, c.key
210PREHOOK: type: QUERY
211PREHOOK: Input: default@src
212PREHOOK: Input: default@t1
213PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-34_698_3624981517859141195/-mr-10000
214POSTHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key
215SELECT /*+ STREAMTABLE(a) */ a.key, a.val, c.key
216POSTHOOK: type: QUERY
217POSTHOOK: Input: default@src
218POSTHOOK: Input: default@t1
219POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-34_698_3624981517859141195/-mr-10000
2201	11	0
2211	11	0
2221	11	0
2233	13	2
224PREHOOK: query: EXPLAIN FROM T1 a
225  LEFT OUTER JOIN T2 b ON (b.key=a.key)
226  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
227SELECT a.key, b.key, a.val, c.val
228PREHOOK: type: QUERY
229POSTHOOK: query: EXPLAIN FROM T1 a
230  LEFT OUTER JOIN T2 b ON (b.key=a.key)
231  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
232SELECT a.key, b.key, a.val, c.val
233POSTHOOK: type: QUERY
234ABSTRACT SYNTAX TREE:
235  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL a) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL c) val) (. (TOK_TABLE_OR_COL a) val)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) val)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) val)))))
236
237STAGE DEPENDENCIES:
238  Stage-1 is a root stage
239  Stage-2 depends on stages: Stage-1
240  Stage-0 is a root stage
241
242STAGE PLANS:
243  Stage: Stage-1
244    Map Reduce
245      Alias -> Map Operator Tree:
246        a 
247          TableScan
248            alias: a
249            Reduce Output Operator
250              key expressions:
251                    expr: key
252                    type: string
253              sort order: +
254              Map-reduce partition columns:
255                    expr: key
256                    type: string
257              tag: 0
258              value expressions:
259                    expr: key
260                    type: string
261                    expr: val
262                    type: string
263        b 
264          TableScan
265            alias: b
266            Reduce Output Operator
267              key expressions:
268                    expr: key
269                    type: string
270              sort order: +
271              Map-reduce partition columns:
272                    expr: key
273                    type: string
274              tag: 1
275              value expressions:
276                    expr: key
277                    type: string
278      Reduce Operator Tree:
279        Join Operator
280          condition map:
281               Left Outer Join0 to 1
282          condition expressions:
283            0 {VALUE._col0} {VALUE._col1}
284            1 {VALUE._col0}
285          handleSkewJoin: false
286          outputColumnNames: _col0, _col1, _col4
287          File Output Operator
288            compressed: false
289            GlobalTableId: 0
290            table:
291                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
292                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
293
294  Stage: Stage-2
295    Map Reduce
296      Alias -> Map Operator Tree:
297        $INTNAME 
298            Reduce Output Operator
299              key expressions:
300                    expr: _col1
301                    type: string
302              sort order: +
303              Map-reduce partition columns:
304                    expr: _col1
305                    type: string
306              tag: 0
307              value expressions:
308                    expr: _col4
309                    type: string
310                    expr: _col0
311                    type: string
312                    expr: _col1
313                    type: string
314        c 
315          TableScan
316            alias: c
317            Reduce Output Operator
318              key expressions:
319                    expr: val
320                    type: string
321              sort order: +
322              Map-reduce partition columns:
323                    expr: val
324                    type: string
325              tag: 1
326              value expressions:
327                    expr: val
328                    type: string
329      Reduce Operator Tree:
330        Join Operator
331          condition map:
332               Right Outer Join0 to 1
333          condition expressions:
334            0 {VALUE._col0} {VALUE._col4} {VALUE._col5}
335            1 {VALUE._col1}
336          handleSkewJoin: false
337          outputColumnNames: _col0, _col4, _col5, _col9
338          Select Operator
339            expressions:
340                  expr: _col4
341                  type: string
342                  expr: _col0
343                  type: string
344                  expr: _col5
345                  type: string
346                  expr: _col9
347                  type: string
348            outputColumnNames: _col0, _col1, _col2, _col3
349            File Output Operator
350              compressed: false
351              GlobalTableId: 0
352              table:
353                  input format: org.apache.hadoop.mapred.TextInputFormat
354                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
355
356  Stage: Stage-0
357    Fetch Operator
358      limit: -1
359
360
361PREHOOK: query: EXPLAIN FROM T1 a
362  LEFT OUTER JOIN T2 b ON (b.key=a.key)
363  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
364SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
365PREHOOK: type: QUERY
366POSTHOOK: query: EXPLAIN FROM T1 a
367  LEFT OUTER JOIN T2 b ON (b.key=a.key)
368  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
369SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
370POSTHOOK: type: QUERY
371ABSTRACT SYNTAX TREE:
372  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL a) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL c) val) (. (TOK_TABLE_OR_COL a) val)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) val)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) val)))))
373
374STAGE DEPENDENCIES:
375  Stage-1 is a root stage
376  Stage-2 depends on stages: Stage-1
377  Stage-0 is a root stage
378
379STAGE PLANS:
380  Stage: Stage-1
381    Map Reduce
382      Alias -> Map Operator Tree:
383        a 
384          TableScan
385            alias: a
386            Reduce Output Operator
387              key expressions:
388                    expr: key
389                    type: string
390              sort order: +
391              Map-reduce partition columns:
392                    expr: key
393                    type: string
394              tag: 1
395              value expressions:
396                    expr: key
397                    type: string
398                    expr: val
399                    type: string
400        b 
401          TableScan
402            alias: b
403            Reduce Output Operator
404              key expressions:
405                    expr: key
406                    type: string
407              sort order: +
408              Map-reduce partition columns:
409                    expr: key
410                    type: string
411              tag: 0
412              value expressions:
413                    expr: key
414                    type: string
415      Reduce Operator Tree:
416        Join Operator
417          condition map:
418               Left Outer Join0 to 1
419          condition expressions:
420            0 {VALUE._col0} {VALUE._col1}
421            1 {VALUE._col0}
422          handleSkewJoin: false
423          outputColumnNames: _col0, _col1, _col4
424          File Output Operator
425            compressed: false
426            GlobalTableId: 0
427            table:
428                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
429                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
430
431  Stage: Stage-2
432    Map Reduce
433      Alias -> Map Operator Tree:
434        $INTNAME 
435            Reduce Output Operator
436              key expressions:
437                    expr: _col1
438                    type: string
439              sort order: +
440              Map-reduce partition columns:
441                    expr: _col1
442                    type: string
443              tag: 1
444              value expressions:
445                    expr: _col4
446                    type: string
447                    expr: _col0
448                    type: string
449                    expr: _col1
450                    type: string
451        c 
452          TableScan
453            alias: c
454            Reduce Output Operator
455              key expressions:
456                    expr: val
457                    type: string
458              sort order: +
459              Map-reduce partition columns:
460                    expr: val
461                    type: string
462              tag: 0
463              value expressions:
464                    expr: val
465                    type: string
466      Reduce Operator Tree:
467        Join Operator
468          condition map:
469               Right Outer Join0 to 1
470          condition expressions:
471            0 {VALUE._col0} {VALUE._col4} {VALUE._col5}
472            1 {VALUE._col1}
473          handleSkewJoin: false
474          outputColumnNames: _col0, _col4, _col5, _col9
475          Select Operator
476            expressions:
477                  expr: _col4
478                  type: string
479                  expr: _col0
480                  type: string
481                  expr: _col5
482                  type: string
483                  expr: _col9
484                  type: string
485            outputColumnNames: _col0, _col1, _col2, _col3
486            File Output Operator
487              compressed: false
488              GlobalTableId: 0
489              table:
490                  input format: org.apache.hadoop.mapred.TextInputFormat
491                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
492
493  Stage: Stage-0
494    Fetch Operator
495      limit: -1
496
497
498PREHOOK: query: FROM T1 a
499  LEFT OUTER JOIN T2 b ON (b.key=a.key)
500  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
501SELECT a.key, b.key, a.val, c.val
502PREHOOK: type: QUERY
503PREHOOK: Input: default@t1
504PREHOOK: Input: default@t2
505PREHOOK: Input: default@t3
506PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-37_928_4361307602999951254/-mr-10000
507POSTHOOK: query: FROM T1 a
508  LEFT OUTER JOIN T2 b ON (b.key=a.key)
509  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
510SELECT a.key, b.key, a.val, c.val
511POSTHOOK: type: QUERY
512POSTHOOK: Input: default@t1
513POSTHOOK: Input: default@t2
514POSTHOOK: Input: default@t3
515POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-37_928_4361307602999951254/-mr-10000
5162	2	12	12
517NULL	NULL	NULL	14
518NULL	NULL	NULL	16
5197	NULL	17	17
520PREHOOK: query: FROM T1 a
521  LEFT OUTER JOIN T2 b ON (b.key=a.key)
522  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
523SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
524PREHOOK: type: QUERY
525PREHOOK: Input: default@t1
526PREHOOK: Input: default@t2
527PREHOOK: Input: default@t3
528PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-44_013_965933761656921378/-mr-10000
529POSTHOOK: query: FROM T1 a
530  LEFT OUTER JOIN T2 b ON (b.key=a.key)
531  RIGHT OUTER JOIN T3 c ON (c.val = a.val)
532SELECT /*+ STREAMTABLE(a) */ a.key, b.key, a.val, c.val
533POSTHOOK: type: QUERY
534POSTHOOK: Input: default@t1
535POSTHOOK: Input: default@t2
536POSTHOOK: Input: default@t3
537POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-44_013_965933761656921378/-mr-10000
5382	2	12	12
539NULL	NULL	NULL	14
540NULL	NULL	NULL	16
5417	NULL	17	17
542PREHOOK: query: EXPLAIN FROM UNIQUEJOIN
543  PRESERVE T1 a (a.key, a.val),
544  PRESERVE T2 b (b.key, b.val),
545  PRESERVE T3 c (c.key, c.val)
546SELECT a.key, b.key, c.key
547PREHOOK: type: QUERY
548POSTHOOK: query: EXPLAIN FROM UNIQUEJOIN
549  PRESERVE T1 a (a.key, a.val),
550  PRESERVE T2 b (b.key, b.val),
551  PRESERVE T3 c (c.key, c.val)
552SELECT a.key, b.key, c.key
553POSTHOOK: type: QUERY
554ABSTRACT SYNTAX TREE:
555  (TOK_QUERY (TOK_FROM (TOK_UNIQUEJOIN PRESERVE (TOK_TABREF (TOK_TABNAME T1) a) (TOK_EXPLIST (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL a) val)) PRESERVE (TOK_TABREF (TOK_TABNAME T2) b) (TOK_EXPLIST (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL b) val)) PRESERVE (TOK_TABREF (TOK_TABNAME T3) c) (TOK_EXPLIST (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL c) val)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key)))))
556
557STAGE DEPENDENCIES:
558  Stage-1 is a root stage
559  Stage-0 is a root stage
560
561STAGE PLANS:
562  Stage: Stage-1
563    Map Reduce
564      Alias -> Map Operator Tree:
565        a 
566          TableScan
567            alias: a
568            Reduce Output Operator
569              key expressions:
570                    expr: key
571                    type: string
572                    expr: val
573                    type: string
574              sort order: ++
575              Map-reduce partition columns:
576                    expr: key
577                    type: string
578                    expr: val
579                    type: string
580              tag: 0
581              value expressions:
582                    expr: key
583                    type: string
584        b 
585          TableScan
586            alias: b
587            Reduce Output Operator
588              key expressions:
589                    expr: key
590                    type: string
591                    expr: val
592                    type: string
593              sort order: ++
594              Map-reduce partition columns:
595                    expr: key
596                    type: string
597                    expr: val
598                    type: string
599              tag: 1
600              value expressions:
601                    expr: key
602                    type: string
603        c 
604          TableScan
605            alias: c
606            Reduce Output Operator
607              key expressions:
608                    expr: key
609                    type: string
610                    expr: val
611                    type: string
612              sort order: ++
613              Map-reduce partition columns:
614                    expr: key
615                    type: string
616                    expr: val
617                    type: string
618              tag: 2
619              value expressions:
620                    expr: key
621                    type: string
622      Reduce Operator Tree:
623        Join Operator
624          condition map:
625               Unique Join0 to 0
626               Unique Join0 to 0
627               Unique Join0 to 0
628          condition expressions:
629            0 {VALUE._col0}
630            1 {VALUE._col0}
631            2 {VALUE._col0}
632          handleSkewJoin: false
633          outputColumnNames: _col0, _col4, _col8
634          Select Operator
635            expressions:
636                  expr: _col0
637                  type: string
638                  expr: _col4
639                  type: string
640                  expr: _col8
641                  type: string
642            outputColumnNames: _col0, _col1, _col2
643            File Output Operator
644              compressed: false
645              GlobalTableId: 0
646              table:
647                  input format: org.apache.hadoop.mapred.TextInputFormat
648                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
649
650  Stage: Stage-0
651    Fetch Operator
652      limit: -1
653
654PREHOOK: query: EXPLAIN FROM UNIQUEJOIN
655  PRESERVE T1 a (a.key, a.val),
656  PRESERVE T2 b (b.key, b.val),
657  PRESERVE T3 c (c.key, c.val)
658SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
659PREHOOK: type: QUERY
660POSTHOOK: query: EXPLAIN FROM UNIQUEJOIN
661  PRESERVE T1 a (a.key, a.val),
662  PRESERVE T2 b (b.key, b.val),
663  PRESERVE T3 c (c.key, c.val)
664SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
665POSTHOOK: type: QUERY
666ABSTRACT SYNTAX TREE:
667  (TOK_QUERY (TOK_FROM (TOK_UNIQUEJOIN PRESERVE (TOK_TABREF (TOK_TABNAME T1) a) (TOK_EXPLIST (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL a) val)) PRESERVE (TOK_TABREF (TOK_TABNAME T2) b) (TOK_EXPLIST (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL b) val)) PRESERVE (TOK_TABREF (TOK_TABNAME T3) c) (TOK_EXPLIST (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL c) val)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST b))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key)))))
668
669STAGE DEPENDENCIES:
670  Stage-1 is a root stage
671  Stage-0 is a root stage
672
673STAGE PLANS:
674  Stage: Stage-1
675    Map Reduce
676      Alias -> Map Operator Tree:
677        a 
678          TableScan
679            alias: a
680            Reduce Output Operator
681              key expressions:
682                    expr: key
683                    type: string
684                    expr: val
685                    type: string
686              sort order: ++
687              Map-reduce partition columns:
688                    expr: key
689                    type: string
690                    expr: val
691                    type: string
692              tag: 0
693              value expressions:
694                    expr: key
695                    type: string
696        b 
697          TableScan
698            alias: b
699            Reduce Output Operator
700              key expressions:
701                    expr: key
702                    type: string
703                    expr: val
704                    type: string
705              sort order: ++
706              Map-reduce partition columns:
707                    expr: key
708                    type: string
709                    expr: val
710                    type: string
711              tag: 2
712              value expressions:
713                    expr: key
714                    type: string
715        c 
716          TableScan
717            alias: c
718            Reduce Output Operator
719              key expressions:
720                    expr: key
721                    type: string
722                    expr: val
723                    type: string
724              sort order: ++
725              Map-reduce partition columns:
726                    expr: key
727                    type: string
728                    expr: val
729                    type: string
730              tag: 1
731              value expressions:
732                    expr: key
733                    type: string
734      Reduce Operator Tree:
735        Join Operator
736          condition map:
737               Unique Join0 to 0
738               Unique Join0 to 0
739               Unique Join0 to 0
740          condition expressions:
741            0 {VALUE._col0}
742            1 {VALUE._col0}
743            2 {VALUE._col0}
744          handleSkewJoin: false
745          outputColumnNames: _col0, _col4, _col8
746          Select Operator
747            expressions:
748                  expr: _col0
749                  type: string
750                  expr: _col4
751                  type: string
752                  expr: _col8
753                  type: string
754            outputColumnNames: _col0, _col1, _col2
755            File Output Operator
756              compressed: false
757              GlobalTableId: 0
758              table:
759                  input format: org.apache.hadoop.mapred.TextInputFormat
760                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
761
762  Stage: Stage-0
763    Fetch Operator
764      limit: -1
765
766PREHOOK: query: FROM UNIQUEJOIN
767  PRESERVE T1 a (a.key, a.val),
768  PRESERVE T2 b (b.key, b.val),
769  PRESERVE T3 c (c.key, c.val)
770SELECT a.key, b.key, c.key
771PREHOOK: type: QUERY
772PREHOOK: Input: default@t1
773PREHOOK: Input: default@t2
774PREHOOK: Input: default@t3
775PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-50_283_7935840727920713008/-mr-10000
776POSTHOOK: query: FROM UNIQUEJOIN
777  PRESERVE T1 a (a.key, a.val),
778  PRESERVE T2 b (b.key, b.val),
779  PRESERVE T3 c (c.key, c.val)
780SELECT a.key, b.key, c.key
781POSTHOOK: type: QUERY
782POSTHOOK: Input: default@t1
783POSTHOOK: Input: default@t2
784POSTHOOK: Input: default@t3
785POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-50_283_7935840727920713008/-mr-10000
7861	NULL	NULL
7872	NULL	2
788NULL	2	NULL
7893	3	NULL
790NULL	4	4
791NULL	5	NULL
792NULL	NULL	6
7937	NULL	7
7948	8	NULL
7958	8	NULL
7968	NULL	NULL
797PREHOOK: query: FROM UNIQUEJOIN
798  PRESERVE T1 a (a.key, a.val),
799  PRESERVE T2 b (b.key, b.val),
800  PRESERVE T3 c (c.key, c.val)
801SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
802PREHOOK: type: QUERY
803PREHOOK: Input: default@t1
804PREHOOK: Input: default@t2
805PREHOOK: Input: default@t3
806PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-53_534_2948703874836264518/-mr-10000
807POSTHOOK: query: FROM UNIQUEJOIN
808  PRESERVE T1 a (a.key, a.val),
809  PRESERVE T2 b (b.key, b.val),
810  PRESERVE T3 c (c.key, c.val)
811SELECT /*+ STREAMTABLE(b) */ a.key, b.key, c.key
812POSTHOOK: type: QUERY
813POSTHOOK: Input: default@t1
814POSTHOOK: Input: default@t2
815POSTHOOK: Input: default@t3
816POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-53_534_2948703874836264518/-mr-10000
8171	NULL	NULL
8182	NULL	2
819NULL	2	NULL
8203	3	NULL
821NULL	4	4
822NULL	5	NULL
823NULL	NULL	6
8247	NULL	7
8258	8	NULL
8268	8	NULL
8278	NULL	NULL