You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2021/02/16 04:16:01 UTC
[jira] [Created] (CALCITE-4499) FilterJoinRule misses opportunity
to push filter to semijoin input
Jesus Camacho Rodriguez created CALCITE-4499:
------------------------------------------------
Summary: FilterJoinRule misses opportunity to push filter to semijoin input
Key: CALCITE-4499
URL: https://issues.apache.org/jira/browse/CALCITE-4499
Project: Calcite
Issue Type: Improvement
Components: core
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Consider the following plan:
{code}
LogicalProject(DNAME=[$1])
LogicalJoin(condition=[AND(=($0, $10), =($8, 100))], joinType=[semi])
LogicalTableScan(table=[[scott, DEPT]])
LogicalTableScan(table=[[scott, EMP]])
{code}
The second conjunct only refers to columns from the right input, thus it could be pushed to the right input. However, {{FilterJoinRule}} misses this opportunity.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)