This is more of a "how can I do this" question.
Imagine you have an sql query like the following:
select a.f1, a.f2, a.f3, b.f1, b.f2, c.f1, c.f2, d.f1, d.f2
from tableA a, tableB b, tableC c, tableD d
where
a.f1 = b.f1
and b.f2 = d.f1
and c.f2 = b.f1
/* etc.... */
What's the best way to replicate that query in Pig?
It's obvious to me that a simple thing could be done with a simple join.
That is, if you just had
where a.f1 = b.f1
You can just JOIN and then foreach generate.
But with more than one clause in the where, I'm not sure of a good approach...
-Mark