Hive SQL语句优化：计算关键客户总费用

INSERT OVERWRITE TABLE DM_M_YX_ZBSF_YXD_2 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 = '0' ) 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;