Custom JDBC Driver Error - "At least 1 query parameter is required"

Ask the Community
1

Hello Team,

I am seeing the following error in an incremental JDBC sync with a custom driver (Cloudera JDBC Driver):

message=At least 1 query parameter is required: {parameterCount=0}

On a sync of the form:

SELECT *, CAST(time_string as TIMESTAMP) AS time_ts 
FROM my.table a 
WHERE a.time_string > "?"

Where the incremental column is time_ts . If I do not wrap the ‘?’ in quotes, I get an Encountered: unexpected character error.

Does this mean that the custom JDBC driver doesn’t understand how to use the parameter referenced in the “?” ? If so, would the driver code need to be altered for this incremental sync to work?