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

Switch to Threaded View
Pig >> mail # user >> Pig question.

Copy link to this message
Re: Pig question.
0) convert dates to ISO format via CustomFormatToISO
1) convert dates to unix time longs via ISOToUnix
2) use foreach/generate with ternary operator to add/subtract hours
based on the value of the other field
3) convert dates back to ISO format with UnixToISO

Call it a day.

Russell Jurney twitter.com/rjurney
On Oct 3, 2012, at 10:54 AM, jamal sasha <[EMAIL PROTECTED]> wrote:

> Hi,
>  I have a table in format:
> Id: int, amount: float, true_date: chararray, time:chararray,
> state:chararray
> Fortunately, there are only two states in my db.
> So if I have a state as “CA” then add +1 to datetime
> If state is  “MA”, then add +5 to datetime
> And then save the results.
> Also a corner case..
> While adding.. If due to addition the date changes.. then I have to add +1
> to true_date as well..
> Any ideas