You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2019/09/30 23:06:00 UTC

[jira] [Resolved] (HIVE-20950) Transform OUTER join with condition always true into INNER join

     [ 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)