How to do outer join on two columns in Pig Latin

Question

I do outer joins on single columns in Pig like this

result = JOIN A by id LEFT OUTER, B by id;

How do I join on two columns, something like -

WHERE A.id=B.id AND A.name=B.name

What is the pig equivalent? I couldn't find any example in the pig manuals...any help?

score 40 · Answer 1 · answered Aug 21 '12 at 07:42

40

The above answer is actually an INNER join, the correct pig statement should be:

 join a by (id, name) LEFT OUTER, b by (id, name)

answered Aug 21 '12 at 07:42

Samuel Kerrien

score 26 · Accepted Answer · edited Sep 02 '13 at 08:27

26

Answering the question myself -

join a by (id, name), b by (id, name)

edited Sep 02 '13 at 08:27

prongs

answered Dec 08 '11 at 20:04

hese

2 Answers2