hive--GROUPING SETS方法产生的聚合问题
--- 这是计算pv uv指标
select
COALESCE(activity_id,'ALL') as activity_id
, COALESCE(page_name,'ALL') as page_name
, COALESCE(product,'ALL') as product
, COALESCE(product_browse_name,'ALL') as pr
原创
2020-11-10 18:46:59 ·
306 阅读 ·
0 评论