Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ConvertJSONToSQL - Ignores underscore in update keys

Solved Go to solution

ConvertJSONToSQL - Ignores underscore in update keys

Explorer

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

Accepted Solutions
Highlighted

Re: ConvertJSONToSQL - Ignores underscore in update keys

Explorer

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

2 REPLIES 2
Highlighted

Re: ConvertJSONToSQL - Ignores underscore in update keys

Explorer

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

 

Highlighted

Re: ConvertJSONToSQL - Ignores underscore in update keys

Explorer

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

Don't have an account?
Coming from Hortonworks? Activate your account here