Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> filter on a date column?

Copy link to this message
Re: filter on a date column?
Hi Tim,

Pig 0.11 has datetime type. You can do something like this:

a = LOAD 'input.txt' AS (date:datetime);
b = FILTER a BY date < ToDate('2013-01-01');

Also see built-in functions for datetime type:

On Thu, Mar 21, 2013 at 3:11 PM, Tim Chan <[EMAIL PROTECTED]> wrote:

> Since there is not date datatype, how do I filter on a date column?
> I've been setting the date column as a chararray.
> I would like to do something like:
> a = filter b by date_col < '2013-01-01';