insert overwrite table DM_M_YX_KD_YXD_100 partition month_id =$V_MONTH selectprov_name宾馆酒店 xfsc_typecountdistinct case when is_innet=1 then user_id end is_innetcountdistinct case when acct_tag=1

INSERT OVERWRITE TABLE DM_M_YX_KD_YXD_100 PARTITION (month_id = '${V_MONTH}') SELECT prov_name, '宾馆酒店' AS xfsc_type, COUNT(DISTINCT CASE WHEN is_innet = '1' THEN user_id END) AS is_innet, COUNT(DISTINCT CASE WHEN acct_tag = '1' THEN user_id END) AS acct_tag, SUM(total_fee) AS total_fee, COUNT(DISTINCT CASE WHEN is_this_break = '1' THEN user_id END) AS is_this_break, COUNT(DISTINCT CASE WHEN is_this_dev = '1' THEN user_id END) AS is_this_dev, SUM(CASE WHEN is_this_dev = '1' THEN total_fee END) AS total_fee_dev FROM zq_dwa.dwa_m_cus_al_user_indus_sq WHERE month_id = '${V_MONTH}' AND service_kind = '11' AND is_zt = '0' --AND is_zq_develop = '1'--不需要限制政企渠道 AND is_bgjd = '1' --宾馆酒店 GROUP BY month_id, prov_nam