Hive2 Oozie Action Doesn't Consistently Connect

[#1 · Accepted solution]

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!

[#2 · Accepted solution]

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