Joining in Apache Pig is identical to joining in SQL, in that it is used to combine tuples (rows) from two or more relations (tables)
Tag: Joining relations in Apache Pig
Self Join in Apache Pig
Although Apache Pig shares some similarities with SQL, it differs in functionality and behavior. Most SQL features, including as sorting, grouping, and joining, may be
Joining “relations” in Apache Pig
Joining in Apache Pig is identical to joining in SQL, in that it is used to combine tuples (rows) from two or more relations (tables)
Big Data & SQL 