Apache Nifi Execute Process Processor

Question

I am trying to implement the workflow below using Apache Nifi:

1. ExecuteSQL - This is fetching data from oracle database in avro format
2. PutHDFS –This is to put the data into hdfs
3. ExecuteProcess – This processor executes a bash script in the background which in turn creates the external hive table

I have a few questions:

Does ExecuteProcess Processor in Apache Nifi takes incoming flow files?

I am not able to provide ExecuteProcess processor any incomming flow file. If not, is there any way to support taking incoming flow files?

Answer 1

ExecuteProcess does not allow incoming flow files. Take a look at the ExecuteStreamCommand processor, it accepts incoming flow files and also executes an external command.