Using ?
for incremental syncs for Greenplum seem to be broken.
The query:
SELECT * FROM "my"."dataset" WHERE last_update_time > ?
results in the 2 following errors (1 in exploration, 1 in sync):
ERROR IN EXPLORATION
-----------
ServiceException: INVALID_ARGUMENT (MagritteExplorer:SqlError): {reason=Parameter with index '0' is not specified, sqlState=HY000, vendorCode=0}
com.palantir.conjure.java.api.errors.ServiceException: ServiceException: INVALID_ARGUMENT (MagritteExplorer:SqlError): {reason=Parameter with index '0' is not specified, sqlState=HY000, vendorCode=0}
ERROR WHEN RUNNING SYNC
----------
java.sql.SQLException: Server error [SQL state: 22007]: invalid input syntax for type timestamp: "?" (Character 92)
I have tried the same sync with a real timestamp instead of the ?
operator, and it runs fine.