Heya! I've been trying to do something with Pig for about 4 days now and I have nothing but failure to show for it. I was wondering if anybody could look at my queries and slap some sense into me? I've uploaded the queries to pastebin: http://pastebin.com/kzMxYwrY
In short, I want to take my data, group it by 4 fields, then for each group, I want to: - Find out the 5th and the 95th percentile for the 'price' - Filter each group to remove the records that are < 5th percentile and > 95 percentile. Then for each group, I want to grab the AVG() of what's left. I tried many variations of the same code and always ended up with either "incompatible types in GreaterThanEqual Operator" or "Scalar has more than one row in the output." Any help would be greatly appreciated. Thanks! :) -- Pierre-Luc Brunet
