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

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?

Gold ⭐️

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

Gold ⭐️

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

Translate

Sign up