OWB中对目标表的Insert/Update 和 Update/Insert的区别

最新推荐文章于 2025-04-20 19:27:43 发布
原创 最新推荐文章于 2025-04-20 19:27:43 发布 · 1.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#merge #数据库 #insert

本文介绍了OWB中目标表Insert/Update和Update/Insert的区别。Insert/Update先插入，失败则更新，无匹配行则插入；选此且基于行处理需设唯一约束，基于集处理会生成merge语句。Update/Insert先更新，选此且基于集操作也会生成Merge语句。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

OWB中对目标表的Insert/Update 和 Update/Insert的区别

    Insert/Update:对任何引入的行，先执行插入操作，假如插入操作失败，则执行update操作。如果没有匹配的行来执行更新，则执行Insert。
    如果选择了Insert/Update并且默认的处理模式是基于行的处理模式，则必须在目标上设置一个唯一约束。
    如果选择了Insert/update并且默认的处理模式是基于集的处理模式,OWB将在数据库中生产merge语句.

    Update/Insert:对任何引入的行，先执行更新操作，如果选择了Update/Insert并且默认的对目标的操作模式是基于集的，OWB将在数据库中生成Merge语句。

INSERT、REPLACE、UPDATE的区别
u012846445的博客
10-20 6675
       用于操作数据库的SQL一般分为两种，一种是查询语句，也就是我们所说的SELECT语句，另外一种就是更新语句，也叫做数据操作语句。言外之意，就是对数据进行修改。在标准的SQL中有3个语句，它们是INSERT、UPDATE以及DELETE。在MySQL中又多了一个REPLACE语句，因此，本文以MySQL为背景来讨论如何使有SQL中的更新语句。 一、INSERT和REPLACE     &
