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