I have an Avro message coming out of SplitAvro processor. This message contains a field and its value VAL. I want to run an update SQL against a database table as follows:
Update table X set Status='Processed' where ID = VAL;
How can I achieve this in NiFi?
I was able to accomplish this by using SplitAvro --> QueryRecord --> PutSQL