Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # dev >> Need help to resolve one error


Copy link to this message
-
Re: Need help to resolve one error
Hi Daniel

    thanks  for your reply.

Even after changing the PIG_CLASSPATH,it is giving me same error.
On Fri, Nov 22, 2013 at 5:19 AM, Daniel Dai <[EMAIL PROTECTED]> wrote:

> Can you try setup PIG_CLASSPATH before running Pig?
> export PIG_CLASSPATH=/home/hdmaster/Downloads/piggybank.jar
>
> Thanks,
> Daniel
>
>
> On Wed, Nov 20, 2013 at 10:50 PM, Haider <[EMAIL PROTECTED]> wrote:
>
> > Hi I am new to PIG scripting.
> >
> > I am trying to parse XML values through a pig script but getting the
> error.
> >
> > ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1070: Could not resolve
> > org.apache.pig.piggybank.storage.XMLLoader using imports: [,
> > org.apache.pig.builtin., org.apache.pig.impl.builtin.]
> >
> > my XML file is this
> >
> > <CATALOG>
> > <CD>
> > <TITLE>hadoop developer</TITLE>
> > <ARTIST>Haider</ARTIST>
> > <COUNTRY>india</COUNTRY>
> > <COMPANY>Deloitte</COMPANY>
> > <PRICE>10.90</PRICE>
> > <YEAR>2013</YEAR>
> > </CD>
> > </CATALOG>
> >
> > and my pig script is
> >
> > REGISTER '/home/hdmaster/Downloads/piggybank.jar';
> > A = LOAD '/home/hdmaster/Downloads/sample.xml' USING
> > org.apache.pig.piggybank.storage.XMLLoader('CD')
> >     AS (x:chararray);
> >
> > B = foreach A GENERATE FLATTEN(REGEX_EXTRACT_ALL(x,
> >
> >
> >
> '<CD>\\n\\s*<TITLE>(.*)</TITLE>\\n\\s*<ARTIST>(.*)</ARTIST>\\n\\s*<COUNTRY>(.*)</COUNTRY>\\n\\s*<COMPANY>(.*)</COMPANY>\\n\\s*<PRICE>(.*)</PRICE>\\n\\s*<YEAR>(.*)</YEAR>\\n\\s*</CD>'))
> >
> >     AS (title:chararray, artist:chararray, country:chararray,
> > company:chararray, price:double, year:int);
> >
> > store B into '/home/hdmaster/Downloads/results'
> >
> >
> > Any help on this highly helpful to me.
> >
> > Thanks
> > Haider
> >
>
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB