[NIFI-4843] ExecuteSQL cannot execute delete without error

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Extensions
• Labels: ExecuteSQL delete nifi sql
• Flags: Patch
• Assignee: Unassigned
• Reporter: Nimrod Avni
• Created: 05/Feb/18 21:21
• Updated: 05/Feb/18 21:21

Description

I had a scenario in which i wanted to execute a delete statement on one of my tables

the processor works, and deletes what data i needed it to delete. but after every execution it throws and exception that it cannot retrieve data from the ResultSet. i guess that's because it expects data from the db to be returned to it. but in the case of deletion there is none.

why it's a problem is that we cannot determine if the processor is doing it's job properly or not when bulletins are thrown from it. 

so i would greatly appreciate it if you could make the ExecuteSQL processor support delete queries