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 Processor INSERT Issue

Highlighted

ConvertJSONToSQL Processor INSERT Issue

New Contributor

How to use dynamic sql inside sql in ConvertJSONToSQL Processor

INSERT INTO TEST (ID,NAME, PARENT_ID) VALUES (2345, ABC, SELECT ID FROM TEST WHERE NAME='XYZ')

1 REPLY 1

Re: ConvertJSONToSQL Processor INSERT Issue

New Contributor

Hi,

If you really want use the ConvertJsonToSQL processor, you need to have a field in your json object with the SQL inner query.

You can also use the EvaluateJSonPath -> replaceText -> putSQL flow to achieve that.

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