Hello Garry, Oozie first launches a ³launcher² job which then launches the actual Pig/Hive job. The ŒSUCCEEDED¹ job that you see on Yarn is this launcher job, which succeeded in its job of launching the actual pig job, but actual pig job failed. Oozie console will show child jobs under tab ŒChild Jobs¹ pointing to the child jobs that the launcher spawned, so you can go there directly.
What is your error exactly? If it says Œhive-site.xml Permission Denied¹, I¹ve encountered that error before and for some reason it was because the hive-site.xml unix permissions were changed from 600 (rw-r--r--). This is the hive-site.xml that you are including in your oozie workflow application directory. I don¹t know the root cause of it yet but if you keep the permissions as 600 it should work. If it¹s not the above error, could you elaborate on it, and copy the stack trace here? Hive updated versions have indeed changed the package hierarchy for HCatLoader and HCatStorer so the changes you made here are correct. You will find an example (examples/apps/hcatalog) in the examples folder in Oozie and includes a README. I have created JIRA (https://issues.apache.org/jira/browse/OOZIE-1881) to append the above info as an FAQ to the HCatalog integration doc as well as a walkthrough of this Pig+HCat example. Regards, ‹ Mona On 6/15/14, 2:47 PM, "Garry Turkington" <g.turking...@improvedigital.com> wrote: >Hi, > > > >Digging into this some more I have a little more information about the >problem. > > > >The simple Pig script is as below, i.e.: > > > >REGISTER >/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/pig/piggybank.jar > > > >mydata = LOAD 'testtable_hcat' USING >org.apache.hive.hcatalog.pig.HCatLoader(); > >This fails with the following message in the Oozie CLI and UI: > >0000003-140615021945919-oozie-oozi-W@pig-node > ERROR job_1402823993415_0004 FAILED/KILLEDJA018 > > > >Though that particular MR job id is marked as successful in the MR and >YARN logs. Which is I think why it's proving difficult to find any more >logging. > > > >What does work: > >* Hive actions within Oozie > >* Other Pig actions (that don't use HCatalog) within Oozie > >* This Pig script run from the CLI as either the submitting or yarn user > > > >I did change 2 things; the package name for the HCATLoader as the >org.apache.hcatalog.* is now deprecated in favour of >org.apache.hive.hcatalog.* and the /user/yarn directory was not present. >But neither made an impact. > > > >I think the JA018 -- referred to as being due to the output dir already >existing in oozie-defaults.xml is actually referring to something else. >Possibly a missing library. > > > >To run the script from the command line I add the -useHCatalog argument >to Pig which explicitly adds jars to the classpath. Though many of these >would be for the hcat binary etc which I'm not using. The HCatalog >adaptor for Pig though does appear to be in the Oozie sharelib: > > > >[cloudera@localhost ~]$ oozie admin -shareliblist hcatalog | grep -i pig > > >hdfs://localhost.localdomain:8020/user/oozie/share/lib/lib_20140404112820/ >hcatalog/hive-hcatalog-pig-adapter-0.12.0-cdh5.0.0.jar > > > >Any insight in any of the above from anyone? The fact I can't find any >examples of this Oozie/Pig/Hcat combo working isn't filling me with >confidence. > > > >One thing that would help -- if Pig is dropping an error log file is >there any way of capturing that/making it available? I tried doing the >equivalent of a "pig -l > <destination>" in the workflow.xml but that >didn't seem to work either. > > > >Or any thoughts on when things would be failing in such a way that the >MapReduce job is logged as successful but Oozie sees the action as >failed/killed? > > > >Any pointers well received, > >Garry > > > > > >-----Original Message----- >From: Garry Turkington [mailto:g.turking...@improvedigital.com] >Sent: 11 June 2014 00:11 >To: user@oozie.apache.org >Subject: RE: Using HCat within a Pig action > > > >Mona, > > > >Thanks for the response. > > > >That doesn't quite look like my problem though; my Hive Oozie actions are >working fine. As are my Pig Oozie actions, but things start breaking when >trying to use HCat from within the Pig action. > > > >Are there any additional arguments required -- or configuration options >-- for a Pig job using HCat? Or any working examples anywhere? > > > >Thanks > >Garry > > > >-----Original Message----- > >From: Mona Chitnis [mailto:chit...@yahoo-inc.com.INVALID] > >Sent: 09 June 2014 19:20 > >To: user@oozie.apache.org<mailto:user@oozie.apache.org> > >Subject: Re: Using HCat within a Pig action > > > >Looks like some discussion on this problem already >https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/m8NnJvzxGA >Q > > > >On 6/9/14, 6:00 AM, "Garry Turkington" ><g.turking...@improvedigital.com<mailto:g.turking...@improvedigital.com>> > >wrote: > > > >>Hi, > >> > >>I've got some Pig scripts that access data via HCat. They run fine on > >>the command line but if I try to get some executed as part of an Oozie > >>action it is failing. Unfortunately with very little detailed error >>messages. > >> > >>So before I go into the specifics can I clarify what is needed to get > >>Pig/HCat integration working with Oozie? > >> > >>I'm running this on CDH5 and the output of "oozie admin -listsharelib" > >>includes Pig and Hcatalog. Within my Pig scripts I am referring to HCat > >>tables by name alone, i.e. no hcat:// URI. The hive-site.xml that > >>works for Hive actions is available. I have other non-HCat workflows > >>running fine, including Pig and Hive actions. > >> > >>When I run Pig scripts that use HCatalog from the CLI I need specify > >>-useHcatalog and have HCAT.BIN defined; should I be passing values for > >>these to the Pig script within <argument> elements in the action > >>definition? (I've tried both with and without). > >> > >>Anything else that is required for this to work? Or pointers to any > >>documentation with examples/specs for what's needed? I found different > >>parts of the picture spread around but no definitive spec or full > >>examples. > >> > >>I cut my script down to the following; note the commented out second > >>statement, we don't even get as far as trying to read the (existing and > >>containing data) table: > >> > >>REGISTER > >>/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/pig/piggybank.jar > >> > >>mydata = LOAD 'testtable_hcat' USING > >>org.apache.hcatalog.pig.HCatLoader(); > >>-- store mydata into '/tmp/zz.out' using PigStorage(); > >> > >>I commented out the store because the only error I get includes the > >>seeming code JA018 and it was suggested on the Google this may be > >>permission related. Anything I need consider here? The cluster isn't > >>using any external security provider and only basic authentication: > >> > >>job_1402172905909_0054 FAILED/KILLEDJA018 > >> > >>Here's the workflow.xml: > >><workflow-app xmlns="uri:oozie:workflow:0.4" name="shell-wf"> > >> <start to="pig-node"/> > >> <action name="pig-node"> > >><pig> > >> <job-tracker>${jobTracker}</job-tracker> > >> <name-node>${nameNode}</name-node> > >> <job-xml>${workflowRoot}/hive-site.xml</job-xml> > >> <configuration> > >> <property> > >> <name>mapred.job.queue.name</name> > >> <value>${queueName}</value> > >> </property> > >> </configuration> > >> <script>${workflowRoot}/pig/simple.pig</script> > >> </pig> > >> <ok to="end"/> > >> <error to="fail"/> > >></action> > >> > >> <kill name="fail"> > >> <message>Pig action failed, error > >>message[${wf:errorMessage(wf:lastErrorNode())}]</message> > >> </kill> > >> <end name="end"/> > >></workflow-app> > >> > >>Thanks > >>Garry > >> > >> > > > > > >----- > >No virus found in this message. > >Checked by AVG - www.avg.com<http://www.avg.com> > >Version: 2014.0.4570 / Virus Database: 3955/7637 - Release Date: 06/07/14 > > > >----- > >No virus found in this message. > >Checked by AVG - www.avg.com<http://www.avg.com> > >Version: 2014.0.4570 / Virus Database: 3955/7637 - Release Date: 06/07/14
