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

Posted to issues@calcite.apache.org by "yuqi (JIRA)" <ji...@apache.org> on 2019/02/27 13:18:00 UTC

[jira] [Created] (CALCITE-2879) Improve filter condition in Join

yuqi created CALCITE-2879:
-----------------------------

             Summary: Improve filter condition in Join
                 Key: CALCITE-2879
                 URL: https://issues.apache.org/jira/browse/CALCITE-2879
             Project: Calcite
          Issue Type: Improvement
            Reporter: yuqi


Currently, filter condition in join have not been optimized very well, let's take a simple example


{code:sql}
select a.id, b.name from Ta a inner join Tb b on a.id = b.id and a.id < 5;

{code}

now, only a.id < 5 can push down, however, as for the sql above,  
we can infer a.id < 5 and b.id < 5 and both of them can push down. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)