PageRenderTime 27ms CodeModel.GetById 17ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 429 lines | 418 code | 11 blank | 0 comment | 0 complexity | edab9d2181dc9d78ad0072d356bd6fa7 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: CREATE TABLE T4(key STRING, val STRING) STORED AS TEXTFILE
 17PREHOOK: type: CREATETABLE
 18POSTHOOK: query: CREATE TABLE T4(key STRING, val STRING) STORED AS TEXTFILE
 19POSTHOOK: type: CREATETABLE
 20POSTHOOK: Output: default@T4
 21PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
 22PREHOOK: type: LOAD
 23POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
 24POSTHOOK: type: LOAD
 25POSTHOOK: Output: default@t1
 26PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
 27PREHOOK: type: LOAD
 28POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
 29POSTHOOK: type: LOAD
 30POSTHOOK: Output: default@t2
 31PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
 32PREHOOK: type: LOAD
 33POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
 34POSTHOOK: type: LOAD
 35POSTHOOK: Output: default@t3
 36PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T4
 37PREHOOK: type: LOAD
 38POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T4
 39POSTHOOK: type: LOAD
 40POSTHOOK: Output: default@t4
 41PREHOOK: query: EXPLAIN
 42SELECT /*+ STREAMTABLE(a) */ *
 43FROM T1 a JOIN T2 b ON a.key = b.key
 44          JOIN T3 c ON b.key = c.key
 45          JOIN T4 d ON c.key = d.key
 46PREHOOK: type: QUERY
 47POSTHOOK: query: EXPLAIN
 48SELECT /*+ STREAMTABLE(a) */ *
 49FROM T1 a JOIN T2 b ON a.key = b.key
 50          JOIN T3 c ON b.key = c.key
 51          JOIN T4 d ON c.key = d.key
 52POSTHOOK: type: QUERY
 53ABSTRACT SYNTAX TREE:
 54  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key))) (TOK_TABREF (TOK_TABNAME T4) d) (= (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL d) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
 55
 56STAGE DEPENDENCIES:
 57  Stage-1 is a root stage
 58  Stage-0 is a root stage
 59
 60STAGE PLANS:
 61  Stage: Stage-1
 62    Map Reduce
 63      Alias -> Map Operator Tree:
 64        a 
 65          TableScan
 66            alias: a
 67            Reduce Output Operator
 68              key expressions:
 69                    expr: key
 70                    type: string
 71              sort order: +
 72              Map-reduce partition columns:
 73                    expr: key
 74                    type: string
 75              tag: 3
 76              value expressions:
 77                    expr: key
 78                    type: string
 79                    expr: val
 80                    type: string
 81        b 
 82          TableScan
 83            alias: b
 84            Reduce Output Operator
 85              key expressions:
 86                    expr: key
 87                    type: string
 88              sort order: +
 89              Map-reduce partition columns:
 90                    expr: key
 91                    type: string
 92              tag: 1
 93              value expressions:
 94                    expr: key
 95                    type: string
 96                    expr: val
 97                    type: string
 98        c 
 99          TableScan
100            alias: c
101            Reduce Output Operator
102              key expressions:
103                    expr: key
104                    type: string
105              sort order: +
106              Map-reduce partition columns:
107                    expr: key
108                    type: string
109              tag: 2
110              value expressions:
111                    expr: key
112                    type: string
113                    expr: val
114                    type: string
115        d 
116          TableScan
117            alias: d
118            Reduce Output Operator
119              key expressions:
120                    expr: key
121                    type: string
122              sort order: +
123              Map-reduce partition columns:
124                    expr: key
125                    type: string
126              tag: 0
127              value expressions:
128                    expr: key
129                    type: string
130                    expr: val
131                    type: string
132      Reduce Operator Tree:
133        Join Operator
134          condition map:
135               Inner Join 0 to 1
136               Inner Join 1 to 2
137               Inner Join 2 to 3
138          condition expressions:
139            0 {VALUE._col0} {VALUE._col1}
140            1 {VALUE._col0} {VALUE._col1}
141            2 {VALUE._col0} {VALUE._col1}
142            3 {VALUE._col0} {VALUE._col1}
143          handleSkewJoin: false
144          outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
145          Select Operator
146            expressions:
147                  expr: _col0
148                  type: string
149                  expr: _col1
150                  type: string
151                  expr: _col4
152                  type: string
153                  expr: _col5
154                  type: string
155                  expr: _col8
156                  type: string
157                  expr: _col9
158                  type: string
159                  expr: _col12
160                  type: string
161                  expr: _col13
162                  type: string
163            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
164            File Output Operator
165              compressed: false
166              GlobalTableId: 0
167              table:
168                  input format: org.apache.hadoop.mapred.TextInputFormat
169                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
170
171  Stage: Stage-0
172    Fetch Operator
173      limit: -1
174
175
176PREHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
177FROM T1 a JOIN T2 b ON a.key = b.key
178          JOIN T3 c ON b.key = c.key
179          JOIN T4 d ON c.key = d.key
180PREHOOK: type: QUERY
181PREHOOK: Input: default@t1
182PREHOOK: Input: default@t2
183PREHOOK: Input: default@t3
184PREHOOK: Input: default@t4
185PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-17_595_7754652804655964686/-mr-10000
186POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
187FROM T1 a JOIN T2 b ON a.key = b.key
188          JOIN T3 c ON b.key = c.key
189          JOIN T4 d ON c.key = d.key
190POSTHOOK: type: QUERY
191POSTHOOK: Input: default@t1
192POSTHOOK: Input: default@t2
193POSTHOOK: Input: default@t3
194POSTHOOK: Input: default@t4
195POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-17_595_7754652804655964686/-mr-10000
1962	12	2	22	2	12	2	12
197PREHOOK: query: EXPLAIN
198SELECT /*+ STREAMTABLE(a) */ *
199FROM T1 a JOIN T2 b ON a.key = b.key
200          JOIN T3 c ON a.val = c.val
201          JOIN T4 d ON a.key + 1 = d.key + 1
202PREHOOK: type: QUERY
203POSTHOOK: query: EXPLAIN
204SELECT /*+ STREAMTABLE(a) */ *
205FROM T1 a JOIN T2 b ON a.key = b.key
206          JOIN T3 c ON a.val = c.val
207          JOIN T4 d ON a.key + 1 = d.key + 1
208POSTHOOK: type: QUERY
209ABSTRACT SYNTAX TREE:
210  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME T1) a) (TOK_TABREF (TOK_TABNAME T2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME T3) c) (= (. (TOK_TABLE_OR_COL a) val) (. (TOK_TABLE_OR_COL c) val))) (TOK_TABREF (TOK_TABNAME T4) d) (= (+ (. (TOK_TABLE_OR_COL a) key) 1) (+ (. (TOK_TABLE_OR_COL d) key) 1)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_STREAMTABLE (TOK_HINTARGLIST a))) (TOK_SELEXPR TOK_ALLCOLREF))))
211
212STAGE DEPENDENCIES:
213  Stage-2 is a root stage
214  Stage-3 depends on stages: Stage-2
215  Stage-1 depends on stages: Stage-3
216  Stage-0 is a root stage
217
218STAGE PLANS:
219  Stage: Stage-2
220    Map Reduce
221      Alias -> Map Operator Tree:
222        a 
223          TableScan
224            alias: a
225            Reduce Output Operator
226              key expressions:
227                    expr: key
228                    type: string
229              sort order: +
230              Map-reduce partition columns:
231                    expr: key
232                    type: string
233              tag: 1
234              value expressions:
235                    expr: key
236                    type: string
237                    expr: val
238                    type: string
239        b 
240          TableScan
241            alias: b
242            Reduce Output Operator
243              key expressions:
244                    expr: key
245                    type: string
246              sort order: +
247              Map-reduce partition columns:
248                    expr: key
249                    type: string
250              tag: 0
251              value expressions:
252                    expr: key
253                    type: string
254                    expr: val
255                    type: string
256      Reduce Operator Tree:
257        Join Operator
258          condition map:
259               Inner Join 0 to 1
260          condition expressions:
261            0 {VALUE._col0} {VALUE._col1}
262            1 {VALUE._col0} {VALUE._col1}
263          handleSkewJoin: false
264          outputColumnNames: _col0, _col1, _col4, _col5
265          File Output Operator
266            compressed: false
267            GlobalTableId: 0
268            table:
269                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
270                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
271
272  Stage: Stage-3
273    Map Reduce
274      Alias -> Map Operator Tree:
275        $INTNAME 
276            Reduce Output Operator
277              key expressions:
278                    expr: _col1
279                    type: string
280              sort order: +
281              Map-reduce partition columns:
282                    expr: _col1
283                    type: string
284              tag: 1
285              value expressions:
286                    expr: _col4
287                    type: string
288                    expr: _col5
289                    type: string
290                    expr: _col0
291                    type: string
292                    expr: _col1
293                    type: string
294        c 
295          TableScan
296            alias: c
297            Reduce Output Operator
298              key expressions:
299                    expr: val
300                    type: string
301              sort order: +
302              Map-reduce partition columns:
303                    expr: val
304                    type: string
305              tag: 0
306              value expressions:
307                    expr: key
308                    type: string
309                    expr: val
310                    type: string
311      Reduce Operator Tree:
312        Join Operator
313          condition map:
314               Inner Join 0 to 1
315          condition expressions:
316            0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
317            1 {VALUE._col0} {VALUE._col1}
318          handleSkewJoin: false
319          outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
320          File Output Operator
321            compressed: false
322            GlobalTableId: 0
323            table:
324                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
325                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
326
327  Stage: Stage-1
328    Map Reduce
329      Alias -> Map Operator Tree:
330        $INTNAME 
331            Reduce Output Operator
332              key expressions:
333                    expr: (_col4 + 1)
334                    type: double
335              sort order: +
336              Map-reduce partition columns:
337                    expr: (_col4 + 1)
338                    type: double
339              tag: 1
340              value expressions:
341                    expr: _col0
342                    type: string
343                    expr: _col1
344                    type: string
345                    expr: _col8
346                    type: string
347                    expr: _col9
348                    type: string
349                    expr: _col4
350                    type: string
351                    expr: _col5
352                    type: string
353        d 
354          TableScan
355            alias: d
356            Reduce Output Operator
357              key expressions:
358                    expr: (key + 1)
359                    type: double
360              sort order: +
361              Map-reduce partition columns:
362                    expr: (key + 1)
363                    type: double
364              tag: 0
365              value expressions:
366                    expr: key
367                    type: string
368                    expr: val
369                    type: string
370      Reduce Operator Tree:
371        Join Operator
372          condition map:
373               Inner Join 0 to 1
374          condition expressions:
375            0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5} {VALUE._col8} {VALUE._col9}
376            1 {VALUE._col0} {VALUE._col1}
377          handleSkewJoin: false
378          outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13
379          Select Operator
380            expressions:
381                  expr: _col8
382                  type: string
383                  expr: _col9
384                  type: string
385                  expr: _col0
386                  type: string
387                  expr: _col1
388                  type: string
389                  expr: _col4
390                  type: string
391                  expr: _col5
392                  type: string
393                  expr: _col12
394                  type: string
395                  expr: _col13
396                  type: string
397            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
398            File Output Operator
399              compressed: false
400              GlobalTableId: 0
401              table:
402                  input format: org.apache.hadoop.mapred.TextInputFormat
403                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
404
405  Stage: Stage-0
406    Fetch Operator
407      limit: -1
408
409PREHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
410FROM T1 a JOIN T2 b ON a.key = b.key
411          JOIN T3 c ON a.val = c.val
412          JOIN T4 d ON a.key + 1 = d.key + 1
413PREHOOK: type: QUERY
414PREHOOK: Input: default@t1
415PREHOOK: Input: default@t2
416PREHOOK: Input: default@t3
417PREHOOK: Input: default@t4
418PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-23_174_5401036993230810041/-mr-10000
419POSTHOOK: query: SELECT /*+ STREAMTABLE(a) */ *
420FROM T1 a JOIN T2 b ON a.key = b.key
421          JOIN T3 c ON a.val = c.val
422          JOIN T4 d ON a.key + 1 = d.key + 1
423POSTHOOK: type: QUERY
424POSTHOOK: Input: default@t1
425POSTHOOK: Input: default@t2
426POSTHOOK: Input: default@t3
427POSTHOOK: Input: default@t4
428POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-23_174_5401036993230810041/-mr-10000
4292	12	2	22	2	12	2	12