PageRenderTime 39ms CodeModel.GetById 18ms app.highlight 12ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/count.q.out

#
text | 578 lines | 558 code | 20 blank | 0 comment | 0 complexity | e4c18b94fe7a0fdf73e050a48b434b74 MD5 | raw file
  1PREHOOK: query: create table abcd (a int, b int, c int, d int)
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table abcd (a int, b int, c int, d int)
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@abcd
  6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in4.txt' INTO TABLE abcd
  7PREHOOK: type: LOAD
  8PREHOOK: Output: default@abcd
  9POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in4.txt' INTO TABLE abcd
 10POSTHOOK: type: LOAD
 11POSTHOOK: Output: default@abcd
 12PREHOOK: query: select * from abcd
 13PREHOOK: type: QUERY
 14PREHOOK: Input: default@abcd
 15PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-53_458_612862284528268304/-mr-10000
 16POSTHOOK: query: select * from abcd
 17POSTHOOK: type: QUERY
 18POSTHOOK: Input: default@abcd
 19POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-53_458_612862284528268304/-mr-10000
 20NULL	35	23	6
 2110	1000	50	1
 22100	100	10	3
 2312	NULL	80	2
 2410	100	NULL	5
 2510	100	45	4
 2612	100	75	7
 27PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
 28PREHOOK: type: QUERY
 29POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
 30POSTHOOK: type: QUERY
 31ABSTRACT SYNTAX TREE:
 32  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL d)))) (TOK_GROUPBY (TOK_TABLE_OR_COL a))))
 33
 34STAGE DEPENDENCIES:
 35  Stage-1 is a root stage
 36  Stage-0 is a root stage
 37
 38STAGE PLANS:
 39  Stage: Stage-1
 40    Map Reduce
 41      Alias -> Map Operator Tree:
 42        abcd 
 43          TableScan
 44            alias: abcd
 45            Select Operator
 46              expressions:
 47                    expr: a
 48                    type: int
 49                    expr: b
 50                    type: int
 51                    expr: c
 52                    type: int
 53                    expr: d
 54                    type: int
 55              outputColumnNames: a, b, c, d
 56              Group By Operator
 57                aggregations:
 58                      expr: count(DISTINCT b)
 59                      expr: count(DISTINCT c)
 60                      expr: sum(d)
 61                bucketGroup: false
 62                keys:
 63                      expr: a
 64                      type: int
 65                      expr: b
 66                      type: int
 67                      expr: c
 68                      type: int
 69                mode: hash
 70                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
 71                Reduce Output Operator
 72                  key expressions:
 73                        expr: _col0
 74                        type: int
 75                        expr: _col1
 76                        type: int
 77                        expr: _col2
 78                        type: int
 79                  sort order: +++
 80                  Map-reduce partition columns:
 81                        expr: _col0
 82                        type: int
 83                  tag: -1
 84                  value expressions:
 85                        expr: _col3
 86                        type: bigint
 87                        expr: _col4
 88                        type: bigint
 89                        expr: _col5
 90                        type: bigint
 91      Reduce Operator Tree:
 92        Group By Operator
 93          aggregations:
 94                expr: count(DISTINCT KEY._col1:0._col0)
 95                expr: count(DISTINCT KEY._col1:1._col0)
 96                expr: sum(VALUE._col2)
 97          bucketGroup: false
 98          keys:
 99                expr: KEY._col0
