datax-web icon indicating copy to clipboard operation
datax-web copied to clipboard

% problem in incremental update

Open ititchuan opened this issue 4 years ago • 2 comments

*For better global communication, please give priority to using English description, thx! *

Describe the question In the generated sql, there is a %, which causes the sql server to not recognize it. How to solve this?

Which version of DataX Web: -[2.1.1]

Additional context image

执行的SQL为: select * from realtime where RecordTime >= '2010-01-01%00:00:00' and RecordTime < '2022-01-10%18:21:28' 具体错误信息为:com.microsoft.sqlserver.jdbc.SQLServerException: 从字符串转换日期和/或时间时,转换失败。 2022-01-10 18:21:40 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]

**Requirement or improvement

  • Please describe about your requirements or improvement suggestions.

ititchuan avatar Jan 10 '22 10:01 ititchuan

图片

ititchuan avatar Jan 10 '22 13:01 ititchuan

请问后面咋解决的?我看源码是特意将空格替换成%的

Image

guopb6 avatar Mar 21 '25 09:03 guopb6