alibaba / alibaba/DataX

“writer检查”和“presql语句”的执行顺序

Open
#230 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

环境:win7,oraclereader,mysqlwriter

问题:报错提示 mysqlwriter 中指定的表(t1) 不存在

描述:数据库没有创建 t1 表,我在 json 配置文件中的 presql 中写了 t1 的建表语句,datax执行该json文件时,提示执行sql语句: “select * from db1.t1 where 1=2” 失败。

猜测:datax先检测 mysqlwriter 中的表名及列名是否与 reader 匹配后,再执行 presql?

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named. Reproduce the issue with the stated win7, oraclereader, mysqlwriter configuration and trace when the writer checks the target table relative to presql execution. Done means documenting the actual order and resolving whether presql can create t1 before metadata validation.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.