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)