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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Cannot Reproduce
• Component/s: action
• Assignee: Unassigned
• Reporter: Supreeth Sharma
• Created: 17/Mar/17 09:36
• Updated: 28/May/19 13:10
• Resolved: 28/May/19 13:10

Description

'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 :

<?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>

Same workflow I modified the Hive2 node to use 'script' tag and table got created successfully.