PageRenderTime 29ms CodeModel.GetById 18ms app.highlight 7ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 546 lines | 501 code | 45 blank | 0 comment | 0 complexity | a6ba5aaea9307d8ccf70a91272ddecb8 MD5 | raw file
  1PREHOOK: query: EXPLAIN
  2SELECT * FROM srcpart
  3PREHOOK: type: QUERY
  4POSTHOOK: query: EXPLAIN
  5SELECT * FROM srcpart
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-0 is a root stage
 12
 13STAGE PLANS:
 14  Stage: Stage-0
 15    Fetch Operator
 16      limit: -1
 17
 18
 19PREHOOK: query: EXPLAIN
 20SELECT `..` FROM srcpart
 21PREHOOK: type: QUERY
 22POSTHOOK: query: EXPLAIN
 23SELECT `..` FROM srcpart
 24POSTHOOK: type: QUERY
 25ABSTRACT SYNTAX TREE:
 26  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `..`)))))
 27
 28STAGE DEPENDENCIES:
 29  Stage-1 is a root stage
 30  Stage-0 is a root stage
 31
 32STAGE PLANS:
 33  Stage: Stage-1
 34    Map Reduce
 35      Alias -> Map Operator Tree:
 36        srcpart 
 37          TableScan
 38            alias: srcpart
 39            Select Operator
 40              expressions:
 41                    expr: ds
 42                    type: string
 43                    expr: hr
 44                    type: string
 45              outputColumnNames: _col0, _col1
 46              File Output Operator
 47                compressed: false
 48                GlobalTableId: 0
 49                table:
 50                    input format: org.apache.hadoop.mapred.TextInputFormat
 51                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 52
 53  Stage: Stage-0
 54    Fetch Operator
 55      limit: -1
 56
 57
 58PREHOOK: query: EXPLAIN
 59SELECT srcpart.`..` FROM srcpart
 60PREHOOK: type: QUERY
 61POSTHOOK: query: EXPLAIN
 62SELECT srcpart.`..` FROM srcpart
 63POSTHOOK: type: QUERY
 64ABSTRACT SYNTAX TREE:
 65  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) `..`)))))
 66
 67STAGE DEPENDENCIES:
 68  Stage-1 is a root stage
 69  Stage-0 is a root stage
 70
 71STAGE PLANS:
 72  Stage: Stage-1
 73    Map Reduce
 74      Alias -> Map Operator Tree:
 75        srcpart 
 76          TableScan
 77            alias: srcpart
 78            Select Operator
 79              expressions:
 80                    expr: ds
 81                    type: string
 82                    expr: hr
 83                    type: string
 84              outputColumnNames: _col0, _col1
 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: EXPLAIN
 98SELECT `..` FROM srcpart a JOIN srcpart b
 99ON a.key = b.key AND a.value = b.value
