[
https://issues.apache.org/jira/browse/IGNITE-23970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-23970:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Extend usage of HashJoin
> -----------------------------
>
> Key: IGNITE-23970
> URL: https://issues.apache.org/jira/browse/IGNITE-23970
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> At the moment, we apply HashJoin only when all predicates involving fields of
> the tables are EQUALITY predicates, but in fact we can take an advantage of
> HashJoin even when some of the predicates are not EQUALITY predicate. Let's
> take a look at example below:
> {code:java}
> CREATE TABLE t1 (id INT PRIMARY KEY, val INT);
> CREATE TABLE t2 (id INT PRIMARY KEY, val INT);
> SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.val > t2.val;
> {code}
> We still can use HashJoin to join tables by ID columns with additional post
> filtration {{t1.val > t2.val}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
