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
pig question
jamal sasha 2013-04-27, 09:32
  I have data of format

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

and so on

For each id1, I want to find the maximum value and then divide value by
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?