Support Questions
Find answers, ask questions, and share your expertise

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

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

Contributor