I have the following SQL statements in Impala:
1) 2 drop statements
2) 2 create table statements
3) 2 insert overwrite statements
These all statements are kept as a part of the file in Hadoop
How will I make sure that all of these gets executed in NIFI in sequence. As of now I am using ExecuteSQL processor for the same. Please let me know how can it be done.