Hey all, I have several relations that all have the same keys. Something like:
A = id,countA B = id,countB C = id,countC ... I would like to do a multi-way, full outer join such that any tuple that is null or non-existent is still joined. The approach right now is to do it step wise, as the Pig documentation suggests that it's not possible to do an all-at-once multi-way outer join. joinA = JOIN A BY id FULL OUTER, B BY id; joinB = JOIN joinA BY id FULL OUTER, C BY id; ... Is there a better way to approach this in Pig? Ideally one could simply do: join = JOIN A BY id FULL OUTER, B BY id, C BY id, ...; Cheers, Josh
