You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Haisheng Yuan (Jira)" <ji...@apache.org> on 2019/09/25 20:47:00 UTC
[jira] [Created] (CALCITE-3372) Add a rule to transform a semijoin
into a join on top of aggregate
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)