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 org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask (Doc ID 1952344.1)

Last updated on DECEMBER 02, 2021

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
x86_64

Symptoms

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 org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
14/12/08 20:20:13 ERROR ql.Driver: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask


The stdout.txt file reports:

5935 [main] INFO  org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask  - Executing: /usr/lib/hadoop/bin/hadoop jar <path-to-jar>/hive-exec-0.12.0-cdh5.0.1.jar org.apache.hadoop.hive.ql.exec.mr.ExecDriver -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:
 Stage-4


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


Changes

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.

Cause

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
Symptoms
Changes
Cause
Solution
References


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