[
https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jin xing updated CALCITE-3373:
------------------------------
Description:
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 one is related to CALCITE-3367
was:
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 one is related to CALCITE-3373
> 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
> Priority: Major
>
> 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 one is related to CALCITE-3367
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
