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.

Oozie error when using with Hive2

Re: Oozie error when using with Hive2

Contributor

Hi Guys, help is really appreciated. Totally stuck with it for both Hive and Hive2.

Re: Oozie error when using with Hive2

Contributor

Hi,

Any ideas please ? Is this an error in HDP ?

Highlighted

Re: Oozie error when using with Hive2

Contributor

Hi Guys,

Can you please guide us? Not able to progress with it at all. Really looking for some help.

Re: Oozie error when using with Hive2

Super Guru

@rajdip chaudhuri - No its not an issue with HDP.

Please try to re-create sharelib using below commands.

#Command 1
/usr/hdp/<version>/oozie/bin/oozie-setup.sh sharelib create -locallib /usr/hdp/<version>/oozie/oozie-sharelib.tar.gz -fs hdfs://<namenode>:8020


#Command 2
oozie admin -oozie http://<oozie-server>:11000/oozie -sharelibupdate

Re: Oozie error when using with Hive2

Contributor

Hi @Kuldeep Kulkarni we tried that also but didn't work. Even we uninstalled the service and installed Oozie again. We also changed the oozie library permission to 755. All these steps resulted in same error.

What we should do now? Using HDP 2.5.3 cluster. Is this an issue in this version?

Please guide us.

Re: Oozie error when using with Hive2

Contributor

We can try running these commands next week Monday. Should we run this command as the oozie user in the cluster? Also please note we are running the oozie job from individual developer passwords.

Re: Oozie error when using with Hive2

Super Guru

@rajdip chaudhuri

How are you submitting the job? I would suggest to add oozie.use.system.libpath=true in job.properties or job.xml and remove both the libpath related properties from your workflow.xml

Re: Oozie error when using with Hive2

Contributor

Since this is the first time we are doing so we using the workflow XML file directly while running the job. We added the oozie.use.system.libpath=true parameter the XML along with the other ones as in above comments. SO, do you want to add just this parameter and remove the other ? Also can you share a XML file which works on HDP-2.5.3 while connecting to beeline with auth over non-kerberized cluster?

Please suggest.

Don't have an account?
Coming from Hortonworks? Activate your account here