jin xing created CALCITE-3373:
---------------------------------
Summary: Decorrelate boolean context IN or existential subquery
directly into SEMI/ANTI join
Key: CALCITE-3373
URL: https://issues.apache.org/jira/browse/CALCITE-3373
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: jin xing
The current approach to generate semi-join from IN/EXISTS is as below:
# Decorrelation
# Transforming by SemiJoinRule to get a semi-join
A more straightforward approach is to generate the semi-join right in
Decorrelation.
What's more, we should also have an approach to generate anti-join right in
Decorrelation.(Currently there's no analogous rule to SemiJoinRule for
anti-join)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
