yangezheyue 2022-12-28 18:33 采纳率: 0%
浏览 15

DATAX 数据导出MySQL

datax测试MySQL输出报错,MySQL输出到MySQL报连接错误,输出到文件报如下错误

2022-12-28 18:15:29.560 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
2022-12-28 18:15:29.564 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false, priority=0
2022-12-28 18:15:29.564 [main] INFO JobContainer - DataX jobContainer starts job.
2022-12-28 18:15:29.568 [main] INFO JobContainer - Set jobId = 0
2022-12-28 18:15:31.113 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://192.168.81.25:3306/video?characterEncoding=utf8&useSSL=true&serverTimezone=Asia/Shanghai&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
2022-12-28 18:15:31.142 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
2022-12-28 18:15:31.143 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] do prepare work .
2022-12-28 18:15:31.144 [job-0] INFO JobContainer - DataX Writer.Job [streamwriter] do prepare work .
2022-12-28 18:15:31.144 [job-0] INFO JobContainer - jobContainer starts to do split ...
2022-12-28 18:15:31.146 [job-0] INFO JobContainer - Job set Max-Byte-Speed to 10485760 bytes.
2022-12-28 18:15:31.157 [job-0] ERROR JobContainer - Exception when job run
java.lang.ClassCastException: java.lang.String cannot be cast to java.util.List
at com.alibaba.datax.common.util.Configuration.getList(Configuration.java:426) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.util.ReaderSplitUtil.doSplit(ReaderSplitUtil.java:94) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Job.split(CommonRdbmsReader.java:103) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Job.split(MysqlReader.java:49) ~[mysqlreader-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.doReaderSplit(JobContainer.java:732) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.split(JobContainer.java:393) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:117) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.start(Engine.java:92) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.entry(Engine.java:171) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.main(Engine.java:204) [datax-core-0.0.1-SNAPSHOT.jar:na]
2022-12-28 18:15:31.165 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2022-12-28 18:15:31.168 [job-0] ERROR Engine -

  • 写回答

2条回答 默认 最新

  • 流比 2022-12-28 18:56
    关注

    检查你的 DataX 配置文件,找出哪个配置项的值被写成了字符串,然后将它修改为列表。

    例如,如果你的配置文件中有一行写成了这样:
    "column": "id,name,age"
    那么可以将它修改为:
    "column": ["id", "name", "age"]

    评论

报告相同问题?

问题事件

  • 创建了问题 12月28日

悬赏问题

  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测