alibaba / DataX

DataX是阿里云DataWorks数据集成的开源版本。
Other
15.54k stars 5.35k forks source link

达梦数据库作为writer时,支不支持更新 #2135

Open SKY-Hao opened 1 month ago

SKY-Hao commented 1 month ago

达梦数据库作为writer时, writwMode能不能设置为update;目前我的是如下: { "job": { "setting": { "speed": { "channel":"4" } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "root", "password": "root", "connection": [ { "querySql": [ "SELECT id,name FROM user" ], "jdbcUrl": ["jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&zeroDateTimeBehavior=round"] } ] } }, "writer": { "name": "rdbmswriter", "parameter": { "writeMode":"replace", "column": [ "id", "name" ], "connection": [ { "jdbcUrl": "jdbc:dm://127.0.0.1:5236/TEST", "table": ["TEMP_USER"] } ], "username": "TEST", "password": "123456789", "postSql": [], "preSql": [] } } } ] } } 执行时提示我:Code:[DBUtilErrorCode-00], Description:[您的配置错误.]. - 写入模式(writeMode)配置有误. 因为不支持配置参数项 writeMode: replace, 仅使用insert sql 插入数据. 请检查您的配置并作出修改.

Sun260 commented 1 month ago

遇到了同样问题,找到解决办法了吗?

SKY-Hao commented 3 weeks ago

没有

Ashonyer commented 2 weeks ago

image 看起来通用插件rdbmswriter只支持insert一种模式

hoyuleds commented 2 weeks ago

来个高手重写一个达梦的插件吧