修改规范下面的语句:insert overwrite table DM_M_YX_ZBSF_YXD_3select t1month_idt1prov_idsumt1total_fee from select from zq_dwadwa_m_cus_kk_fmarkets_keycust where month_id = 202303and is_zt=1and is_zbsf=0 t1i
INSERT OVERWRITE TABLE DM_M_YX_ZBSF_YXD_3 SELECT t1.month_id, t1.prov_id, SUM(t1.total_fee) FROM ( SELECT * FROM zq_dwa.dwa_m_cus_kk_fmarkets_keycust WHERE month_id >= '202303' AND is_zt = '1' AND is_zbsf = '0' ) t1 INNER JOIN ( SELECT * FROM dwa.dwa_v_m_cus_cb_user_info WHERE month_id >= '202303' AND is_stat = '1' ) t2 ON t1.user_id = t2.user_id AND t1.month_id = t2.month_id WHERE t1.user_id IS NOT NULL AND t2.user_id IS NOT NULL GROUP BY t1.month_id, t1.prov_id
原文地址: https://www.cveoy.top/t/topic/it62 著作权归作者所有。请勿转载和采集!