Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

ConvertJSONToSQL - Ignores underscore in update keys

avatar
Contributor

Eg: Update table table_name emp_name=? where empid=?

 

But My column name is emp_id

2020-03-23 14_07_19-NiFi Flow.png

1 ACCEPTED SOLUTION

avatar
Contributor

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

View solution in original post

3 REPLIES 3

avatar
Contributor

Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below  replace with - underscore.

 

MPraveen_0-1586150104815.png

 

avatar
Contributor

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

avatar
Explorer

I set the Translate Field Names to false, it started working, before this it was converting the primary key field to upper case, removing the underscore, so when I run the putSQL, it was throwing error, working fine now, thanks to your answer!