...
This document is based on a writeup of DB2 Outer Join Behavior. The original HTML document is attached to the Hive Design Docs and can be downloaded here.
Definitions
Preserved Row table | The table in an Outer Join that must return all rows. |
Null Supplying table | This is the table that has nulls filled in for its columns in unmatched rows. |
During Join predicate | A predicate that is in the JOIN ON clause. |
After Join predicate | A predicate that is in the WHERE clause. |
...