[jira] [Created] (CALCITE-3372) Add a rule to transform a semijoin into a join on top of aggregate

[Haisheng Yuan (Jira)]

Haisheng Yuan created CALCITE-3372:
--------------------------------------

             Summary: Add a rule to transform a semijoin into a join on top of 
aggregate
                 Key: CALCITE-3372
                 URL: https://issues.apache.org/jira/browse/CALCITE-3372
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Haisheng Yuan


{code:java}
Semijoin
     |- TS1
     +- TS2
{code}
can be transformed into
{code:java}
Project
  +-InnerJoin
          |- TS1
          +- Aggregate
                    + TS2
{code}

We may benefit from the new plan by join relation reordering if TS2 is large 
even after aggregation.





--
This message was sent by Atlassian Jira
(v8.3.4#803005)