datax从Hdfs读数据写入Mysql报错--需修改mysql建表语句

错误一、脏数据:

{"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