PageRenderTime 23ms CodeModel.GetById 17ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 214 lines | 208 code | 6 blank | 0 comment | 0 complexity | 240b5efccdd2072e9fca8d7a4d2a1022 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM src
  8INSERT OVERWRITE TABLE dest1 SELECT
  9  sum(substr(src.value,5)),
 10  avg(substr(src.value,5)),
 11  avg(DISTINCT substr(src.value,5)),
 12  max(substr(src.value,5)),
 13  min(substr(src.value,5)),
 14  std(substr(src.value,5)),
 15  stddev_samp(substr(src.value,5)),
 16  variance(substr(src.value,5)),
 17  var_samp(substr(src.value,5)),
 18  sum(DISTINCT substr(src.value, 5)),
 19  count(DISTINCT substr(src.value, 5))
 20PREHOOK: type: QUERY
 21POSTHOOK: query: EXPLAIN
 22FROM src
 23INSERT OVERWRITE TABLE dest1 SELECT
 24  sum(substr(src.value,5)),
 25  avg(substr(src.value,5)),
 26  avg(DISTINCT substr(src.value,5)),
 27  max(substr(src.value,5)),
 28  min(substr(src.value,5)),
 29  std(substr(src.value,5)),
 30  stddev_samp(substr(src.value,5)),
 31  variance(substr(src.value,5)),
 32  var_samp(substr(src.value,5)),
 33  sum(DISTINCT substr(src.value, 5)),
 34  count(DISTINCT substr(src.value, 5))
 35POSTHOOK: type: QUERY
 36ABSTRACT SYNTAX TREE:
 37  (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_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI avg (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION std (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION stddev_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION variance (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION var_samp (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))))
 38
 39STAGE DEPENDENCIES:
 40  Stage-1 is a root stage
 41  Stage-0 depends on stages: Stage-1
 42  Stage-2 depends on stages: Stage-0
 43
 44STAGE PLANS:
 45  Stage: Stage-1
 46    Map Reduce
 47      Alias -> Map Operator Tree:
 48        src 
 49          TableScan
 50            alias: src
 51            Select Operator
 52              expressions:
 53                    expr: value
 54                    type: string
 55              outputColumnNames: value
 56              Reduce Output Operator
 57                key expressions:
 58                      expr: substr(value, 5)
 59                      type: string
 60                sort order: +
 61                tag: -1
 62      Reduce Operator Tree:
 63        Group By Operator
 64          aggregations:
 65                expr: sum(KEY._col0:2._col0)
 66                expr: avg(KEY._col0:2._col0)
 67                expr: avg(DISTINCT KEY._col0:0._col0)
 68                expr: max(KEY._col0:2._col0)
 69                expr: min(KEY._col0:2._col0)
 70                expr: std(KEY._col0:2._col0)
 71                expr: stddev_samp(KEY._col0:2._col0)
 72                expr: variance(KEY._col0:2._col0)
 73                expr: var_samp(KEY._col0:2._col0)
 74                expr: sum(DISTINCT KEY._col0:1._col0)
 75                expr: count(DISTINCT KEY._col0:2._col0)
 76          bucketGroup: false
 77          mode: complete
 78          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
 79          Select Operator
 80            expressions:
 81                  expr: _col0
 82                  type: double
 83                  expr: _col1
 84                  type: double
 85                  expr: _col2
 86                  type: double
 87                  expr: _col3
 88                  type: string
 89                  expr: _col4
 90                  type: string
 91                  expr: _col5
 92                  type: double
 93                  expr: _col6
 94                  type: double
 95                  expr: _col7
 96                  type: double
 97                  expr: _col8
 98                  type: double
 99                  expr: _col9
100                  type: double
101                  expr: _col10
102                  type: bigint
103            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
104            Select Operator
105              expressions:
106                    expr: _col0
107                    type: double
108                    expr: _col1
109                    type: double
110                    expr: _col2
111                    type: double
112                    expr: UDFToDouble(_col3)
113                    type: double
114                    expr: UDFToDouble(_col4)
115                    type: double
116                    expr: _col5
117                    type: double
118                    expr: _col6
119                    type: double
120                    expr: _col7
121                    type: double
122                    expr: _col8
123                    type: double
124                    expr: _col9
125                    type: double
126                    expr: UDFToDouble(_col10)
127                    type: double
128              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
129              File Output Operator
130                compressed: false
131                GlobalTableId: 1
132                table:
133                    input format: org.apache.hadoop.mapred.TextInputFormat
134                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
135                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
136                    name: default.dest1
137
138  Stage: Stage-0
139    Move Operator
140      tables:
141          replace: true
142          table:
143              input format: org.apache.hadoop.mapred.TextInputFormat
144              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
145              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
146              name: default.dest1
147
148  Stage: Stage-2
149    Stats-Aggr Operator
150
151
152PREHOOK: query: FROM src
153INSERT OVERWRITE TABLE dest1 SELECT
154  sum(substr(src.value,5)),
155  avg(substr(src.value,5)),
156  avg(DISTINCT substr(src.value,5)),
157  max(substr(src.value,5)),
158  min(substr(src.value,5)),
159  std(substr(src.value,5)),
160  stddev_samp(substr(src.value,5)),
161  variance(substr(src.value,5)),
162  var_samp(substr(src.value,5)),
163  sum(DISTINCT substr(src.value, 5)),
164  count(DISTINCT substr(src.value, 5))
165PREHOOK: type: QUERY
166PREHOOK: Input: default@src
167PREHOOK: Output: default@dest1
168POSTHOOK: query: FROM src
169INSERT OVERWRITE TABLE dest1 SELECT
170  sum(substr(src.value,5)),
171  avg(substr(src.value,5)),
172  avg(DISTINCT substr(src.value,5)),
173  max(substr(src.value,5)),
174  min(substr(src.value,5)),
175  std(substr(src.value,5)),
176  stddev_samp(substr(src.value,5)),
177  variance(substr(src.value,5)),
178  var_samp(substr(src.value,5)),
179  sum(DISTINCT substr(src.value, 5)),
180  count(DISTINCT substr(src.value, 5))
181POSTHOOK: type: QUERY
182POSTHOOK: Input: default@src
183POSTHOOK: Output: default@dest1
184POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
185POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
186POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
187POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.null, ]
188POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
189POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
190POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.null, ]
191POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.null, ]
192POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.null, ]
193POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.null, ]
194POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.null, ]
195PREHOOK: query: SELECT dest1.* FROM dest1
196PREHOOK: type: QUERY
197PREHOOK: Input: default@dest1
198PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-50-57_634_1889269807749157481/-mr-10000
199POSTHOOK: query: SELECT dest1.* FROM dest1
200POSTHOOK: type: QUERY
201POSTHOOK: Input: default@dest1
202POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-50-57_634_1889269807749157481/-mr-10000
203POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.null, ]
204POSTHOOK: Lineage: dest1.c10 EXPRESSION [(src)src.null, ]
205POSTHOOK: Lineage: dest1.c11 EXPRESSION [(src)src.null, ]
206POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.null, ]
207POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
208POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.null, ]
209POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.null, ]
210POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.null, ]
211POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.null, ]
212POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.null, ]
213POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.null, ]
214130091.0	260.182	256.10355987055016	98.0	0.0	142.92680950752379	143.06995106518903	20428.07287599999	20469.010897795582	79136.0	309.0