PageRenderTime 14ms CodeModel.GetById 9ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 106 lines | 99 code | 7 blank | 0 comment | 0 complexity | a84fe11a7dc083868dbb4379517d9af0 MD5 | raw file
  1PREHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
  2
  3explain 
  4  select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
  5                        select s2.key as key, s2.value as value from src s2) unionsrc
  6PREHOOK: type: QUERY
  7POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
  8
  9explain 
 10  select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
 11                        select s2.key as key, s2.value as value from src s2) unionsrc
 12POSTHOOK: type: QUERY
 13ABSTRACT SYNTAX TREE:
 14  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) value) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
 15
 16STAGE DEPENDENCIES:
 17  Stage-1 is a root stage
 18  Stage-0 is a root stage
 19
 20STAGE PLANS:
 21  Stage: Stage-1
 22    Map Reduce
 23      Alias -> Map Operator Tree:
 24        null-subquery1:unionsrc-subquery1:s1 
 25          TableScan
 26            alias: s1
 27            Select Operator
 28              expressions:
 29                    expr: key
 30                    type: string
 31                    expr: value
 32                    type: string
 33              outputColumnNames: _col0, _col1
 34              Union
 35                Select Operator
 36                  Group By Operator
 37                    aggregations:
 38                          expr: count(1)
 39                    bucketGroup: false
 40                    mode: hash
 41                    outputColumnNames: _col0
 42                    Reduce Output Operator
 43                      sort order: 
 44                      tag: -1
 45                      value expressions:
 46                            expr: _col0
 47                            type: bigint
 48        null-subquery2:unionsrc-subquery2:s2 
 49          TableScan
 50            alias: s2
 51            Select Operator
 52              expressions:
 53                    expr: key
 54                    type: string
 55                    expr: value
 56                    type: string
 57              outputColumnNames: _col0, _col1
 58              Union
 59                Select Operator
 60                  Group By Operator
 61                    aggregations:
 62                          expr: count(1)
 63                    bucketGroup: false
 64                    mode: hash
 65                    outputColumnNames: _col0
 66                    Reduce Output Operator
 67                      sort order: 
 68                      tag: -1
 69                      value expressions:
 70                            expr: _col0
 71                            type: bigint
 72      Reduce Operator Tree:
 73        Group By Operator
 74          aggregations:
 75                expr: count(VALUE._col0)
 76          bucketGroup: false
 77          mode: mergepartial
 78          outputColumnNames: _col0
 79          Select Operator
 80            expressions:
 81                  expr: _col0
 82                  type: bigint
 83            outputColumnNames: _col0
 84            File Output Operator
 85              compressed: false
 86              GlobalTableId: 0
 87              table:
 88                  input format: org.apache.hadoop.mapred.TextInputFormat
 89                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 90
 91  Stage: Stage-0
 92    Fetch Operator
 93      limit: -1
 94
 95
 96PREHOOK: query: select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
 97                      select s2.key as key, s2.value as value from src s2) unionsrc
 98PREHOOK: type: QUERY
 99PREHOOK: Input: default@src
100PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-54_630_1295074456516758667/-mr-10000
101POSTHOOK: query: select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
102                      select s2.key as key, s2.value as value from src s2) unionsrc
103POSTHOOK: type: QUERY
104POSTHOOK: Input: default@src
105POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-54_630_1295074456516758667/-mr-10000
1061000