datax抽取mysql数据到hive报错:javax.net.ssl.SSLException: Connection reset

发布时间 2023-11-10 10:42:49作者: 所向披靡zz

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