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 24, 2014

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms