SQL Server: JDBC Query Consumer incremental mode on a datetime column

asked 2018-10-18 06:56:00 -0600

anonymous user


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

edit retag flag offensive close merge delete