Hive Server 2 example?

[Gary Clark]

Hello,

Does anyone out there have a simple example on how to connect to Hive Server 2 
in oozie 4.0.1?

Much Appreciated,
Gazza

-----Original Message-----
From: Gary Clark [mailto:gcl...@neces.com] 
Sent: Thursday, April 02, 2015 5:20 PM
To: user@oozie.apache.org
Subject: Oozie Hive job stalling but running indefinetly

Hello,

I am trying to run the oozie hive example hive:

My script.q is:

CREATE EXTERNAL TABLE test (a INT) STORED AS TEXTFILE LOCATION 
'/user/oozie/examples/input-data/table';
INSERT OVERWRITE DIRECTORY '/user/oozie/examples/output-data/hive' SELECT * 
FROM test;

My worlflow is:

<workflow-app xmlns="uri:oozie:workflow:0.2" name="hive-wf">
    <start to="hive-node"/>

    <action name="hive-node">
        <hive xmlns="uri:oozie:hive-action:0.2">
            <job-tracker>${jobTracker}</job-tracker>
            <name-node>${nameNode}</name-node>
            <configuration>
                <property>
                    <name>mapred.job.queue.name</name>
                    <value>${queueName}</value>
                </property>
            </configuration>
            <script>script.q</script>
        </hive>
        <ok to="end"/>
        <error to="fail"/>
    </action>

    <kill name="fail">
        <message>Hive failed, error 
message[${wf:errorMessage(wf:lastErrorNode())}]</message>
    </kill>
    <end name="end"/>
</workflow-app>

Note no parameters. I also make sure the metadata "test" is removed prior to  
running the job:

./oozie job -oozie http://localhost:11000/oozie/ -config 
../examples/apps/hive/job.properties  -run
job: 0000008-150402145213454-oozie-oozi-W


Its looks like the hive job is running forever. Very strange. When  I perform 
the above hql query in hive it can create the table with the correct contents.

Any ideas on what could do this. I am running with Hadoop 2.6.0 and Oozie 
4.1.0. The map-reduce example works, but I would like to get the hive example 
to work.

Thanks,
Gazza