Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

Explorer

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.

1 REPLY 1

Contributor