insert overwrite table zzsfp_hwmx select translate(trim(fp_nid),'%[(]',''), date_key,hwmc,ggxh,dw,sl,dj,je,se,translate(trim(spbm),'%[(]','') from zzsfp_hwmx;
insert overwrite table zzsfp_hwmx select translate(trim(fp_nid),'%[(]',''), date_key,hwmc,ggxh,dw,sl,dj,je,se,translate(trim(spbm),'%[(]','') from zzsfp_hwmx;