ETL 基础知识
YKenan的博客
01-08 1102
ETL 基础知识1. 基础概念1.1 背景1.2 定义1.2.1 数据的抽取 (Extract)1.2.2 数据的清洗转换 (Cleaning、Transform)1.2.3 数据加载 (loading)1.3 常见的实现方式2. 模式介绍2.1 触发器模式2.2 增量字段2.3 全量同步2.4 日志比对2.5 模式对比3. ETL 日志, 警告发送3.1 ETL 日志3.2 警告发送4. ETL 工具4.1 为什么要使用 ETL 工具4.2 ETL 工具选择依据4.3 主流 ETL 工具推荐 1. 基础
Insert、Replace、Update的区别
qq_40262372的博客
07-01 2907
Insert、Replace、Update的区别 先将三个使用格式列出： INSERT INTO tablename(列名…) VALUES(列值); INSERT INTO tablename SET column_name1 = value1, column_name2 = value2，…; REPLACE INTO tablename(列名…) VALUES(列值); REPLACE INTO tablename SET column_name1 = value1, colum...
MySQL添加修改操作（insert、update、alter区别说明）
weixin_45639224的博客
09-08 4801
MySQL添加修改操作（insert、update、alter区别说明）
在 SQL 中，UPDATA 和 INSERT存在的区别
qq_49323346的博客
09-19 1183
INSERT 语句只需要指定要插入的表和要插入的列，以及新记录的值。在这个示例中，students 表中将增加一条新记录，包含编号为 5，姓名为 "Alice"，年龄为 18 和成绩为 95 的信息。在使用 UDPATE 语句时，需要指定要更新的表、要更新的列和新值，以及一个条件，以确定哪些记录需要被更新。在这个示例中，students 表中的其他记录不会受到影响，只有编号为 1 的记录的年龄会被更新。在使用 INSERT 语句时，需要指定要插入的表和要插入的列，以及新记录的值。
sql insert and update
weixin_34007291的博客
02-20 248
1 二者的区别 insert是插入一条新的数据，它会创建一条新的记录；update是更新一条已经有的数据，它不会创建新的记录。 update需要where来指示更新那条记录，否则会更新所有的记录。 2 转载于:https://www.cnblogs.com/hustdc/p/8455206.html...
Oracle外部表的创建与使用教程
5. DML操作限制：外部表不支持更新（UPDATE）、插入（INSERT）或删除（DELETE）操作，除非使用特殊的Oracle_LOADER或CSV_LOADER选项。它们主要用于只读查询。 6. 安全性：对外部表的访问需要适当的权限，包括对目录...
Oracle11g 安装过程教程：未找到文件 D:\app\Administrator\product\11.2.0\dbhome_2\owb\external\oc4j_applications\.
热门推荐
Domen Wang的博客
03-26 1万+
Oracle11g 安装过程出现提示：未找到文件 D:\app\Administrator\product\11.2.0\dbhome_2\owb\external\oc4j_applications\applications\WFMLRSVCApp.ear 下载路径：先进Oracle官网下载 http://www.oracle.com/technetwork/database/enterpris...
{"failed":true,"code":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]","message":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]","type":"warn","exception":"JSON parse error: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n'); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `com.hand.hdsp.factory.datax.api.dto.DataxSyncDTO` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('\n{\n{\"creationDate\":\"2025-07-24 13:20:59\",\"createdBy\":327326,\"lastUpdateDate\":\"2025-07-24 13:20:59\",\"lastUpdatedBy\":327326,\"objectVersionNumber\":1,\"_token\":\"ZbSIi1wKurz2owB5d6iuNw7dpX+EUsXk/eMQ5Y+AFjjPEooxrxBHYAEaOlkC4VYSN4NUWEa6B2gNznzqIPRPAxavg+k1IZ4vvDyta/GqUGo=\",\"syncId\":49291,\"syncName\":\"DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest\",\"syncType\":\"OPTION\",\"sourceDatasourceType\":\"ORACLE\",\"sourceDatasourceId\":215,\"sourceDatasourceCode\":\"DG_PDB_KJWOMSPD\",\"writeDatasourceType\":\"DORIS\",\"writeDatasourceId\":151,\"writeDatasourceCode\":\"DM_DORIS_ETL\",\"sourceSchema\":\"NONEDIOMS\",\"sourceObjectType\":\"TABLE\",\"sourceTable\":\"MANUAL_850_M\",\"writeTable\":\"ods_oms_manual_850_m\",\"writeSchema\":\"ods\",\"settingInfo\":\"{\"job\":{\"setting\":{\"speed\":{\"channel\":\"1\"},\"errorLimit\":{\"record\":\"0\",\"percentage\":\"0\"}},\"content\":[{\"reader\":{\"name\":\"oraclereader\",\"datasourceCode\":\"DG_WMS_LXSZ\",\"parameter\":{\"schema\":\"NONEDIOMS\",\"incrementStrategy\":\"NONE\",\"incrementColumn\":\"\",\"where\":\"\",\"username\":\"bigdata_etl\",\"password\":\"${pwd:twmuhtzQcquNShueKrS6CA==}\",\"column\":[{\"name\":\"PO_TYPE\"},{\"name\":\"AC_PO\"},{\"name\":\"PO_DATE\"},{\"name\":\"VENDORINFO\"},{\"name\":\"RESALENO\"},{\"name\":\"CURRENCY\"},{\"name\":\"PAYTERMS\"},{\"name\":\"DELTERMS\"},{\"name\":\"UPDATE_BY\"},{\"name\":\"LAST_UPDATE\"},{\"name\":\"HUBCODE\"},{\"name\":\"PO_REGION\"},{\"name\":\"SERIAL_FLAG\"},{\"name\":\"CUST_LOC\"},{\"name\":\"VENDOR_CODE\"},{\"name\":\"SCRAP_FLAG\"},{\"name\":\"SHIPTYPE\"},{\"name\":\"data_source\",\"value\":\"'DG_WMS_LXSZ.NONEDIOMS'\"},{\"name\":\"site\",\"value\":\"'LXSZ'\"},{\"name\":\"local_create_by\",\"value\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\"},{\"name\":\"local_create_time\",\"value\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\"}],\"splitPk\":\"\",\"connection\":[{\"table\":[\"\\\"NONEDIOMS\\\".\\\"MANUAL_850_M\\\"\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.190.23.106:1521/pdb_szwms2pd\"]}],\"fetchSize\":1024}},\"writer\":{\"name\":\"doriswriter\",\"datasourceCode\":\"DM_DORIS_ETL\",\"parameter\":{\"schema\":\"ods\",\"username\":\"doris_etl\",\"password\":\"${pwd:vj1PHfxXKArOYDX4+ydxHBIQI2J9eacwoWjGBZbP6nI=}\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"feLoadUrl\":[\"10.190.196.80:8030\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\",\"database\":\"`ods`\",\"table\":\"`ods_oms_manual_850_m`\",\"loadProps\":{},\"connection\":[{\"table\":[\"`ods`.`ods_oms_manual_850_m`\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":500000}}}]}}\",\"expressionInfo\":\"[{\"name\":\"data_source\",\"expression\":\"'DG_WMS_LXSZ.NONEDIOMS'\",\"addFlag\":1},{\"name\":\"site\",\"expression\":\"'LXSZ'\",\"addFlag\":1},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxsz'\",\"addFlag\":1},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1}]\",\"tenantId\":5,\"jvmParam\":\"--jvm=\"-Xms1G -Xmx2G\"\",\"projectId\":0,\"columnExpressionList\":[{\"name\":\"PO_TYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":0},{\"name\":\"AC_PO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":1},{\"name\":\"PO_DATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":2},{\"name\":\"VENDORINFO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":3},{\"name\":\"RESALENO\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":4},{\"name\":\"CURRENCY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":5},{\"name\":\"PAYTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":6},{\"name\":\"DELTERMS\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":7},{\"name\":\"UPDATE_BY\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":8},{\"name\":\"LAST_UPDATE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":9},{\"name\":\"HUBCODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":10},{\"name\":\"PO_REGION\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":11},{\"name\":\"SERIAL_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":12},{\"name\":\"CUST_LOC\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":13},{\"name\":\"VENDOR_CODE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":14},{\"name\":\"SCRAP_FLAG\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":15},{\"name\":\"SHIPTYPE\",\"expression\":\"\",\"addFlag\":0,\"uniqKey\":16},{\"name\":\"data_source\",\"expression\":\"'DG_PDB_KJWOMSPD.NONEDIOMS'\",\"addFlag\":1,\"uniqKey\":17},{\"name\":\"site\",\"expression\":\"'LXKJ'\",\"addFlag\":1,\"uniqKey\":18},{\"name\":\"local_create_by\",\"expression\":\"'WF5_0_prd_doris_ods_oms_manual_850_m_lxkj'\",\"addFlag\":1,\"uniqKey\":19},{\"name\":\"local_create_time\",\"expression\":\"'${_p_current_date_time:yyyy-MM-dd HH:mm:ss}'\",\"addFlag\":1,\"uniqKey\":20}],\"dataxFilePath\":\"/data/hdsp/infra/script/DATAX_JSON_FILE_HOME//5_0_datax_DX5_0_doris_ods_oms_manual_850_m_lxkj_nonedioms_ttest.json\",\"param\":{\"job\":{\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"record\":0,\"percentage\":0.02}},\"content\":[{\"reader\":{\"parameter\":{\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}},\"writer\":{\"parameter\":{\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"]}}}]}},\"columnDesensitizationDTOList\":[],\"sync\":{\"reader\":{\"schema\":\"NONEDIOMS\",\"column\":[\"PO_TYPE\",\"AC_PO\",\"PO_DATE\",\"VENDORINFO\",\"RESALENO\",\"CURRENCY\",\"PAYTERMS\",\"DELTERMS\",\"UPDATE_BY\",\"LAST_UPDATE\",\"HUBCODE\",\"PO_REGION\",\"SERIAL_FLAG\",\"CUST_LOC\",\"VENDOR_CODE\",\"SCRAP_FLAG\",\"SHIPTYPE\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"incrementStrategy\":\"DATE\",\"incrementColumn\":\"PO_DATE\",\"where\":\"PO_DATE >= to_date('${_p_last_date_time:-1:day}', 'YYYY-MM-DD HH24:MI:SS') and PO_DATE < to_date('${_p_current_date_time}', 'YYYY-MM-DD HH24:MI:SS')\",\"splitPk\":\"\",\"fetchSize\":1024,\"__dirty\":true,\"username\":\"bigdata_etl\",\"connection\":[{\"table\":[\"MANUAL_850_M\"],\"jdbcUrl\":[\"jdbc:oracle:thin:@10.68.22.26:1521/PDB_KJWOMSPD\"]}]},\"writer\":{\"schema\":\"ods\",\"column\":[\"po_type\",\"ac_po\",\"po_date\",\"vendorinfo\",\"resaleno\",\"currency\",\"payterms\",\"delterms\",\"update_by\",\"last_update\",\"hubcode\",\"po_region\",\"serial_flag\",\"cust_loc\",\"vendor_code\",\"scrap_flag\",\"shiptype\",\"data_source\",\"site\",\"local_create_by\",\"local_create_time\"],\"preSql\":[\"\"],\"postSql\":[\"\"],\"writeMode\":\"insert\",\"batchSize\":200000,\"__dirty\":true,\"username\":\"doris_etl\",\"connection\":[{\"table\":[\"ods_oms_manual_850_m\"],\"jdbcUrl\":\"jdbc:mysql://10.190.196.80:9030\"}]},\"setting\":{\"speed\":{\"channel\":1},\"errorLimit\":{\"percentage\":0,\"record\":0}},\"transformer\":null},\"sourceTableLov\":{\"tableName\":\"MANUAL_850_M\",\"__dirty\":false},\"writeTableLov\":{\"tableName\":\"ods_oms_manual_850_m\"},\"__id\":447501,\"_status\":\"create\"}\n')\n at [Source: (PushbackInputStream); line: 1, column: 1]"}
最新发布
07-25
### 三级标题：Jackson 反序列化错误的原因与...3. 如何在 Jackson 中启用和禁用特定的反序列化特性？ 4. 如何使用 Jackson 的 `@JsonInclude` 注解控制序列化行为？ 5. 如何解决 Jackson 反序列化时的循环引用问题？
算法面试必备-----数据仓库常见面试题
Avery123123的博客
08-10 3696
算法面试必备-----数据仓库常见面试题算法面试必备-----数据仓库常见面试题问题：简述数据仓库中的表的基本类型，以及为了保证引用完整性该以什么样的顺序对它们进行加载问题：事实表和维度表的概念及类型事实表的概念事实的类型维度表维度分类问题：星型模型和雪花模型区别问题：拉链表使用场景和实现方式？问题：拉链表性能优化问题：缓慢变化维的设计？ 算法面试必备-----数据仓库常见面试题 问题：简述数据仓库中的表的基本类型，以及为了保证引用完整性该以什么样的顺序对它们进行加载 答：数据仓库中的表的基本类型有维度表、
数据表的三种基本操作（insert、delete、update）
weixin_33857679的博客
02-16 1525
一、表的三种基本操作：插入(insert)、删除(delete)、更新(update) 1、insert 语法：insert into 表名 （字段名列表） values （字段值列表） 作用：向指定表中插入记录 注意：A、一次只能插入一条记录 B、字段名列表与字段值列表一一对应（数量、类型） C、如果是数值型、逻辑型、货币型可直接输入，如果是字符型、日期型必须要...
MYSQL开发性能研究之INSERT，REPLACE，INSERT-UPDATE性能比较
雨和你的故事
04-08 3052
一、为什么要有这个实验 我们的系统是批处理系统，类似于管道的架构。而各个数据表就是管道的两端，而我们的程序就类似于管道本身。我们所需要做的事情无非就是从A表抽取数据，经过一定过滤、汇总等操作放置到B表。如果出现了错误，那么就从重新跑这一个管道。所以说，我们的系统其实根本就不要什么事务性，无非就是挂了把表给TRUNCATE（或者有条件地DELETE）一下，然后重跑就行了。 这样一来，对于
sql中alter和update区别
qq_21649151的博客
06-27 1817
alter：是DDL语句，是修改数据库中对象（表，数据库，视图。。）的语句update：是DML语句，是修改表中数据的语句。
PostgreSQL insert update 常用操作及insert用法区别
qq_654603797
05-17 5526
创建测试数据表 create table student ( id int constraint idx_id primary key, name varchar(20) constraint cst_name not null ); 插入数据 insert into student values(1,'lens'); 1. 根据字段，当id冲突时更新name值 insert into student values(1,'y5935') ON CONFLICT(id) d...
oracle、sqlserver、db2写入性能对比
huryer的专栏
04-01 2137
服务器配置 服务器类型 cpu 内存 Windows 2008 R2 32 16G 数据库配置 数据库类型 CPU 内存 oracle 11gR2 默认值 8G sqlserver 2005 默认值 8G db2 10.5 默认值 8G 测试输出列含义 输出列名称 含义 DB_Type 数据库类型：oracle，sqlserver，d...
insert和update的一些性能对比测试
杨建荣的学习笔记
03-29 3169
这是学习笔记的第1933篇文章 今天在做中间件的测试时，突然想到之前的一些思路也可以借鉴一下，这块的内容还是比较有意思，简单剧透一下，如何把drop操作转换为alt...
数据库：ALTER、UPDATE、INSERT 的区别与应用
2303_79975149的博客
04-20 1230
数据库：ALTER、UPDATE、INSERT 的区别与应用
Mysql数据库insert、replace、update、delete、truncate、drop、select语句介绍
树下一少年的博客
05-31 9591
Mysql数据库insert、replace、update、delete、truncate、drop、select语句介绍
你真的懂insert or update？
weixin_45701550的博客
06-14 1万+
在业务系统开发过程中，作为一个“curd boy”，经常会对数据库进行新增和修改，新增操作相对简单，直接执行insert 操作即可，而对于更新操作，就比较复杂一点了，主要是因为被更新的字段不是固定的，有的业务需要更新满足条件数据行的A字段，有的需要更新B字段，有的A字段和B字段都要更新。难不成写三个实现，分别用来更新A，B和A，B? 如果字段少的话，这种做法未尝不可，但是如果需要更新的字段很多话，这种做法是就有点要命了。 1.无差别更新 使用mybatis的读者，对于这个问题有一个比较好用的解决方案，那就是
全面掌握OWB11g操作：中文培训教程解读
用户可以使用OWB来简化从数据源提取数据、转换数据以满足数据仓库的要求、以及加载数据到目标仓库的过程。 ### 知识点二：OWB11g中文培训教程内容概览 1. **安装配置**：这将涉及安装OWB11g软件的系统要求，以及...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值