纠错： CREATE TABLE IF NOT EXISTS DM_M_YX_ZBSF_YXD_A prov_id INT is_zt INT total_fee DOUBLE PARTITIONED BY month_id STRINGSTORED AS ALIORCTBLPROPERTIES COMMENT = sheet1;insert overwrite table

CREATE TABLE IF NOT EXISTS DM_M_YX_ZBSF_YXD_A( prov_id INT, is_zt INT, total_fee DOUBLE ) PARTITIONED BY ( month_id STRING ) STORED AS ALIORC TBLPROPERTIES ( 'COMMENT' = 'sheet1' );

INSERT OVERWRITE TABLE DM_M_YX_ZBSF_YXD_A PARTITION (month_id = '${v_month}') SELECT month_id, prov_id, is_zt, sum(total_fee) FROM zq_dwa.dwa_m_prt_e_all_user_info WHERE month_id >= '202303' AND is_zbsf = '1' GROUP BY month_id, prov_id, is_zt;