@Simon Elliston Ball Thanks for the thorough answer. I've tried to use putemail processor for failed relationships - but i didn't get any email even though the step completed with an error. To be more exact - I do receive email for successful steps without a problem, however, i have a flow in which the last step finishes with error but i get no email unless i set the relationship to retry. If i set the relationship to the putemail processor from the last step as success - no email, If i set it to failed - no email if i set to retry - i do receive email. Isn't "error" means the step failed ? Any idea ? Adi ... View more

@Constantin Stanca Hi and thank you for replying. Just to be clear - i have two tables: staging and permanent. I want to select from the staging table and insert the results to the permanent table. So i created a process group with SelectHiveQL processor that queries a specific column (event_time) In that process group i created a sub process group for the insert process. I started the process group with an Input port and connected it to a ReplaceText processor that has the following syntax for replacement value: INSERT INTO nifitest (event_time) VALUES ('${event_time}') and of course connected it to a "PutHiveQL" processor. The flow ends successfully - but the column is blank. Not NULL. But blank. No values what so ever. I tried all kinds of syntax and even using "UpdateAttribute" processor - but nothing seems to work. I am able to insert hard coded values into a the column using: INSERT INTO nifitest (event_time) VALUES ('2222222') It seems as if the select output isn't transferred to the sub-process group or that my syntax is incorrect. Could you advise ? Thanks in advance! Adi ... View more

Thank you @Matt Burgess ... View more

Hi @Pierre Villard Unfortunately there is no stack trace. Just this error as is. Also, it only happens when output format is "CSV". Using "Avro" it succeeds without errors - but i have no idea where the output results are (not familiar with Avro). My goal is to select data from hive and insert it to another table. If i don't get a file with all the output of the select - how can i insert the output ? Btw, we are using 0.70 NiFi ... View more

Hi @Predrag Minovic Thank you for responding! ... View more