You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "jin xing (Jira)" <ji...@apache.org> on 2019/09/26 03:00:00 UTC

[jira] [Created] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

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)