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

Switch to Threaded View
Pig >> mail # user >> Finding records greater than a value


Copy link to this message
-
Finding records greater than a value
Hi
 I have two files..
File 1 contains following data.
Id, amount
1234, 22.7
1158,88
1234,  280

File 2 contains following data
Id, min, max
1234, 8, 150

Now I want to calculate the mean (avg) but without considering the values
less or greater than min and max respectively

So basically in mean calculation here
I don't want 1234, 280 as 280 > 150

Any suggestions