A = LOAD 'data/a.txt'; B = LOAD 'data/b.txt'; C = LOAD 'data/c.txt'; D = UNION B,C; E = GROUP A BY $0, D BY $0; F = FILTER E BY IsEmpty($2);
On Wed, Jun 16, 2010 at 12:13 AM, Syed Wasti <[email protected]> wrote: > Hi, > I need a suggestion on how I can write this query in pig. I have 3 tables, > some records of table A may be present in table B and some of A in table C. > I want to write a query where I will pick the only records of A which are > not present in B and C. Thanks. > > > Regards > Syed Wasti > -- Best Regards Jeff Zhang
