040.mysql-datax从hive导入mysql报错：（表情包字符）java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x87\xF0\x9F...' for column 'member_name

040.mysql-datax从hive导入mysql报错：（表情包字符）

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x87\xF0\x9F...' for column 'member_name

 

解决方法

：jdbc链接添加配置

 ?com.mysql.jdbc.faultInjection.serverCharsetIndex=45

 

  - name: exp_ads_table_name 
    type: command
    config:
      command: sh tools/mysql.sh "${accuracy}" "${entry}" "${abort}" customers ads_table_name "${hive.database.saas}" "${engine2.jdbc.url}&com.mysql.jdbc.faultInjection.serverCharsetIndex=45" "${engine2.jdbc.user}" "${engine2.jdbc.password}"