Yes. I did that as well.
Thanks,
-Rakesh
From: te...@yahoo-inc.com
To: user@pig.apache.org; dvrya...@gmail.com; rkothari_...@hotmail.com
CC: pig-u...@hadoop.apache.org
Date: Wed, 27 Oct 2010 10:43:27 -0700
Subject: Re: Joins with OR condition
Message body
I don’t understand the solution
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
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 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 =
>
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
