040.mysql-datax从hive导入mysql报错：（表情包字符）java.sql.SQLException: Incorrect string value: 'ðŸ

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}