1.把子查询建立成一个视图
CREATE VIEW ud_al_ps_insight_union_cpro_lu_trans_view
as
-- 子查询
SELECT
`stat_date` AS `stat_date`,
CASE
WHEN (
`channel` IN ('lu_ps', 'lm_ps_si')
) THEN
"lu_daoliu"
WHEN (`channel` IN('dl_ps')) THEN
"se_rec"
WHEN channel NOT IN ('lu_ps', 'lm_ps_si', 'dl_ps') THEN 'other'
END AS `type`,
pv
FROM ud_al_ps_insight_union_cpro_lu
2.数据最终视图再根据子查询视图生成
CREATE VIEW ud_al_ps_insight_union_cpro_lu_view
AS
SELECT
stat_date,
type,
sum(pv) AS pv
FROM
ud_al_ps_insight_union_cpro_lu_trans_view
GROUP BY
stat_date,
type