how to create a flow in nifi that reads a hive table and saves the data in oracle?

[#1]

hi community cloudera, 

i need to read a Hive table and write the result to an Oracle table

this flow needs to be executed every hour to update the data in the Oracle table

does anyone have a test flow for this example?

[#2 · Accepted solution]

i managed to do the a simple flow using ExecuteSQLRecord reading the hive table and PutDatabaseRecord to send the data to the oracle table