I would try to do thing mentioned on that thread. I do have hive-site.xml on the path but not on workflow.xml
I will give that a try. Thanks a bunch Serega. Thanks, Nitin On Wed, Oct 9, 2013 at 12:13 AM, Serega Sheypak <[email protected]>wrote: > 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 > > > -- Nitin Pawar
