alibaba / DataX

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

ob写组件不支持同一个配置文件多个表写操作吗? #1933

Open h1houhou opened 11 months ago

h1houhou commented 11 months ago

对datax 的 ob读写组件做了测试 : oralce 至 ob oracle 1)同一个配置文件支持 单表的 读/写 操作; 2)同一个配置文件支持 多表的读操作, 不支持多表的写操作; 会报:java.lang.RuntimeException: writing to multi-tables is not supported

由于文档中提到 table支持多表配置,使用 oracle 的读写组件做了测试:oralce 至 oracle 1)同一个配置文件支持 单表的 读/写 操作; 2)同一个配置文件支持 多表的 读/写 操作;

请问一下各位大神,这个是预期行为 吗? 还是配置问题?

h1houhou commented 11 months ago

oracle - ob oracle 的配置文件: { "job": { "content": [{ "reader": { "name": "oraclereader", "parameter": { "column": [ "" ], "connection": [{ "jdbcUrl": [ "jdbc:oracle:thin:@//192.168.100.1:1521/orcl" ], "table": [ "T0906_500","T0906_500_1" ] } ], "username": "dxuser01", "password": "oracle_4U" } }, "writer": { "name": "oceanbasev10writer", "parameter": { "username": "oboracleuser@oracle001", "password": "oracle_4U", "column": [ "" ], "connection": [{ "jdbcUrl": "jdbc:oceanbase://192.168.1.171:2881/oboracleuser?connecTimeout=5000&rewriteBatchedStatements=true&allowMultiQueries=true&characterEncoding=gbk", "table": [ "T0906_500","T0906_500_1" ] } ] } } } ], "setting": { "speed": { "channel": 4 } } } }

h1houhou commented 11 months ago

oracle to oracle 的配置文件: [testtpcc@localhost datax]$ cat job/oracle2oracle.json { "job": { "content": [{ "reader": { "name": "oraclereader", "parameter": { "column": [ "" ], "connection": [{ "jdbcUrl": [ "jdbc:oracle:thin:@//192.168.100.1:1521/orcl" ], "table": [ "T0906_500","T0906_500_1" ] } ], "username": "dxuser01", "password": "oracle_4U" } }, "writer": { "name": "oraclewriter", "parameter": { "username": "dxuser02", "password": "oracle_4U", "batchSize": 2000, "column": [ "" ], "connection": [{ "jdbcUrl": "jdbc:oracle:thin:@//192.168.100.1:1521/orcl", "table": [ "T0906_500","T0906_500_1" ] } ] } } } ], "setting": { "speed": { "channel": 4 } } } }