Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Can I use Nifi to run multiple SQL statements ?

New Contributor

I have 6-7 sql queries which needs to be executed in one after the other.

if my query fails at 4 step so my 4th sql query fails which is an insert and I want to retry it without the manual intervention can nifi do that?


also please guide regarding airflow if we can achieve the same in airflow by creating multiple dags to run one after the another. Please guide and help


Super Guru

wrap your SQL in a view / procedure / function or other Database native grouping of statements is smartest.


With running multiple sql statements you may want to use Cloudera CDE, Cloudera Machine Learning jobs, YARN Spark Jobs or Airflow.



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.