Skip to main content
Question

StreamSets Data Collector incremental loading from AWS into RDS

  • September 26, 2024
  • 1 reply
  • 51 views

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: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. INVALID_FUNCTION_ARGUMENT: Failed to tokenize string [2] at offset [0])

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

1 reply

saleempothiwala
Headliner
Forum|alt.badge.img

@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