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 > > >
