You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@oozie.apache.org by Gary Clark <gc...@neces.com> on 2015/04/03 17:17:28 UTC
Hive Server 2 example?
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:gclark@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
RE: Hive Server 2 example?
Posted by Gary Clark <gc...@neces.com>.
My apologies I am using oozie 4.1.0... yes just need to know if it can work with hive server 2?
Thanks,
Gazza
-----Original Message-----
From: Gary Clark [mailto:gclark@neces.com]
Sent: Friday, April 03, 2015 10:17 AM
To: user@oozie.apache.org
Subject: Hive Server 2 example?
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:gclark@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