hive rollup
是CUBE的子集，以最左侧的维度为主（group by后的第一个元素），从该维度进行层级聚合；
原文地址 https://www.cnblogs.com/qingyunzong/p/8798987.html

SELECT month, day, COUNT(DISTINCT cookieid) AS uv, GROUPING__ID
FROM cookie5
GROUP BY month,day WITH ROLLUP ORDER BY GROUPING__ID;