Re: Inner join on null keys

2014-09-14 Thread deepak marathe
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:

RE: Inner join on null keys

2014-09-12 Thread Mona Chitnis
Why not use Outer Join instead?https://overview.mail.yahoo.com?.src=iOS";>Sent from Yahoo Mail for iPhone

Inner join on null keys

2014-09-12 Thread deepak marathe
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