Probably a bit late but I didn't see any replies to this so here it is A = LOAD 'A' as (name:chararray); B = LOAD 'B' as (name:chararray); C = COGROUP B BY name, A by name; D = FILTER C BY SIZE(A) == 0; E = FOREACH D GENERATE FLATTEN(B); dump E;
On 9/9/10 3:15 PM, "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