As far as you can see, the rule doesn't currently support non-equal
join.
While you execute a SQL with non-equal join conditions, the rule can
only handle the equal join generated by JoinExtractFilterRule[1]. So
AFAIK you are not able to receive performance benefits by this rule so
far unless you have sorted join input already.
Best,
Hongze
[1]
https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/rel/rules/JoinExtractFilterRule.java
------ Original Message ------
From: "周来" <[email protected]>
To: [email protected]
Sent: 2019/4/1 11:26:48
Subject: Is sort-merge join rule supports a non-equi join?
I want to fire a sort-merge join rule to improve the performance for a
theta join,
but I found the comment of EnumerableMergeJoinRule.java says
`// EnumerableMergeJoin only supports inner join.
(It supports non-equi join, using a post-filter; see below.)`.
could someone tell me how to fire the rule for a non-equi join?
