修复代码错误：create-table-iot_kh_analysisTEMP_DEVC_ED04_FILTER_CHGE_INFO_Y-partitionprovince_name-asnselect-aapplianceidnttitem_codenttproduct_modelnttsn8nttprovince_namenttcity_name-nttperiod_datenttnew_filter1lifepercentnttnew_filter2lifepercentnttnew_fi

create table iot_kh_analysis.TEMP_DEVC_ED04_FILTER_CHGE_INFO_Y (partition by province_name) as select a.applianceid, item_code, product_model, sn8, province_name, city_name, period_date, new_filter1lifepercent, new_filter2lifepercent, new_filter3lifepercent, new_filter4lifepercent, new_filter5lifepercent, last_filter1lifepercent, last_filter2lifepercent, last_filter3lifepercent, last_filter4lifepercent, last_filter5lifepercent, changefilter1, changefilter2, changefilter3, changefilter4, changefilter5, from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss') w_insert_dt from ( select distinct applianceid, period_date, new_filter1lifepercent, new_filter2lifepercent, new_filter3lifepercent, new_filter4lifepercent, new_filter5lifepercent, last_filter1lifepercent, last_filter2lifepercent, last_filter3lifepercent, last_filter4lifepercent, last_filter5lifepercent, changefilter1, changefilter2, changefilter3, changefilter4, changefilter5 from dw_iot.dws_devc_event_qht_filter_chge_ed_d WHERE part_dt between '2022-01-01' and '2022-12-31' ) a inner join ( select appliance_id as applianceid, item_code, product_model, sn8, province_name, city_name from dw_iot.dwd_devc_info_d WHERE apptype="0xED" ) b on a.applianceid=b.applianceid;