[jira] [Commented] (OOZIE-2773) property not working with hive2 action

["Jan Hentschel (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OOZIE-2773?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15822426#comment-15822426 ] 

Jan Hentschel commented on OOZIE-2773:
--------------------------------------

What do you try to accomplish by using the *file* tag? You normally use it to [pass a password file|https://community.hortonworks.com/articles/3251/running-hive-in-oozie-with-hive2action-and-passwor.html] to Beeline. Your Hive query file is linked via the *script* tag. There is no need to reference the Hive file again via the *file* tag. Most of the paths in Oozie are relative to the application path of the workflow. If the file is in another location in HDFS you have to use the full path.

> <file> property not working with hive2 action
> ---------------------------------------------
>
>                 Key: OOZIE-2773
>                 URL: https://issues.apache.org/jira/browse/OOZIE-2773
>             Project: Oozie
>          Issue Type: Bug
>          Components: action
>    Affects Versions: 4.2.0, 4.3.0
>         Environment: HDP 2.4, Beeline version 1.2.1000.2.4.0.0-169
>            Reporter: Christoph Körner
>
> The beeline client does not consider files linked with the <file> property in Hive 2 actions. The file gets successfully linked to the local appcache directory, however Oozie tries to access the file from the workflow path.
> A simple job
> {code:borderStyle=solid}
> <action name="test-action">
>   <hive2 xmlns="uri:oozie:hive2-action:0.1">
>     <jdbc-url>${jdbcURL}</jdbc-url>
>     <script>query.hive</script>
>     <file>hive/query.hive#query.hive</file>
>   </hive2>
>   <ok to="end"/>
>   <error to="fail"/>
> </action>
> {code}
> fails with the error message:
> {code:borderStyle=solid}
> JA008: File does not exist: /user/koernerc/apps/simple-hive-query-wf/query.hive#query.hive
> {code}
> The complete workflow is also available on Github https://github.com/chaosmail/oozie-bugs/tree/master/simple-hive-query/simple-hive-query-wf.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)