Pig & Pig Latin

44 / 48

Note - Read about the JOIN operator here

Question-

File A has:

a11    a12
a21    a22

File B has:

a11    b12
b21    b22

These files are in HDFS and are located in /data/pig directory.

Question

If we run the below commands

A = load '/data/pig/A' as (f, s);
B = load '/data/pig/B' as (f, t);
C = join A by f, B by f;
dump C;

then the output will be

(a11,a12,a11,b12)