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