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 >
