It worked! thanks a lot. I guess the example given in : org.apache.pig.piggybank.evaluation.datetime.convert.CustomFormatToISO.java should be rectified to avoid confusions in future. Thanks, Ips
On Mon, Sep 12, 2011 at 11:17 PM, Jonathan Coveney <[email protected]> wrote: > > try single quotes 'YYYYMMdd' instead of double quotes > > 2011/9/12 ipshita chatterji <[email protected]> > > > the problem is all my date entries are in YYYYMMdd format! > > > > On Mon, Sep 12, 2011 at 2:47 PM, Marian Condurache < > > [email protected]> wrote: > > > > > Try: > > > > > > REGISTER /[YOUR_USER]/pig/contrib/piggybank/java/piggybank.jar ; > > > REGISTER /[YOUR_USER]/pig/contrib/piggybank/java/lib/joda-time-1.6.jar; > > > > > > DEFINE UnixToISO > > > org.apache.pig.piggybank.evaluation.datetime.convert.UnixToISO(); > > > > > > > > > Kind Regards,Marian > > > > > > -----Ursprüngliche Nachricht----- > > > Von: ipshita chatterji [mailto:[email protected]] > > > Gesendet: Montag, 12. September 2011 11:13 > > > An: [email protected] > > > Betreff: CustomFormatToISO > > > > > > Hi, > > > I get an error on executing following: > > > > > > register piggybank.jar; > > > register joda-time-1.6.jar ; > > > > > > A= LOAD 'date.csv' USING PigStorage(',') AS (a1:chararray); > > > dump A; > > > Output : (20110123) > > > toISOA = FOREACH A GENERATE > > > > > > > > org.apache.pig.piggybank.evaluation.datetime.convert.CustomFormatToISO(a1,"YYYYMMdd") > > > AS ISOTime:chararray; > > > > > > The error: > > > 2011-09-11 22:36:51,782 [main] ERROR org.apache.pig.tools.grunt.Grunt - > > > ERROR 1000: Error during parsing. Lexical error at line 1, column 104. > > > Encountered: "Y" (89), after : "\"" > > > > > > > > > Why is this happening? What am I doing wrong here? > > > > > > Thanks, > > > Ipshita > > > > >
