INSERT OVERWRITE TABLE bis.middle_roi_boss_income_playtime_new PARTITION (dt)
select p1,
core_biz,
qipu_id as qipu_episode_id,
sum(new_playtime),
sum(new_pt_income),
sum(new_pt_income_predict),
dt from
(SELECT p1, core_biz, qipu_id, 0 as new_playtime, sum(divide_price_1d_effective_vip) as new_pt_income, 0 as new_pt_income_predict, dt
FROM bis.mid_md_inc_hive_vip_effective_playtime_income_cube
WHERE dt BETWEEN '${last_month}-01' AND '${dt}'
and (core_biz is null
or core_biz not in ('anime', 'wxa_xs', 'wxa_yss'))
group by p1, core_biz, qipu_id ,dt
union all select p1, core_biz,qipu_episode_id as qipu_id, new_playtime, 0 as new_pt_income, new_pt_income_predict, dt
from bis.middle_roi_boss_income_playtime_new
WHERE dt BETWEEN '${last_month}-01' AND '${dt}'
and (core_biz is null
or core_biz not in ('anime', 'wxa_xs', 'wxa_yss')) )t
group by p1,
core_biz,
qipu_id,
dt
sql语句什么意思,在线求解
最新推荐文章于 2023-10-15 22:28:20 发布