100                type: int
101          mode: mergepartial
102          outputColumnNames: _col0, _col1, _col2, _col3
103          Select Operator
104            expressions:
105                  expr: _col0
106                  type: int
107                  expr: _col1
108                  type: bigint
109                  expr: _col2
110                  type: bigint
111                  expr: _col3
112                  type: bigint
113            outputColumnNames: _col0, _col1, _col2, _col3
114            File Output Operator
115              compressed: false
116              GlobalTableId: 0
117              table:
118                  input format: org.apache.hadoop.mapred.TextInputFormat
119                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
120
121  Stage: Stage-0
122    Fetch Operator
123      limit: -1
124
125
126PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
127PREHOOK: type: QUERY
128PREHOOK: Input: default@abcd
129PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-54_530_5497111678274590113/-mr-10000
130POSTHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
131POSTHOOK: type: QUERY
132POSTHOOK: Input: default@abcd
133POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-46-54_530_5497111678274590113/-mr-10000
134NULL	1	1	6
13510	2	2	10
13612	1	2	9
137100	1	1	3
138PREHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
139PREHOOK: type: QUERY
140POSTHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
141POSTHOOK: type: QUERY
142ABSTRACT SYNTAX TREE:
143  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))))))
144
145STAGE DEPENDENCIES:
146  Stage-1 is a root stage
147  Stage-0 is a root stage
148
149STAGE PLANS:
150  Stage: Stage-1
151    Map Reduce
152      Alias -> Map Operator Tree:
153        abcd 
154          TableScan
155            alias: abcd
156            Select Operator
157              expressions:
158                    expr: a
159                    type: int
160                    expr: b
161                    type: int
162                    expr: c
163                    type: int
164                    expr: d
165                    type: int
166              outputColumnNames: a, b, c, d
167              Group By Operator
168                aggregations:
169                      expr: count(1)
170                      expr: count()
171                      expr: count(a)
172                      expr: count(b)
173                      expr: count(c)
174                      expr: count(d)
175                      expr: count(DISTINCT a)
176                      expr: count(DISTINCT b)
177                      expr: count(DISTINCT c)
178                      expr: count(DISTINCT d)
179                      expr: count(DISTINCT a, b)
180                      expr: count(DISTINCT b, c)
181                      expr: count(DISTINCT c, d)
182                      expr: count(DISTINCT a, d)
183                      expr: count(DISTINCT a, c)
184                      expr: count(DISTINCT b, d)
185                      expr: count(DISTINCT a, b, c)
186                      expr: count(DISTINCT b, c, d)
187                      expr: count(DISTINCT a, c, d)
188                      expr: count(DISTINCT a, b, d)
189                      expr: count(DISTINCT a, b, c, d)
190                bucketGroup: false
191                keys:
192                      expr: a
193                      type: int
194                      expr: b
195                      type: int
196                      expr: c
197                      type: int
198                      expr: d
199                      type: int
200                mode: hash
201                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24
202                Reduce Output Operator
203                  key expressions:
204                        expr: _col0
205                        type: int
206                        expr: _col1
207                        type: int
208                        expr: _col2
209                        type: int
210                        expr: _col3
211                        type: int
212                  sort order: ++++
213                  tag: -1
214                  value expressions:
215                        expr: _col4
216                        type: bigint
217                        expr: _col5
218                        type: bigint
219                        expr: _col6
220                        type: bigint
221                        expr: _col7
222                        type: bigint
223                        expr: _col8
224                        type: bigint
225                        expr: _col9
226                        type: bigint
227                        expr: _col10
228                        type: bigint
229                        expr: _col11
230                        type: bigint
231                        expr: _col12
232                        type: bigint
233                        expr: _col13
234                        type: bigint
235                        expr: _col14
236                        type: bigint
237                        expr: _col15
238                        type: bigint
239                        expr: _col16
240                        type: bigint
241                        expr: _col17
242                        type: bigint
243                        expr: _col18
244                        type: bigint
245                        expr: _col19
246                        type: bigint
247                        expr: _col20
248                        type: bigint
249                        expr: _col21
250                        type: bigint
251                        expr: _col22
252                        type: bigint
253                        expr: _col23
254                        type: bigint
255                        expr: _col24
256                        type: bigint
257      Reduce Operator Tree:
258        Group By Operator
259          aggregations:
260                expr: count(VALUE._col0)
261                expr: count(VALUE._col1)
262                expr: count(VALUE._col2)
263                expr: count(VALUE._col3)
264                expr: count(VALUE._col4)
265                expr: count(VALUE._col5)
266                expr: count(DISTINCT KEY._col0:0._col0)
267                expr: count(DISTINCT KEY._col0:1._col0)
268                expr: count(DISTINCT KEY._col0:2._col0)
269                expr: count(DISTINCT KEY._col0:3._col0)
270                expr: count(DISTINCT KEY._col0:4._col0, KEY._col0:4._col1)
271                expr: count(DISTINCT KEY._col0:5._col0, KEY._col0:5._col1)
272                expr: count(DISTINCT KEY._col0:6._col0, KEY._col0:6._col1)
273                expr: count(DISTINCT KEY._col0:7._col0, KEY._col0:7._col1)
274                expr: count(DISTINCT KEY._col0:8._col0, KEY._col0:8._col1)
275                expr: count(DISTINCT KEY._col0:9._col0, KEY._col0:9._col1)
276                expr: count(DISTINCT KEY._col0:10._col0, KEY._col0:10._col1, KEY._col0:10._col2)
277                expr: count(DISTINCT KEY._col0:11._col0, KEY._col0:11._col1, KEY._col0:11._col2)
278                expr: count(DISTINCT KEY._col0:12._col0, KEY._col0:12._col1, KEY._col0:12._col2)
279                expr: count(DISTINCT KEY._col0:13._col0, KEY._col0:13._col1, KEY._col0:13._col2)
280                expr: count(DISTINCT KEY._col0:14._col0, KEY._col0:14._col1, KEY._col0:14._col2, KEY._col0:14._col3)
281          bucketGroup: false
282          mode: mergepartial
283          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
284          Select Operator
285            expressions:
286                  expr: _col0
287                  type: bigint
288                  expr: _col1
289                  type: bigint
290                  expr: _col2
291                  type: bigint
292                  expr: _col3
293                  type: bigint
294                  expr: _col4
295                  type: bigint
296                  expr: _col5
297                  type: bigint
298                  expr: _col6
299                  type: bigint
300                  expr: _col7
301                  type: bigint
302                  expr: _col8
303                  type: bigint
304                  expr: _col9
305                  type: bigint
306                  expr: _col10
307                  type: bigint
308                  expr: _col11
309                  type: bigint
310                  expr: _col12
311                  type: bigint
312                  expr: _col13
313                  type: bigint
314                  expr: _col14
315                  type: bigint
316                  expr: _col15
317                  type: bigint
318                  expr: _col16
319                  type: bigint
320                  expr: _col17
321                  type: bigint
322                  expr: _col18
323                  type: bigint
324                  expr: _col19
325                  type: bigint
326                  expr: _col20
327                  type: bigint
328            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
329            File Output Operator
330              compressed: false
331              GlobalTableId: 0
332              table:
333                  input format: org.apache.hadoop.mapred.TextInputFormat
334                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
335
336  Stage: Stage-0
337    Fetch Operator
338      limit: -1
339
340
341PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
342PREHOOK: type: QUERY
343PREHOOK: Input: default@abcd
344PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-01_430_3407527654800696294/-mr-10000
345POSTHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
346POSTHOOK: type: QUERY
347POSTHOOK: Input: default@abcd
348POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-01_430_3407527654800696294/-mr-10000
3497	7	6	6	6	7	3	3	6	7	4	5	6	6	5	6	4	5	5	5	4
350PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
351PREHOOK: type: QUERY
352POSTHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
353POSTHOOK: type: QUERY
354ABSTRACT SYNTAX TREE:
355  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL a)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL d)))) (TOK_GROUPBY (TOK_TABLE_OR_COL a))))
356
357STAGE DEPENDENCIES:
358  Stage-1 is a root stage
359  Stage-0 is a root stage
360
361STAGE PLANS:
362  Stage: Stage-1
363    Map Reduce
364      Alias -> Map Operator Tree:
365        abcd 
366          TableScan
367            alias: abcd
368            Select Operator
369              expressions:
370                    expr: a
371                    type: int
372                    expr: b
373                    type: int
374                    expr: c
375                    type: int
376                    expr: d
377                    type: int
378              outputColumnNames: a, b, c, d
379              Reduce Output Operator
380                key expressions:
381                      expr: a
382                      type: int
383                      expr: b
384                      type: int
385                      expr: c
386                      type: int
387                sort order: +++
388                Map-reduce partition columns:
389                      expr: a
390                      type: int
391                tag: -1
392                value expressions:
393                      expr: d
394                      type: int
395      Reduce Operator Tree:
396        Group By Operator
397          aggregations:
398                expr: count(DISTINCT KEY._col1:0._col0)
399                expr: count(DISTINCT KEY._col1:1._col0)
400                expr: sum(VALUE._col0)
401          bucketGroup: false
402          keys:
403                expr: KEY._col0
404                type: int
405          mode: complete
406          outputColumnNames: _col0, _col1, _col2, _col3
407          Select Operator
408            expressions:
409                  expr: _col0
410                  type: int
411                  expr: _col1
412                  type: bigint
413                  expr: _col2
414                  type: bigint
415                  expr: _col3
416                  type: bigint
417            outputColumnNames: _col0, _col1, _col2, _col3
418            File Output Operator
419              compressed: false
420              GlobalTableId: 0
421              table:
422                  input format: org.apache.hadoop.mapred.TextInputFormat
423                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
424
425  Stage: Stage-0
426    Fetch Operator
427      limit: -1
428
429
430PREHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
431PREHOOK: type: QUERY
432PREHOOK: Input: default@abcd
433PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-10_928_4191678549398242821/-mr-10000
434POSTHOOK: query: select a, count(distinct b), count(distinct c), sum(d) from abcd group by a
435POSTHOOK: type: QUERY
436POSTHOOK: Input: default@abcd
437POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-10_928_4191678549398242821/-mr-10000
438NULL	1	1	6
43910	2	2	10
44012	1	2	9
441100	1	1	3
442PREHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
443PREHOOK: type: QUERY
444POSTHOOK: query: explain select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
445POSTHOOK: type: QUERY
446ABSTRACT SYNTAX TREE:
447  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME abcd))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL d))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL a) (TOK_TABLE_OR_COL b) (TOK_TABLE_OR_COL c) (TOK_TABLE_OR_COL d))))))
448
449STAGE DEPENDENCIES:
450  Stage-1 is a root stage
451  Stage-0 is a root stage
452
453STAGE PLANS:
454  Stage: Stage-1
455    Map Reduce
456      Alias -> Map Operator Tree:
457        abcd 
458          TableScan
459            alias: abcd
460            Select Operator
461              expressions:
462                    expr: a
463                    type: int
464                    expr: b
465                    type: int
466                    expr: c
467                    type: int
468                    expr: d
469                    type: int
470              outputColumnNames: a, b, c, d
471              Reduce Output Operator
472                key expressions:
473                      expr: a
474                      type: int
475                      expr: b
476                      type: int
477                      expr: c
478                      type: int
479                      expr: d
480                      type: int
481                sort order: ++++
482                tag: -1
483                value expressions:
484                      expr: 1
485                      type: int
486      Reduce Operator Tree:
487        Group By Operator
488          aggregations:
489                expr: count(VALUE._col0)
490                expr: count()
491                expr: count(KEY._col0:14._col0)
492                expr: count(KEY._col0:14._col1)
493                expr: count(KEY._col0:14._col2)
494                expr: count(KEY._col0:14._col3)
495                expr: count(DISTINCT KEY._col0:0._col0)
496                expr: count(DISTINCT KEY._col0:1._col0)
497                expr: count(DISTINCT KEY._col0:2._col0)
498                expr: count(DISTINCT KEY._col0:3._col0)
499                expr: count(DISTINCT KEY._col0:4._col0, KEY._col0:4._col1)
500                expr: count(DISTINCT KEY._col0:5._col0, KEY._col0:5._col1)
501                expr: count(DISTINCT KEY._col0:6._col0, KEY._col0:6._col1)
502                expr: count(DISTINCT KEY._col0:7._col0, KEY._col0:7._col1)
503                expr: count(DISTINCT KEY._col0:8._col0, KEY._col0:8._col1)
504                expr: count(DISTINCT KEY._col0:9._col0, KEY._col0:9._col1)
505                expr: count(DISTINCT KEY._col0:10._col0, KEY._col0:10._col1, KEY._col0:10._col2)
506                expr: count(DISTINCT KEY._col0:11._col0, KEY._col0:11._col1, KEY._col0:11._col2)
507                expr: count(DISTINCT KEY._col0:12._col0, KEY._col0:12._col1, KEY._col0:12._col2)
508                expr: count(DISTINCT KEY._col0:13._col0, KEY._col0:13._col1, KEY._col0:13._col2)
509                expr: count(DISTINCT KEY._col0:14._col0, KEY._col0:14._col1, KEY._col0:14._col2, KEY._col0:14._col3)
510          bucketGroup: false
511          mode: complete
512          outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
513          Select Operator
514            expressions:
515                  expr: _col0
516                  type: bigint
517                  expr: _col1
518                  type: bigint
519                  expr: _col2
520                  type: bigint
521                  expr: _col3
522                  type: bigint
523                  expr: _col4
524                  type: bigint
525                  expr: _col5
526                  type: bigint
527                  expr: _col6
528                  type: bigint
529                  expr: _col7
530                  type: bigint
531                  expr: _col8
532                  type: bigint
533                  expr: _col9
534                  type: bigint
535                  expr: _col10
536                  type: bigint
537                  expr: _col11
538                  type: bigint
539                  expr: _col12
540                  type: bigint
541                  expr: _col13
542                  type: bigint
543                  expr: _col14
544                  type: bigint
545                  expr: _col15
546                  type: bigint
547                  expr: _col16
548                  type: bigint
549                  expr: _col17
550                  type: bigint
551                  expr: _col18
552                  type: bigint
553                  expr: _col19
554                  type: bigint
555                  expr: _col20
556                  type: bigint
557            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
558            File Output Operator
559              compressed: false
560              GlobalTableId: 0
561              table:
562                  input format: org.apache.hadoop.mapred.TextInputFormat
563                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
564
565  Stage: Stage-0
566    Fetch Operator
567      limit: -1
568
569
570PREHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
571PREHOOK: type: QUERY
572PREHOOK: Input: default@abcd
573PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-23_137_2355783462946349645/-mr-10000
574POSTHOOK: query: select count(1), count(*), count(a), count(b), count(c), count(d), count(distinct a), count(distinct b), count(distinct c), count(distinct d), count(distinct a,b), count(distinct b,c), count(distinct c,d), count(distinct a,d), count(distinct a,c), count(distinct b,d), count(distinct a,b,c), count(distinct b,c,d), count(distinct a,c,d), count(distinct a,b,d), count(distinct a,b,c,d) from abcd
575POSTHOOK: type: QUERY
576POSTHOOK: Input: default@abcd
577POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_22-47-23_137_2355783462946349645/-mr-10000
5787	7	6	6	6	7	3	3	6	7	4	5	6	6	5	6	4	5	5	5	4