Thanks Serega, That helped. I was missing two things 1) Hcat jars where not present on shared path 2) hive-site.xml was not present with the workflow.xml
I fixed these two things and got it working. Thanks, Nitin On Wed, Oct 9, 2013 at 2:20 AM, Serega Sheypak <[email protected]>wrote: > No problem, hope it helps > > > > 2013/10/8 Nitin Pawar <[email protected]> > > > 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 > > > -- Nitin Pawar
