sparksql 根据子项聚合求累积的值

–1 计算子项的聚合值

create table tmp_xxxx_20220322
as 
    select  user_id
           ,item_id
           ,count(ord_id) as item_ord_cnt_1d
from xxxx
group by user_id,item_id
;

–2 按 company_id 计