Ask Your Question

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

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


I want to convert all the fileds in a table uppercase to lowercase, Can I use field renamer processor for it?

Dep gravatar imageDep ( 2019-04-02 09:56:50 -0500 )edit

@Dep you can but I found it easier to use a custom Javascript Evaluator function to rename all properties in the object to lowercase (as well as do some minor cleaning like remove special chars).

meash-nrel gravatar imagemeash-nrel ( 2019-06-17 13:06:45 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 276 times

Last updated: Sep 25 '17