SQL Server: JDBC Query Consumer incremental mode on a datetime column
I'm trying to run a incremental ingestion from a SQL Server using a JDBC Query Consumer.
The bulk ingestion works well. But when I insert a record on my DB and run again my pipeline, I got this error:
An exception occurred while running the pipeline, com.streamsets.pipeline.api.StageException: JDBC_77 - SQLServerException attempting to execute query '
select *
FROM dbo.test
where date > 2018-10-18 11:31:20.9
ORDER BY date'. Giving up after 1 errors as per stage configuration. First error: SQLState: S0001
Error Code: 102
Message: Incorrect syntax near '11'.
SQL Query:
select *
FROM dbo.test
where date > ${OFFSET}
ORDER BY date
Initial Offset: 0
Column Offset: date