-Re: Date Function in Pig
Ruslan Al-Fakikh 2013-08-27, 11:45
I think the easiest way would be to use the piggybank converstion functions
for such tasks:
On Mon, Aug 26, 2013 at 7:43 PM, Serega Sheypak <[EMAIL PROTECTED]>wrote:
> You can use REGEX_EXTRACT with appropriate pattern and dummy ternary
> write dummy jython UDF using java/jython classes for Datetime conversion
> You can convert it to unix seconds using "native pig" and sort as integers:
> dataWithSeconds = FOREACH dataWithddMMMyyyy GENERATE
> ddMMMyyyy_field, 'ddMMMyyyy'),
> ToDate('1970-01-01 00:00:00', 'yyyy-MM-dd HH:mm:ss'))
> ) as seconds;
> ordered = ORDER dataWithSeconds by seconds;
> 2013/8/26 Ambastha, Abhishek <[EMAIL PROTECTED]>
> > Hi,
> > I have columns defined as string where dates are in the format ddMMMyyyy
> > (e.g. 01JAN2009). I would like to sort this column in ascending order.
> > that, I need to convert string into date in the format 'ddMMMyyyy'.
> > Please suggest how to do this.
> > Regards,
> > Abhishek