Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB