1 异常sql
upsert into WMBIGDATA.ODS_ES_CHARGING_STATION(id,evcosType,address,serviceTel,supportOrder,operatorId,stationId,stationName,stationTel,stationLng,stationLat,stationStatus,countryCode,stationType,construction,equipmentOwnerId,openAllDay,payment,businessHours,matchCars,guideText,suggestedMinimumPrice,electricityFee,serviceFee,parkFree,pictures,electricityFeeDesc,serviceFeeDesc,parkFreeDesc,provinceCode,cityCode,areaCode,adCode,parkNums,updateTime,locationlon,locationlat,stationOnLine,faultRecoveryTime,bedRate,UPDATEDATE)values('38496f40f6e88ac02449ae4051d118d3','XINGXING','北京市朝阳区蟹岛度假村蟹岛路1号路边停车场','4008280768',0,'MA1JL8DD1','467b9d2a-b885-44cb-8964-dc08b2e3b0cd’ll,’116.5583’,’40.016262‘,50,null,0,0,null,1,null,'00:00~24:00',null,null,0,'00:00~06:59 0.37元/度,06:59~09:59 0.86元/度,09:59~14:59 1.38元/度,14:59~17:59 0.86元/度,17:59~20:59 1.38~22:59 0.86元/度,22:59~23:59 0.37元/度','00:00~06:59 0.80元/度,06:59~09:59 0.64元/度,09:59~14:59 0.43元/度,14:59~17:59 0.64元/度,17:59~20:59 0.43元/度,20:59~22:59 0.64元/度,22:59'1','https://open-cdn.starcharge.com/b232eea2-edb3-439b-9829-1db6cde2ba2c.JPG','00:00~06:59 0.37元/度,06:59~09:59 0.86元/度,09:59~14:59 1.38元/度,14:59~17:59 0.86元/度,17:59~20:5度,20:59~22:59 0.86元/度,22:59~23:59 0.37元/度','00:00~06:59 0.80元/度,06:59~09:59 0.64元/度,09:59~14:59 0.43元/度,14:59~17:59 0.64元/度,17:59~20:59 0.43元/度,20:59~22:59 0.64元/80元/度','免费','11','00','05','110105',0,1523181674384,'116.5583','40.016262',5,0,0,'2019-07-21 00:00:00');
2 原因
类型不匹配 比如 integer 插入了 double这种 ，找到自己插入的Phoenix SQL中不匹配类型的部分，就可以解决问题。