数据转换时提示[yktls_8month]物理表尚未存在,不可操作

---

背景

---

日志报错信息：2024-04-24 02:59:49.307 [job-0] ERROR JobContainer - Exception when job run
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: ALTER TABLE yktls_8month_temp RENAME TO yktls_8month 具体错误信息为：java.sql.SQLException: Error on rename of ‘./model/yktls_8month_temp’ to ‘./model/yktls_6month’ (errno: 168 - Unknown (generic) error from engine)
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:84) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.writer.util.WriterUtil.executeSqls(WriterUtil.java:103) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Job.post(CommonRdbmsWriter.java:152)[plugin-rdbms-util-\mathrm{0.0.1}-SNAPSHOT.jar:na]atcom.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Job.post(MysqlWriter.java:64) ~[mysqlwriter-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.postJobWriter(JobContainer.java:837) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.post(JobContainer.java:510) ~[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:87) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.entry(Engine.java:166) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.main(Engine.java:198) [datax-core-0.0.1-SNAPSHOT.jar:na]

---

一、步骤

---

1.查看XXXX表是否存在

检查发现没有此表，只有后缀为temp的表。

2.复制temp的表

复制表，把temp后缀名字去掉，刷新表。

3.进入数据中台查看

查看该表可以正常执行。