[
https://issues.apache.org/jira/browse/OOZIE-1955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14663278#comment-14663278
]
Gaurav Kumar commented on OOZIE-1955:
-------------------------------------
I found a work-around.
Use shell action but in the shell file, ssh to localhost and then you can run
{{hive -f}} comamnds.
Something like this:
{{ssh -o StrictHostKeyChecking=no user@host "./run-shell.sh"}}
Hope it helps.
> Unable to run hive scripts from Oozie shell action
> ---------------------------------------------------
>
> Key: OOZIE-1955
> URL: https://issues.apache.org/jira/browse/OOZIE-1955
> Project: Oozie
> Issue Type: Bug
> Affects Versions: 4.0.0
> Environment: Hive .12,Oozie 4.0
> Reporter: Anuroopa George
> Fix For: 4.0.0
>
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
