C = JOIN A by name LEFT OUTER, B by name; D = FILTER C by B::name is null; On Thu, Sep 9, 2010 at 2:45 AM, Ramana Venkata <ram...@ohana-media.com>wrote:
> hi, > I have Two files, loaded as Two relations A and B as fallows > > File1.txt > -------------- > ramana > krishna > siva > venkat > > File2.txt > --------------- > krishna > venkat > kishore > basha > > these two files are loaded into two relations A and B > and then > the output should be like the difference of the two i.e B - A > that means the extra added added users in B without A > > output > --------------------- > kishore > basha > > > how we can write the pig script for this operation >