[
https://issues.apache.org/jira/browse/ASTERIXDB-3572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon resolved ASTERIXDB-3572.
----------------------------------
Resolution: Fixed
> Hash-join not used when join condition has other non-equality predicates
> ------------------------------------------------------------------------
>
> Key: ASTERIXDB-3572
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3572
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Labels: triaged
>
> Currently, when the join condition of a LEFT OUTER JOIN has non-equality
> predicates, nested loop join algorithm is chosen. However, a hash-join can be
> used when there is at least one equality predicate:
>
> {code:java}
> SELECT ds1, ds2
> FROM ds1 LEFT JOIN ds2 ON ds1.st > ds2.st AND ds1.st < ds2.et AND ds1.x =
> ds2.x;{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