100PREHOOK: type: QUERY
101POSTHOOK: query: EXPLAIN
102SELECT `..` FROM srcpart a JOIN srcpart b
103ON a.key = b.key AND a.value = b.value
104POSTHOOK: type: QUERY
105ABSTRACT SYNTAX TREE:
106  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL a) value) (. (TOK_TABLE_OR_COL b) value))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `..`)))))
107
108STAGE DEPENDENCIES:
109  Stage-1 is a root stage
110  Stage-0 is a root stage
111
112STAGE PLANS:
113  Stage: Stage-1
114    Map Reduce
115      Alias -> Map Operator Tree:
116        a 
117          TableScan
118            alias: a
119            Reduce Output Operator
120              key expressions:
121                    expr: key
122                    type: string
123                    expr: value
124                    type: string
125              sort order: ++
126              Map-reduce partition columns:
127                    expr: key
128                    type: string
129                    expr: value
130                    type: string
131              tag: 0
132              value expressions:
133                    expr: ds
134                    type: string
135                    expr: hr
136                    type: string
137        b 
138          TableScan
139            alias: b
140            Reduce Output Operator
141              key expressions:
142                    expr: key
143                    type: string
144                    expr: value
145                    type: string
146              sort order: ++
147              Map-reduce partition columns:
148                    expr: key
149                    type: string
150                    expr: value
151                    type: string
152              tag: 1
153              value expressions:
154                    expr: ds
155                    type: string
156                    expr: hr
157                    type: string
158      Reduce Operator Tree:
159        Join Operator
160          condition map:
161               Inner Join 0 to 1
162          condition expressions:
163            0 {VALUE._col2} {VALUE._col3}
164            1 {VALUE._col2} {VALUE._col3}
165          handleSkewJoin: false
166          outputColumnNames: _col2, _col3, _col8, _col9
167          Select Operator
168            expressions:
169                  expr: _col2
170                  type: string
171                  expr: _col3
172                  type: string
173                  expr: _col8
174                  type: string
175                  expr: _col9
176                  type: string
177            outputColumnNames: _col0, _col1, _col2, _col3
178            File Output Operator
179              compressed: false
180              GlobalTableId: 0
181              table:
182                  input format: org.apache.hadoop.mapred.TextInputFormat
183                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
184
185  Stage: Stage-0
186    Fetch Operator
187      limit: -1
188
189
190PREHOOK: query: EXPLAIN
191SELECT b.`..` FROM srcpart a JOIN srcpart b
192ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
193ORDER BY ds, hr
194PREHOOK: type: QUERY
195POSTHOOK: query: EXPLAIN
196SELECT b.`..` FROM srcpart a JOIN srcpart b
197ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
198ORDER BY ds, hr
199POSTHOOK: type: QUERY
200ABSTRACT SYNTAX TREE:
201  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (AND (AND (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL a) hr) (. (TOK_TABLE_OR_COL b) hr))) (= (. (TOK_TABLE_OR_COL a) ds) (. (TOK_TABLE_OR_COL b) ds))) (= (. (TOK_TABLE_OR_COL a) key) 103)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) `..`))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ds)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL hr)))))
202
203STAGE DEPENDENCIES:
204  Stage-1 is a root stage
205  Stage-2 depends on stages: Stage-1
206  Stage-0 is a root stage
207
208STAGE PLANS:
209  Stage: Stage-1
210    Map Reduce
211      Alias -> Map Operator Tree:
212        a 
213          TableScan
214            alias: a
215            Filter Operator
216              predicate:
217                  expr: (key = 103)
218                  type: boolean
219              Filter Operator
220                predicate:
221                    expr: (key = 103)
222                    type: boolean
223                Reduce Output Operator
224                  key expressions:
225                        expr: key
226                        type: string
227                        expr: hr
228                        type: string
229                        expr: ds
230                        type: string
231                  sort order: +++
232                  Map-reduce partition columns:
233                        expr: key
234                        type: string
235                        expr: hr
236                        type: string
237                        expr: ds
238                        type: string
239                  tag: 0
240        b 
241          TableScan
242            alias: b
243            Reduce Output Operator
244              key expressions:
245                    expr: key
246                    type: string
247                    expr: hr
248                    type: string
249                    expr: ds
250                    type: string
251              sort order: +++
252              Map-reduce partition columns:
253                    expr: key
254                    type: string
255                    expr: hr
256                    type: string
257                    expr: ds
258                    type: string
259              tag: 1
260              value expressions:
261                    expr: ds
262                    type: string
263                    expr: hr
264                    type: string
265      Reduce Operator Tree:
266        Join Operator
267          condition map:
268               Inner Join 0 to 1
269          condition expressions:
270            0 
271            1 {VALUE._col2} {VALUE._col3}
272          handleSkewJoin: false
273          outputColumnNames: _col8, _col9
274          Select Operator
275            expressions:
276                  expr: _col8
277                  type: string
278                  expr: _col9
279                  type: string
280            outputColumnNames: _col0, _col1
281            File Output Operator
282              compressed: false
283              GlobalTableId: 0
284              table:
285                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
286                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
287
288  Stage: Stage-2
289    Map Reduce
290      Alias -> Map Operator Tree:
291        file:/tmp/sdong/hive_2011-02-10_17-01-27_356_3093621423795045358/-mr-10002 
292            Reduce Output Operator
293              key expressions:
294                    expr: _col0
295                    type: string
296                    expr: _col1
297                    type: string
298              sort order: ++
299              tag: -1
300              value expressions:
301                    expr: _col0
302                    type: string
303                    expr: _col1
304                    type: string
305      Reduce Operator Tree:
306        Extract
307          File Output Operator
308            compressed: false
309            GlobalTableId: 0
310            table:
311                input format: org.apache.hadoop.mapred.TextInputFormat
312                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
313
314  Stage: Stage-0
315    Fetch Operator
316      limit: -1
317
318
319PREHOOK: query: SELECT b.`..` FROM srcpart a JOIN srcpart b
320ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
321ORDER BY ds, hr
322PREHOOK: type: QUERY
323PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
324PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
325PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
326PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
327PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-27_548_6653931489088427144/-mr-10000
328POSTHOOK: query: SELECT b.`..` FROM srcpart a JOIN srcpart b
329ON a.key = b.key AND a.hr = b.hr AND a.ds = b.ds AND a.key = 103
330ORDER BY ds, hr
331POSTHOOK: type: QUERY
332POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
333POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
334POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
335POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
336POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-27_548_6653931489088427144/-mr-10000
3372008-04-08	11
3382008-04-08	11
3392008-04-08	11
3402008-04-08	11
3412008-04-08	12
3422008-04-08	12
3432008-04-08	12
3442008-04-08	12
3452008-04-09	11
3462008-04-09	11
3472008-04-09	11
3482008-04-09	11
3492008-04-09	12
3502008-04-09	12
3512008-04-09	12
3522008-04-09	12
353PREHOOK: query: EXPLAIN
354SELECT `.e.` FROM srcpart
355PREHOOK: type: QUERY
356POSTHOOK: query: EXPLAIN
357SELECT `.e.` FROM srcpart
358POSTHOOK: type: QUERY
359ABSTRACT SYNTAX TREE:
360  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `.e.`)))))
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        srcpart 
371          TableScan
372            alias: srcpart
373            Select Operator
374              expressions:
375                    expr: key
376                    type: string
377              outputColumnNames: _col0
378              File Output Operator
379                compressed: false
380                GlobalTableId: 0
381                table:
382                    input format: org.apache.hadoop.mapred.TextInputFormat
383                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
384
385  Stage: Stage-0
386    Fetch Operator
387      limit: -1
388
389
390PREHOOK: query: EXPLAIN
391SELECT `d.*` FROM srcpart
392PREHOOK: type: QUERY
393POSTHOOK: query: EXPLAIN
394SELECT `d.*` FROM srcpart
395POSTHOOK: type: QUERY
396ABSTRACT SYNTAX TREE:
397  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `d.*`)))))
398
399STAGE DEPENDENCIES:
400  Stage-1 is a root stage
401  Stage-0 is a root stage
402
403STAGE PLANS:
404  Stage: Stage-1
405    Map Reduce
406      Alias -> Map Operator Tree:
407        srcpart 
408          TableScan
409            alias: srcpart
410            Select Operator
411              expressions:
412                    expr: ds
413                    type: string
414              outputColumnNames: _col0
415              File Output Operator
416                compressed: false
417                GlobalTableId: 0
418                table:
419                    input format: org.apache.hadoop.mapred.TextInputFormat
420                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
421
422  Stage: Stage-0
423    Fetch Operator
424      limit: -1
425
426
427PREHOOK: query: EXPLAIN
428SELECT `(ds)?+.+` FROM srcpart
429PREHOOK: type: QUERY
430POSTHOOK: query: EXPLAIN
431SELECT `(ds)?+.+` FROM srcpart
432POSTHOOK: type: QUERY
433ABSTRACT SYNTAX TREE:
434  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `(ds)?+.+`)))))
435
436STAGE DEPENDENCIES:
437  Stage-1 is a root stage
438  Stage-0 is a root stage
439
440STAGE PLANS:
441  Stage: Stage-1
442    Map Reduce
443      Alias -> Map Operator Tree:
444        srcpart 
445          TableScan
446            alias: srcpart
447            Select Operator
448              expressions:
449                    expr: key
450                    type: string
451                    expr: value
452                    type: string
453                    expr: hr
454                    type: string
455              outputColumnNames: _col0, _col1, _col2
456              File Output Operator
457                compressed: false
458                GlobalTableId: 0
459                table:
460                    input format: org.apache.hadoop.mapred.TextInputFormat
461                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
462
463  Stage: Stage-0
464    Fetch Operator
465      limit: -1
466
467
468PREHOOK: query: EXPLAIN
469SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
470PREHOOK: type: QUERY
471POSTHOOK: query: EXPLAIN
472SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
473POSTHOOK: type: QUERY
474ABSTRACT SYNTAX TREE:
475  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcpart))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL `(ds|hr)?+.+`))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))) (TOK_LIMIT 10)))
476
477STAGE DEPENDENCIES:
478  Stage-1 is a root stage
479  Stage-0 is a root stage
480
481STAGE PLANS:
482  Stage: Stage-1
483    Map Reduce
484      Alias -> Map Operator Tree:
485        srcpart 
486          TableScan
487            alias: srcpart
488            Select Operator
489              expressions:
490                    expr: key
491                    type: string
492                    expr: value
493                    type: string
494              outputColumnNames: _col0, _col1
495              Reduce Output Operator
496                key expressions:
497                      expr: _col0
498                      type: string
499                      expr: _col1
500                      type: string
501                sort order: ++
502                tag: -1
503                value expressions:
504                      expr: _col0
505                      type: string
506                      expr: _col1
507                      type: string
508      Reduce Operator Tree:
509        Extract
510          Limit
511            File Output Operator
512              compressed: false
513              GlobalTableId: 0
514              table:
515                  input format: org.apache.hadoop.mapred.TextInputFormat
516                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
517
518  Stage: Stage-0
519    Fetch Operator
520      limit: 10
521
522
523PREHOOK: query: SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
524PREHOOK: type: QUERY
525PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
526PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
527PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
528PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
529PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-35_406_5771693391982309464/-mr-10000
530POSTHOOK: query: SELECT `(ds|hr)?+.+` FROM srcpart ORDER BY key, value LIMIT 10
531POSTHOOK: type: QUERY
532POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
533POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
534POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
535POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
536POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-35_406_5771693391982309464/-mr-10000
5370	val_0
5380	val_0
5390	val_0
5400	val_0
5410	val_0
5420	val_0
5430	val_0
5440	val_0
5450	val_0
5460	val_0