Support Questions
Find answers, ask questions, and share your expertise
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


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?

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