I have to store data coming in from Kafka queue into a hive table. However, some values are null. Eg: {     "id":"123",     "name":"Sam",     "dob":"02-01-2000",     "gender":"m",     "food_prefernce":null }   When I pass this json through the ConvertJSONToSQL processor, I get sql.args.n.type for all 5 keys but sql..args.n.value for only 4 of them. The null value is not turned into sql.args.5.value. For this, I manually need to add the missing attributes to the file.   The problem is that I have a total of 57 columns in the table and any of those values could be null. I am using the UpdateAttribute processor to check whether a given attribute is null or not, if yes, then i want to add that attribute having null value.   How do I check whther hiveql.args.<>.value is null and then update all in one shot? Any way to write a generic expression to check all such attribute values? Thanks in advance! @mburgess  @MattWho  @stevenmatison  @gazzer82 @TimothySpann @sunile_manjee  ... View more