HIVE中grouping__id使用场景

• grouping__id值的计算方式

例子：

step01：数据准备如下

​create table temp.temp_xw_20180127 as
select '2018-01'  as dt_month, null as type, 12 total
union all 
select '2018-01'  as dt_month, '收入' as type, 100 total

step02：对表temp.temp_xw_20180127做汇总

select
  a.dt_month
 ,a.type
 ,grouping__id  as set_id
 ,sum(total)    as total
from temp.temp_xw_20180127 a
group by a.dt_month
        ,a.type
with rollup

运行结果如下：