I have a nifi flow to do transformation in hive , I am executing 100 query one by one . but if any query fail between 1 to 100 .still flow is executing . I want to stop the flow automatically once any query fail.
Please advice on above. Thanks In advance.
You have 100 flow files? Perhaps you can use wait and notify processors and release 1 flow file each time. If query is successfull then signal to release fliw file to perform next query, if not then signal to release to failure using route on attribute processor which will come after the wait processor.
Something similar to this sample: