My Oracle Support Banner

Oozie Hive Action with Query to Insert a Table from HBase to Hive in Secure Environment Fails with: return code 2 from (Doc ID 1952344.1)

Last updated on DECEMBER 02, 2021

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later


Oozie Hive action with a query to insert a table from HBase to Hive in secure environment fails on BDA V3.0.1/CDH 5.0.1 with errors like:

From the Oozie log files:

14/12/08 20:20:13 ERROR mr.MapredLocalTask: Execution failed with exit status: 2
14/12/08 20:20:13 INFO log.PerfLogger: </PERFLOG method=task.MAPREDLOCAL.Stage-4 start=1418098257376 end=1418098813077 duration=555701 from=org.apache.hadoop.hive.ql.Driver>
FAILED: Execution Error, return code 2 from
14/12/08 20:20:13 ERROR ql.Driver: FAILED: Execution Error, return code 2 from

The stdout.txt file reports:

5935 [main] INFO  - Executing: /usr/lib/hadoop/bin/hadoop jar <path-to-jar>/hive-exec-0.12.0-cdh5.0.1.jar -localtask -plan <path-to-plan>/plan.xml -jobconffile file:<path-to-jobconf>/jobconf.xml

Heart beat
Heart beat
Heart beat
561338 [main] ERROR org.apache.hadoop.hive.ql.exec.Task  - Execution failed with exit status: 2
561339 [main] ERROR org.apache.hadoop.hive.ql.exec.Task  - Obtaining error information
561339 [main] ERROR org.apache.hadoop.hive.ql.exec.Task  -
Task failed!
Task ID:

The same query is successful via the Beeline CLI and from Oozie Hiveserver2. 


The patch to resolve:
HIVE-8874 - Error Accessing HBase from Hive via Oozie on Kerberos 5.0.1 cluster
This is also Cloudera Internal Jira: CDH-23027

was applied on top of BDA V3.0.1/CDH 5.0.1 via Installing One-Off Patch 20133235 on Oracle Big Data Appliance Cluster to V3.0.1 OEL 6 with Mammoth (Software Deployment Bundle) (Doc ID 1950865.1).  Patch 20133235 backports the above fixes to BDA 3.0.1.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.