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.

NiFi: JsonToSql converter > PutSQL null issue

Highlighted

NiFi: JsonToSql converter > PutSQL null issue

New Contributor

Given a json file:

{........ "a": "ADV", "b": "VI", "c": null, "d": null, "e": null ......}

And using the ConvertJSONtoSQL nifi processor, the attributes are not mapped correctly. It adds a ?,?,? for the nulls but it does not place a value. See picture attached.

The flowfiles converted will include insert statements with extra "?" since they do not have any values associated with the keys.

What is the proper way to ignore json 'null' values so that you can build insert statements without including the extra attributes since there is no value?


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