How to create table in hive using source table information from oracle or sql server

[#1]

Hello,

we would like to ingest MS Sql/Oracle database periodically in hive.

I am looking for a nifi processor that can read the database/table detail from source database and create equivalent table in hive as external table and copy the data from source table to hive table in orc format.

[#2]

This may help you :

https://community.hortonworks.com/questions/36464/how-to-use-nifi-to-incrementally-ingest-data-from....