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.

In HDP 3.1.0, Oozie workflow failed for hive

In HDP 3.1.0, Oozie workflow failed for hive

New Contributor
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveCompatibilityMain], main() threw exception, null java.lang.NullPointerException     at org.apache.oozie.action.hadoop.HiveCompatibilityMain.run(HiveCompatibilityMain.java:123)     at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:78)     at org.apache.oozie.action.hadoop.HiveCompatibilityMain.main(HiveCompatibilityMain.java:79)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)     at java.lang.reflect.Method.invoke(Method.java:498)     at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:231)     at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)     at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:465)     at org.apache.hadoop.mapred.MapTask.run(MapTask.java:349)     at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)     at java.security.AccessController.doPrivileged(Native Method)     at javax.security.auth.Subject.doAs(Subject.java:422)     at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)     at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168) 
Oozie Launcher failed, finishing Hadoop job gracefully
2 REPLIES 2

Re: In HDP 3.1.0, Oozie workflow failed for hive

New Contributor

In the meantime, I am able to resolve this issue. Since HDP 3.1 has beeline (as hive cli is depricated) need to add "<jdbc-url>" in the workflow.

Re: In HDP 3.1.0, Oozie workflow failed for hive

New Contributor

Running hive in oozie with hive2action resolved the issue.

<hive2 xmlns="uri:oozie:hive2-action:0.1">

<jdbc-url>jdbc:hive2://jdbc:hive2://server:11000/default</jdbc-url>