[ 
https://issues.apache.org/jira/browse/HIVE-20950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Steve Carlin resolved HIVE-20950.
---------------------------------
    Release Note: 
In the case where the outer join side has zero rows, the inner join would 
contain zero rows whereas the outer join would contain the left side rows.

Since they are not equivalent, we cannot transform this.
      Resolution: Invalid

> Transform OUTER join with condition always true into INNER join
> ---------------------------------------------------------------
>
>                 Key: HIVE-20950
>                 URL: https://issues.apache.org/jira/browse/HIVE-20950
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Steve Carlin
>            Priority: Major
>
> For instance, it may help the join reordering algorithm.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to