alibaba
[bug]datax把mysql数据迁移到ob，使用"preSql": ["truncate table XXX"],无数据
{ "job": { "setting": { "speed": { "channel": 4 }, "errorLimit": { "record": 0, "percentage": 0.1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "root", "password": "XXXXX", "column": [ "" ], "where": "dt='${bizdate}'", "connection": [ { "table": ["XXXXX"], "jdbcUrl": ["jdbc:mysql://XXXX:3306/za_ods?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai"] } ] } }, "writer": { "name": "oceanbasev10writer", "parameter": { "obWriteMode": "insert", "column": [ "" ], "preSql": ["truncate table XXXXX"], "connection": [ { "jdbcUrl": "||dsc_ob10_dsc||obyyt:nldz||dsc_ob10_dsc||jdbc:oceanbase://XXXX:2883/dgped_bus_zaxq?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true", "table": ["XXXX"] } ], "username": "root", "password": "XXXX", "writerThreadCount": 10, "batchSize": 1000, "memstoreThreshold": "0.9" } } } ] } }
加上"preSql": ["truncate table XXXXX"], 后，发现任务能运行成功，但是表里没有数据。去掉这个后，没问题。
