Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.0.0
-
None
Description
Consider we are executing a LEFT OUTER join on two tables using their FK-UK/PK relationship. We might be able to transform the OUTER into an INNER join if the FK columns (OUTER relationship) are not nullable. Similarly for RIGHT OUTER join.
Attachments
Issue Links
- is part of
-
HIVE-17040 Join elimination in the presence of FK relationship
- Closed