oozie sqoop and shell action do not connect to hive.

6 replies
4357 views
Translate All

I am trying to run a sqoop job using oozie but it log shows it stucks on connecting to hive. The Hive action is working fine and connecting to hive but sqoop action and shell action both are unable to connect to hive ... please suggest

Screenshot from 2019-12-27 15-08-10.png

mohitkaushik_inAnswer

Gold ⭐️

the issue is resolved now.

I have a cluster of 12 nodes. and on some nodes beeline-hs2Connection.xml was not present. putting the file in hive conf directory on each server resolved the issue.

thanks

Mohit

DennisJaheruddi

Platinum ⭐️

Perhaps I missed it, but what is the exact error that you see? And just in case, what command do you use? And have you successfully ran similar commands?

Also, you mentioned oozie, does that mean you can run the command outside oozie? And with the same user?

Translate

- Dennis Jaheruddin If this answer helped, please mark it as 'solved' and/or if it is valuable for future readers please apply 'kudos'.

mohitkaushik_inAuthor

Gold ⭐️

yes I can run the commands with the same user. it shows not error, it is just stuck on connecting to hive. even as mentioned above It is able to connect with hive action but not with sqoop action.

Translate

mohitkaushik_inAuthor

Gold ⭐️

I was trying to what is the difference in the process of connecting to hive when oozie connects using hive action and sqoop action. because hive action is working and connection to hive and sqoop action action is not connecting to hive and stuck.

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.