You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2024/06/27 12:32:00 UTC

[jira] [Resolved] (ASTERIXDB-3445) Hash join picked by CBO in the presence of non-equality join predicates.

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

Vijay Sarathy resolved ASTERIXDB-3445.
--------------------------------------
    Resolution: Fixed

> Hash join picked by CBO in the presence of non-equality join predicates.
> ------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-3445
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3445
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Vijay Sarathy
>            Assignee: Vijay Sarathy
>            Priority: Major
>
> When we have multiple join predicates with a mix of equality and non-equality predicates, CBO picks a hash join as an applicable join method with the incorrect assumption that the physical optimizer will use only the equality predicate as the hash join predicate and apply the non-equality predicate as a post join filter. However, currently, the physical optimizer does have this capability, and until this enhancement is added, CBO should not pick hash join as an applicable join method when there is a non-equality predicate even though there are other equality join predicates. A hash join should only be considered if all the join predicates are equality predicates.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)