A is (val:int) B is (thing:chararray, min:int, max:int) Basically what I want is C = (val, thing) where val is between min and max for that thing. In sql the syntax for this would not be hard, in pig the naive solution I have is..
cro = CROSS A,B; fil = FILTER cro BY val >= min AND val <= max; C = FOREACH fil GENERATE val,thing; I am wondering what the most efficient way of doing this sort of operation is. I imagine with some sort of indexing you could ideally speed things up? Not sure. But this is important enough that I'd be willing to do some legwork. As always, thanks for your help.
