Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

I want to load my table to hive like Sqoop

Highlighted

I want to load my table to hive like Sqoop

New Contributor

Hello.

I'm trying to load my Oracle table and input Hive like Sqoop doing.

Above is my cluster environment

- Apache Nifi (Not HDF) : 1.8.0

- Cloudera Hive : 1.1.0-cdh5.15.1

In fact, I successed load my Oracle table to HDFS. But, I can't make Hive table.

Because, In Ni-Fi, "PutHiveStreaming" or "PutHiveQL" doesn't connect to Hive server.

I tried to find solution,
But, Matty Burgess answered Nifi's Processor is based on Hive 1.2.0 so it will not be incompatibility with Cloudera Hive.

Question

1) Is it true that Cloudera 5.15.1 never connects with Apahce Nifi's Hive Processors?

2) Is there any solution to create hive table with Apache Ni-Fi?

3) I want to stream my RDBMS table only once,
But, Ni-Fi's "QueryDatabasetable" streams RDBMS table infinitely. How can I get my RDBMS table only once?

Please help me~