Hadoop, Pig, and SQL (JOIN)

gistfile1.txt

SELECT * FROM mytable INNER JOIN othertable ON mytable.col1 = othertable.col1;

mytable = JOIN mytable BY col1, othertable BY col1;
DUMP mytable;
SELECT * FROM mytable LEFT OUTER JOIN othertable ON mytable.col1 = othertable.col1;

mytable = JOIN mytable BY col1 LEFT OUTER, othertable BY col1;
DUMP mytable;
SELECT * FROM mytable RIGHT OUTER JOIN othertable ON mytable.col1 = othertable.col1;

mytable = JOIN mytable BY col1 RIGHT OUTER, othertable BY col1;
DUMP mytable;
SELECT * FROM mytable FULL OUTER JOIN othertable ON mytable.col1 = othertable.col1;

mytable = JOIN mytable BY col1 FULL OUTER, othertable BY col1;
DUMP mytable;
SELECT * FROM mytable, othertable;

mytable = CROSS mytable, othertable;
DUMP mytable;