I don't understand the solution proposed by Dmitriy using 3 joins. But it can be done using two joins and a union, as follows -
J1 = join A by prop1, B by prop1; J2 = join A by prop2, B by prop2; -- this filters prevents joined rows where both prop1, prop2 match from being counted twice J2_fil = filter J2 by A::prop1 != A::prop2; JoinP1OrP2 = union J1, J2; -Thejas On 10/17/10 8:18 PM, "Dmitriy Ryaboy" <dvrya...@gmail.com> wrote: Two joins, followed by a full outer join of the results, and a selection pass? It's not pretty, but it'll work... On Sun, Oct 17, 2010 at 5:03 PM, rakesh kothari <rkothari_...@hotmail.com>wrote: > > What's the best way to do something like this in PIG: > > JOIN A with B where (A.property1 = B.property1 OR A.property2 = > B.property2) ? > > Thanks, > -Rakesh > > >
