Skip to main content

Hi, 

I have done full from AWS athena to RDS Postgresql.Now, i want to do incremental loading using timestamp from table and i’m jdbc query consumaer as origin and jdbc query(executor) as destination as of now and want to merge records at jdbc query side. but, i’m getting validation error from origin (

  • JDBC_34 - Query failed to execute: 'SELECT * FROM t_target_an.hierarchy WHERE date > TO_TIMESTAMP('0', '2024-09-11 00:00:00') ORDER BY date;' Error: SQLState: HY000 Error Code: 100071 Message: aSimba]iAthenaJDBC](100071) An error has been thrown from the AWS Athena client. INVALID_FUNCTION_ARGUMENT: Failed to tokenize string r2] at offset f0])

  • and also please help me with merge query which i have to use at jdbc query.

@Divya J Pasala , it looks like your to_timestamp function is wrong. It expects a datetime and format as parameters you are passing wrong values.

Reply


Terms & Conditions