Jesus Camacho Rodriguez created HIVE-17044:
----------------------------------------------
Summary: Transform LEFT/RIGHT OUTER into INNER join in the
presence of FK relationship
Key: HIVE-17044
URL: https://issues.apache.org/jira/browse/HIVE-17044
Project: Hive
Issue Type: Sub-task
Components: Logical Optimizer
Affects Versions: 3.0.0
Reporter: Jesus Camacho Rodriguez
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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
