[jira] [Commented] (IMPALA-11074) Elimination of outer joins, if the predicates can restrict the result sets so that all null-supplying rows are eliminated

["Ling Miao (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-11074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17477618#comment-17477618 ] 

Ling Miao commented on IMPALA-11074:
------------------------------------

This is indeed a very effective optimization, looking forward to implementing it.

> Elimination of outer joins, if the predicates can restrict the result sets so that all null-supplying rows are eliminated
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: IMPALA-11074
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11074
>             Project: IMPALA
>          Issue Type: Improvement
>            Reporter: vinson0526
>            Priority: Major
>
> I found that impala do not have this feature yet when i develop this feature in Apache Doris.
> So i want to contribute this feature to impala in the meantime.
> Doris issue could be found in this [link|https://github.com/apache/incubator-doris/issues/7698]
> The key idea describe below:
> Elimination of outer joins, if the predicates can restrict the result sets s
> all null-supplying rows are eliminated
>  * full outer -> inner if both sides have such predicates
>  * left outer -> inner if the right side has such predicates
>  * right outer -> inner if the left side has such predicates
>  * full outer -> left outer if only the left side has such predicates
>  * full outer -> right outer if only the right side has such predicates



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org