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

Hi Jamal,

you can write a UDF convert time between different time zones with
following utilities,

java.text.DateFormat;
java.text.SimpleDateFormat;
java.util.Date;
java.util.TimeZone;

Thanks,
TianYi

On Thu, Oct 4, 2012 at 12:53 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
>

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

Hi,
  I have data of format

id1,id2, value
1 , abc, 2993
1, dhu, 9284
1,dus,2389
2, acs,29392

and so on

For each id1, I want to find the maximum value and then divide value by
max_value
so in example above:

1,abc, 2993/9284
1,dhu ,9284/9284
1,dus, 2389/9284
2,acs, 29392/max_value_for_this id

How do i do this in pig?
Thanks