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.

Hive2 Oozie Action Doesn't Consistently Connect

Solved Go to solution
Highlighted

Re: Hive2 Oozie Action Doesn't Consistently Connect

Explorer

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!

 

 

Re: Hive2 Oozie Action Doesn't Consistently Connect

Expert Contributor

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