Pig & Pig Latin

47 / 48
   

Note - Read about the JOIN operator here

Question-

File A has:

a11, a12
a21, a22

File B has:

a11, b12
b21, b22

Question

If we run the below commands

A = load 'A' as (f, s);
B = load 'B' as (f, t);
F = join A by f FULL, B by f;
dump F;

then the output will be

(a11,a12,a11,b12)
(a21,a22,,)
(,,b21,b22)