[
https://issues.apache.org/jira/browse/ASTERIXDB-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944607#comment-17944607
]
ASF subversion and git services commented on ASTERIXDB-3573:
------------------------------------------------------------
Commit a08dd5bfce1bd82c49d2f1240e94484825de862c in asterixdb's branch
refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=a08dd5bfce ]
[ASTERIXDB-3573][COMP] Do not pull predicates out of join condition
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Avoid pulling predicates out of the (inner) join condition into
a separate select operator.
Ext-ref: MB-65642
Change-Id: I4343ef5246b9698c1ffb342dde43515db649b9fc
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19503
Tested-by: Ali Alsuliman <[email protected]>
Integration-Tests: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Reviewed-by: Peeyush Gupta <[email protected]>
> Do not pull predicates out of join condition
> --------------------------------------------
>
> Key: ASTERIXDB-3573
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3573
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Labels: triaged
>
> Avoid pulling predicates out of the (inner) join condition into a separate
> select operator.
> https://issues.apache.org/jira/browse/ASTERIXDB-3572 takes care of
> non-equality predicates and employs a hash-join as long as there is at least
> one equality predicate. With that being done, there is now no need to pull
> non-equality predicates out of the (inner) join condition. These predicates
> can still be present in the join condition together with the other equality
> predicates. This can reduce the cardinality of the join operator and improve
> performance.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
