[jira] [Commented] (OOZIE-1955) Unable to run hive scripts from Oozie shell action

["Gaurav Kumar (JIRA)" <ji...@apache.org>]

    [ 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)