Ask Your Question
1

Error Inserting Data into Postgres

asked 2017-09-25 02:52:28 -0500

Vivian Y gravatar image

I try to insert data into postgres, however, i hit error from streamsets stating that the specific table or columns are not exists. My initial table name is "dailySales" and column name is "Product" and i keep hitting table and column does not exist for the database. When i switch table name to "dailysales" and column name to "product", i able to use streamsets to insert data correctly.

Is this an expected behavior for streamsets to read all table name and column name in lower case only? Is this apply across all jdbc connector?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2017-09-25 10:29:11 -0500

jeff gravatar image

StreamSets will preserve the field case as seen in the data and supply that to the JDBC producer via the query without modification. What happens after that is a function of your JDBC driver and/or database. It sounds like the particular Postgres combination you are talking about is case-sensitive, so you will probably need to use a field renamer processor to change the fields to be all lower-case.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-25 02:52:28 -0500

Seen: 99 times

Last updated: Sep 25 '17