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

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

#
text | 102 lines | 96 code | 6 blank | 0 comment | 0 complexity | 0386a8f567e209184eb5350a4f69a349 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
  8PREHOOK: type: QUERY
  9POSTHOOK: query: EXPLAIN
 10FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
 11POSTHOOK: type: QUERY
 12ABSTRACT SYNTAX TREE:
 13  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION sum (. (TOK_TABLE_OR_COL src) key))))))
 14
 15STAGE DEPENDENCIES:
 16  Stage-1 is a root stage
 17  Stage-0 depends on stages: Stage-1
 18  Stage-2 depends on stages: Stage-0
 19
 20STAGE PLANS:
 21  Stage: Stage-1
 22    Map Reduce
 23      Alias -> Map Operator Tree:
 24        src 
 25          TableScan
 26            alias: src
 27            Select Operator
 28              expressions:
 29                    expr: key
 30                    type: string
 31              outputColumnNames: key
 32              Group By Operator
 33                aggregations:
 34                      expr: sum(key)
 35                bucketGroup: false
 36                mode: hash
 37                outputColumnNames: _col0
 38                Reduce Output Operator
 39                  sort order: 
 40                  tag: -1
 41                  value expressions:
 42                        expr: _col0
 43                        type: double
 44      Reduce Operator Tree:
 45        Group By Operator
 46          aggregations:
 47                expr: sum(VALUE._col0)
 48          bucketGroup: false
 49          mode: final
 50          outputColumnNames: _col0
 51          Select Operator
 52            expressions:
 53                  expr: _col0
 54                  type: double
 55            outputColumnNames: _col0
 56            Select Operator
 57              expressions:
 58                    expr: UDFToInteger(_col0)
 59                    type: int
 60              outputColumnNames: _col0
 61              File Output Operator
 62                compressed: false
 63                GlobalTableId: 1
 64                table:
 65                    input format: org.apache.hadoop.mapred.TextInputFormat
 66                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 67                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 68                    name: default.dest1
 69
 70  Stage: Stage-0
 71    Move Operator
 72      tables:
 73          replace: true
 74          table:
 75              input format: org.apache.hadoop.mapred.TextInputFormat
 76              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 77              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 78              name: default.dest1
 79
 80  Stage: Stage-2
 81    Stats-Aggr Operator
 82
 83
 84PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
 85PREHOOK: type: QUERY
 86PREHOOK: Input: default@src
 87PREHOOK: Output: default@dest1
 88POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT sum(src.key)
 89POSTHOOK: type: QUERY
 90POSTHOOK: Input: default@src
 91POSTHOOK: Output: default@dest1
 92POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 93PREHOOK: query: SELECT dest1.* FROM dest1
 94PREHOOK: type: QUERY
 95PREHOOK: Input: default@dest1
 96PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-51-42_053_6635536653614673631/-mr-10000
 97POSTHOOK: query: SELECT dest1.* FROM dest1
 98POSTHOOK: type: QUERY
 99POSTHOOK: Input: default@dest1
100POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-51-42_053_6635536653614673631/-mr-10000
101POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
102130091