| select tinyint_col, count(*) |
| from functional.alltypesagg |
| group by 1 |
| ---- DISTRIBUTEDPLAN |
| PLAN-ROOT SINK |
| | |
| 04:EXCHANGE [UNPARTITIONED] |
| | |
| 03:AGGREGATE [FINALIZE] |
| | output: count:merge(*) |
| | group by: tinyint_col |
| | row-size=9B cardinality=9 |
| | |
| 02:EXCHANGE [HASH(tinyint_col)] |
| | |
| 01:AGGREGATE |
| | output: count(*) |
| | group by: tinyint_col |
| | row-size=9B cardinality=9 |
| | |
| 00:SCAN HDFS [functional.alltypesagg] |
| partitions=11/11 files=11 size=814.73KB |
| row-size=1B cardinality=11.00K |
| ==== |
| select count(distinct id) |
| from functional.alltypesagg |
| ---- DISTRIBUTEDPLAN |
| PLAN-ROOT SINK |
| | |
| 06:AGGREGATE [FINALIZE] |
| | output: count:merge(id) |
| | row-size=8B cardinality=1 |
| | |
| 05:EXCHANGE [UNPARTITIONED] |
| | |
| 02:AGGREGATE |
| | output: count(id) |
| | row-size=8B cardinality=1 |
| | |
| 04:AGGREGATE |
| | group by: id |
| | row-size=4B cardinality=10.28K |
| | |
| 03:EXCHANGE [HASH(id)] |
| | |
| 01:AGGREGATE |
| | group by: id |
| | row-size=4B cardinality=10.28K |
| | |
| 00:SCAN HDFS [functional.alltypesagg] |
| partitions=11/11 files=11 size=814.73KB |
| row-size=4B cardinality=11.00K |
| ==== |