hive sql - 다양한 group by - grouping sets , with cube

select A,B,C, count(distinct cust_id) from dataset group by A,B,C 1. grouping sets select A,B,C, grouping__id, count(distinct cust_id) from dataset group by A,B,C grouping sets ((),(A),(B),(C),(A,C),(B,C),(A,B,C)) 2. cube select A,B,C, grouping__id, count(distinct cust_id) from dataset group by A,B,C with cube 3. roll up select A,B,C, grouping__id, count(distinct cust_id) from dataset group by A..

2022.05.01