hive中窗口分析函数

    select dt,tenantCode,nvl(platform,'all') as platform,
    count(1) as uv_one
    from(
    select tenantCode,platform,dt,deviceId,count(deviceId) as pv from
    dw_stg.tmp_tg_user_behavior_day a
    group by tenantCode,platform,dt,deviceId
    having tenantCode is not null 
    and deviceId is not null
    --and count(deviceId) = 1 --浏览量为1的访客数
    )aa group by tenantCode,platform,dt
    grouping sets((dt,tenantCode), (dt,tenantCode,platform))