Looks like fine. Now you need to provide log output of maptask (which executes hive action). You need to provide the whole log: stdin, stdout. You can easilly grab it from jobtracker UI. And the log of workflow execution. You can grab it from oozie console
I hope we should see something related to this: http://stackoverflow.com/questions/15749999/oozie-workflow-hive-table-not-found-but-it-does-exist 2013/10/8 Nitin Pawar <[email protected]> > Its the same one from oozie source code. > > <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> > <prepare> > <delete > path="${nameNode}/user/${wf:user()}/${examplesRoot}/output-data/hive"/> > <mkdir > path="${nameNode}/user/${wf:user()}/${examplesRoot}/output-data"/> > </prepare> > <configuration> > <property> > <name>mapred.job.queue.name</name> > <value>${queueName}</value> > </property> > </configuration> > <script>script.q</script> > > <param>INPUT=/user/${wf:user()}/${examplesRoot}/input-data/table</param> > > <param>OUTPUT=/user/oozie/${examplesRoot}/output-data/hive</param> > </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> > > > > On Tue, Oct 8, 2013 at 9:18 PM, Serega Sheypak <[email protected] > >wrote: > > > At first you in need to post workflow XML. > > 08.10.2013 18:44 пользователь "Nitin Pawar" <[email protected]> > > написал: > > > > > Hello, > > > > > > I have a working setup as oozie on my vm. (oozie can schedule jobs with > > > jobtacker). > > > I am using hive-action to run the examples query. > > > > > > After the job is over oozie, marks the status as killed and reason > being > > > external status for job is FAILED/KILLED. > > > Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [10001] > > > > > > I checked for the job log on jobtracker page, and the job finished > > > successfully and it has the status as successful. > > > > > > Am I missing something in setup or have I done something wrong? > > > > > > I followed following steps > > > 1) yum install oozie from big-top > > > 2) Configured oozie from the documentation > > > 3) Downloaded oozie source code 3.3.2 from apache > > > 4) Did build and got examples tar gz > > > 5) copied hive binaries to the shared lib folder on hdfs > > > 6) added shared lib path to hive job.properties > > > 7) modified the query in examples hive action and fired up a job, > > > 8) tracked the job on hadoop JT, status successful > > > 9) tracked job on oozie dashboard,status killed (hive action status: > > Error, > > > transition:fail, external status: killed/failed) > > > > > > Did I mess up anything? > > > > > > > > > -- > Nitin Pawar >
