本文介绍了Hive的高级聚合函数，包括GROUPING SETS、ROLLUP和CUBE的用法，以及HAVING子句在聚合条件过滤中的应用。通过示例展示了如何使用这些功能进行多维度的数据分析。
高级聚合
---------------
GROUPING SETS.
group by + union all
//查询每个cust的订单数
select count(*) from orders group by cid ;
select count(*) from orders group by orderno ;
//group + union all
select count(*) from orders group by cid union all select count(*) from orders group by orderno ;
//group by :指定按照哪些字段分组，
//grouping sets : 以上字段集如何组合。
select count(*) from orders group by cid,orderno grouping sets(cid,o
---------------
GROUPING SETS.
group by + union all
//查询每个cust的订单数
select count(*) from orders group by cid ;
select count(*) from orders group by orderno ;
//group + union all
select count(*) from orders group by cid union all select count(*) from orders group by orderno ;
//group by :指定按照哪些字段分组，
//grouping sets : 以上字段集如何组合。
select count(*) from orders group by cid,orderno grouping sets(cid,o
最低0.47元/天 解锁文章
扫一扫
1187
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
