错误一、脏数据:
{"exception":"Duplicate entry '54' for key 'PRIMARY'","record":[{"byteSize":2,"index":0,"rawData":54,"type":"LONG"}, ...... ,{"byteSize":10,"index":53,"rawData":"2020-12-07","type":"STRING"}],"type":"writer"}
解决:修改表结构
前提是已验证json脚本内列类型正确
错误二、关键字
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '==distinct==,business_circle,longitude,latitude,addr_detail,phone,property_right,tra' at line 1
解决:改列名
例如:将distinct改为distinct_new