[jira] [Commented] (OOZIE-2828) Query tag is not functional for Hive2 action node in oozie

["Xiaobin Zheng (JIRA)" <ji...@apache.org>]

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

Xiaobin Zheng commented on OOZIE-2828:
--------------------------------------

[~ssharma@hortonworks.com] I tried simple 'select * from xxx' hive query through hive2 action using <query> tag. The query ran successfully. Did you see any error in Oozie Server log or Hive2 server log?



> Query tag is not functional for Hive2 action node in oozie
> ----------------------------------------------------------
>
>                 Key: OOZIE-2828
>                 URL: https://issues.apache.org/jira/browse/OOZIE-2828
>             Project: Oozie
>          Issue Type: Bug
>          Components: action
>            Reporter: Supreeth Sharma
>            Priority: Critical
>
> 'query' tag is not functional for Hive2 action node in oozie.Workflow is intended to create a hive table using Hive2 action node. Though workflow run successfully, table is not created.
> Below is my workflow :
> {code}
> <?xml version="1.0" encoding="UTF-8" standalone="no"?><workflow-app xmlns="uri:oozie:workflow:0.5" name="Workflow5">
>     <start to="hive2_1"/>
>     <action name="hive2_1">
>         <hive2 xmlns="uri:oozie:hive2-action:0.2">
>             <job-tracker>${resourceManager}</job-tracker>
>             <name-node>${nameNode}</name-node>
>             <jdbc-url>jdbc:hive2://oozie-repro-2.openstacklocal:2181,oozie-repro-1.openstacklocal:2181,oozie-repro-3.openstacklocal:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2</jdbc-url>
>             <query>create table test(col1 int)</query>
>         </hive2>
>         <ok to="end"/>
>         <error to="kill"/>
>     </action>
>     <kill name="kill">
>         <message>${wf:errorMessage(wf:lastErrorNode())}</message>
>     </kill>
>     <end name="end"/>
> </workflow-app>
> {code}
> Same workflow I modified the Hive2 node to use  'script' tag and table got created successfully.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)