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

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

#
text | 150 lines | 143 code | 7 blank | 0 comment | 0 complexity | 7b39c30bba0bbb47d6fe8bfbb09bb25b MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value DOUBLE) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
  8PREHOOK: type: QUERY
  9POSTHOOK: query: EXPLAIN
 10FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
 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_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key)) (TOK_LIMIT 5)))
 14
 15STAGE DEPENDENCIES:
 16  Stage-1 is a root stage
 17  Stage-2 depends on stages: Stage-1
 18  Stage-0 depends on stages: Stage-2
 19  Stage-3 depends on stages: Stage-0
 20
 21STAGE PLANS:
 22  Stage: Stage-1
 23    Map Reduce
 24      Alias -> Map Operator Tree:
 25        src 
 26          TableScan
 27            alias: src
 28            Select Operator
 29              expressions:
 30                    expr: key
 31                    type: string
 32                    expr: value
 33                    type: string
 34              outputColumnNames: key, value
 35              Group By Operator
 36                aggregations:
 37                      expr: sum(substr(value, 5))
 38                bucketGroup: false
 39                keys:
 40                      expr: key
 41                      type: string
 42                mode: hash
 43                outputColumnNames: _col0, _col1
 44                Reduce Output Operator
 45                  key expressions:
 46                        expr: _col0
 47                        type: string
 48                  sort order: +
 49                  Map-reduce partition columns:
 50                        expr: _col0
 51                        type: string
 52                  tag: -1
 53                  value expressions:
 54                        expr: _col1
 55                        type: double
 56      Reduce Operator Tree:
 57        Group By Operator
 58          aggregations:
 59                expr: sum(VALUE._col0)
 60          bucketGroup: false
 61          keys:
 62                expr: KEY._col0
 63                type: string
 64          mode: mergepartial
 65          outputColumnNames: _col0, _col1
 66          Select Operator
 67            expressions:
 68                  expr: _col0
 69                  type: string
 70                  expr: _col1
 71                  type: double
 72            outputColumnNames: _col0, _col1
 73            Limit
 74              File Output Operator
 75                compressed: false
 76                GlobalTableId: 0
 77                table:
 78                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 79                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 80
 81  Stage: Stage-2
 82    Map Reduce
 83      Alias -> Map Operator Tree:
 84        file:/tmp/sdong/hive_2011-02-10_01-49-04_956_406305842309592902/-mr-10002 
 85            Reduce Output Operator
 86              sort order: 
 87              tag: -1
 88              value expressions:
 89                    expr: _col0
 90                    type: string
 91                    expr: _col1
 92                    type: double
 93      Reduce Operator Tree:
 94        Extract
 95          Limit
 96            Select Operator
 97              expressions:
 98                    expr: UDFToInteger(_col0)
 99                    type: int
100                    expr: _col1
101                    type: double
102              outputColumnNames: _col0, _col1
103              File Output Operator
104                compressed: false
105                GlobalTableId: 1
106                table:
107                    input format: org.apache.hadoop.mapred.TextInputFormat
108                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
109                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
110                    name: default.dest1
111
112  Stage: Stage-0
113    Move Operator
114      tables:
115          replace: true
116          table:
117              input format: org.apache.hadoop.mapred.TextInputFormat
118              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
119              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
120              name: default.dest1
121
122  Stage: Stage-3
123    Stats-Aggr Operator
124
125
126PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
127PREHOOK: type: QUERY
128PREHOOK: Input: default@src
129PREHOOK: Output: default@dest1
130POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key LIMIT 5
131POSTHOOK: type: QUERY
132POSTHOOK: Input: default@src
133POSTHOOK: Output: default@dest1
134POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
135POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
136PREHOOK: query: SELECT dest1.* FROM dest1
137PREHOOK: type: QUERY
138PREHOOK: Input: default@dest1
139PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-49-12_798_2878850829077906411/-mr-10000
140POSTHOOK: query: SELECT dest1.* FROM dest1
141POSTHOOK: type: QUERY
142POSTHOOK: Input: default@dest1
143POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-49-12_798_2878850829077906411/-mr-10000
144POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
145POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1460	0.0
14710	10.0
148100	200.0
149103	206.0
150104	208.0