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

Posted to dev@flink.apache.org by "ranqiqiang (Jira)" <ji...@apache.org> on 2021/09/26 10:33:00 UTC

[jira] [Created] (FLINK-24378) Dim table join operator Push down

ranqiqiang created FLINK-24378:
----------------------------------

             Summary: Dim table join operator Push down
                 Key: FLINK-24378
                 URL: https://issues.apache.org/jira/browse/FLINK-24378
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / JDBC
            Reporter: ranqiqiang


hello:

        If binlog source table-A data is :  \{id : 1 , name:'king'  }

        and mysql  dim table-B data is  \{id : 1, type : 1} ,\{id:1 , type : 2}

  

 I used sql :
{code:java}
//代码占位符
select * from table-A a
left join table-B .. as b
on a.id = b.id  and b.type = 2

{code}
I want to know the  "{color:#de350b}b.type = 2" {color:#172b4d}could be push down,maybe is helpful . unless get all data to filter . {color}{color}

 

{color:#de350b}{color:#172b4d}If the filters follow with  on, push then  operators down , will be better agile！{color}{color}

{color:#de350b}{color:#172b4d}Do you think so ?{color}{color}

 

 

 

 

 



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