JDBC Producer gets syntax error writing to Redshift DB
I’m having an issue reading from a Redshift DB. The initial query works fine and I’m able to ingest over 2M rows from Redshift to another DB. But once that initial read completes and the second one is attempted, I get the following error:
First error: SQLState: 42601 Error Code: 500310 Message: [Amazon](500310) Invalid operation: syntax error at or near "00" Position: 257; Cause: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: syntax error at or near "00" Position: 257;
Enabling debug and looking in sdc.log I can see the query that fails:
SELECT "timestamp", "id"
FROM pages
WHERE received_at > 2017-01-01 00:02:36.625000
ORDER BY received_at
LIMIT 1000