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:[email protected]] Sent: Friday, April 03, 2015 10:17 AM To: [email protected] 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:[email protected]] Sent: Thursday, April 02, 2015 5:20 PM To: [email protected] 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
