[OOZIE-1955] Unable to run hive scripts from Oozie shell action

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0

Environment

Hive .12,Oozie 4.0

• Assignee: Unassigned
• Reporter: Anuroopa George
• Created: 31/Jul/14 18:20
• Updated: 09/Aug/15 06:19
• Resolved: 31/Jul/14 21:35

Description

While trying to execute Hive script from shell script(shell action of Oozie) using hive -f command,Hive script fails.
The problem is that the shell script is submitted from Oozie as mapred user,and the staging area is created with respect to the user who submits the Oozie workflow.So mapred user is unable to
access this staging area and the hive scripts get failed.

Below is the exception:

java.io.IOException: The ownership on the staging directory hdfs://nameservice1/user/user1/.staging is not as expected.
It is owned by user1. The directory must be owned by the submitter mapred or by mapred
at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(JobSubmissionFiles.java:113)