FAQ
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" 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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
groupuser @
categoriespig, hadoop
postedSep 9, '10 at 4:21p
activeSep 13, '10 at 5:51a
posts3
users3
websitepig.apache.org

People

Translate

site design / logo © 2022 Grokbase