Using a left/right/full outer join
In this recipe, you will learn how to use left, right and full outer joins in Hive.
In Hive, left/right/full outer joins behave in the same manner as in relation to RDBMS. For a left outer join, all the rows from the table on the left are displayed and the matching rows from the right. All the unmatched rows from the table on the right will be dropped and Null will be displayed. A right outer join is just the reverse of a left outer join.
The left outer join is as follows:
Left join in Hive
A right outer join behaves the opposite to a left outer join. In this join, all the rows from the right table and the matching ...
Get Apache Hive Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
