You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by "mike st. john" <ms...@gmail.com> on 2011/03/25 00:28:41 UTC

Anti-Joins

Are there any examples of Anti-Joins using Pig.


Thanks

Msj

Re: Anti-Joins

Posted by Alan Gates <ga...@yahoo-inc.com>.

A = load 'input1' as (x, y);
B = load 'input2' as (u, v);
C = cogroup A by x, B by u;
D = filter C by IsEmpty(B);
E = foreach D generate flatten(A);

Alan.

On Mar 24, 2011, at 4:28 PM, mike st. john wrote:

> Are there any examples of Anti-Joins using Pig.
>
>
> Thanks
>
> Msj