Let me illustrate why outer join does not work for me.
pig:
A = LOAD '$in1' USING PigStorage(',') AS (a:chararray, b:chararray,
c:chararray);
B = LOAD '$in2' USING PigStorage(',') AS (a:chararray, b:chararray,
c:chararray);
C = JOIN A BY (a,b), B BY (a,b);
CProj = FOREACH C GENERATE A::a, A::b, A:
Why not use Outer Join instead?https://overview.mail.yahoo.com?.src=iOS";>Sent from Yahoo Mail
for iPhone
Hi folks,
While performing Inner Join, the rows containing the null field in the join
predicate are dropped. Sometimes, it is required that the rows containing
join predicate as null are not dropped from the output, while performing
inner join.
Is there any way how this can be achieved?
A possi