datax抽取mysql数据到hive报错:javax.net.ssl.SSLException: Connection reset
datax抽取mysql数据报错:
[INFO] 2023-11-09 12:35:14.090 +0000 - -> 2023-11-09 20:35:13.492 [0-0-0-reader] ERROR ReaderRunner - Reader runner Received Exceptions: com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select `OPERATE_ID`,`BANK_ID`,`CUST_ID`,`SEQNUM`,`TIMESTAMP`,`SIGN`,`MSG_CODE`,`MSG_DESC`,`OLDCUST_ID`,`DEPT_ID`,`CUST_NAME`,`CUST_ADDR`,`RESET_FEE`,`LATE_FEE`,`GAS_FEE`,`OT_FEES`,`FEES_SUM`,`CLASSIFY`,`NCBS_TIME`,`CIS_TIME`,`REQ`,`RESP` from queryfee_2022 where 1 = 1 具体错误信息为:java.sql.SQLException: Error retrieving record: Unexpected Exception: javax.net.ssl.SSLException message given: Connection reset Nested Stack Trace: ** BEGIN NESTED EXCEPTION ** javax.net.ssl.SSLException MESSAGE: Connection reset STACKTRACE: javax.net.ssl.SSLException: Connection reset
源表:mysql 4万条数据,目标表:hive;
检查所有的配置信息都是正确的,后面发现mysql有个string字段存储的字符串非常多,导致数据没有传输过来。
解决方式:
设置配置,重新抽取成功
"channel": 5 "splitPk": "OPERATE_ID",