Just upgraded to the latest and grates NiFi 1.6.0 and i am getting a strange error on a ExecuteSQL Processor.
error: cannot insert multiple commands into a prepared statement
So the ExecuteSQL uses a Database Connection Pooling Service that runs some queries against a database in this case Vertica(with the latest jar), and there are multiple sequential queries.
I managed to fix the issue by rolling back my Apache NiFi Install to NiFi 1.5.0 and is all normal now.
I can also replicate the error.
I actually made a short Video on the behavior of the ExecuteSQL on 1.5.0 vs 1.6.0.
Demo of Error
Also Link: https://youtu.be/FJPf7PDmTSE
Any ideas ? maybe a bug with new release ?