Reply
mav
Explorer
Posts: 8
Registered: ‎11-05-2018

Re: Hive2 Oozie Action Doesn't Consistently Connect

I've since found the following:

 

https://www.cloudera.com/documentation/enterprise/5-13-x/topics/cdh_oozie_sqoop_jdbc.html

 

Which suggests loading the data to HDFS then creating a table with a hive2 action. This has since solved my problem and I have a working job. I appreciate your help!

 

 

Cloudera Employee
Posts: 70
Registered: ‎04-03-2017

Re: Hive2 Oozie Action Doesn't Consistently Connect

Hi,

 

There are 2 options that you can do.

 

1. Sqoop import command with + hive import ( 1 step hive import)

2. Sqoop import to HDFS and create hive table on top of it.

 

Either of the above option will reach the desired results.

 

Let me know if you have any questions.

 

Regards

Nitish