Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Apache NiFi 1.6.0 Error Post Upgrade

Highlighted

Apache NiFi 1.6.0 Error Post Upgrade

Contributor

Hi all,

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 ?

Thx

Don't have an account?
Coming from Hortonworks? Activate your account here