datax采集sqlserver数据报错

[tandongli192]

在执行 datax采集sqlserver数据到doris 结果报错 [您配置错误. table和querySql 应该并且只能配置一个.]. - 您的配置有误. 因为table和querySql应该配置并且只能配置一个. 请检查您的配置并作出修改.

脚本： { "job": { "setting": { "speed": { "channel": 1 } }, "content": [ { "reader": { "name": "sqlserverreader", "parameter": { "username": "bigdataread", "password": "*", "column": [ "[AutoCode]", "[sDepCode]", "[sDepName]", "[sFDepCode]", "[sGCode]", "[sDepAbbName]", "[sDepPerson]", "[sDepPerson1]" ], "connection": [ { "jdbcUrl": "jdbc:sqlserver://locahost:***;DatabaseName=DatabaseName" } ], "table": [ "table_name" ] } }, "writer": { "name": "doriswriter", "parameter": { "loadUrl": [ "ip:8030" ], "loadProps": { "format": "json", "strip_outer_array": true }, "column": [ "[AutoCode]", "[sDepCode]", "[sDepName]", "[sFDepCode]", "[sGCode]", "[sDepAbbName]", "[sDepPerson]", "[sDepPerson1]" ], "username": "hr_affairs", "password": "", "flushInterval": 30000, "connection": [ { "jdbcUrl": "jdbc:mysql://localhost:9030/hr_affairs", "selectedDatabase": "hr_affairs", "table": [ "odssqlservertable_name__full" ] } ] } } } ] } }