[
https://issues.apache.org/jira/browse/FLINK-24378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ranqiqiang updated FLINK-24378:
-------------------------------
Description:
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}
If the filters follow with on, push then operators down , will be better
agile！
Do you think so ?
was:
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}
If the filters follow with on, push then operators down , will be better
agile！
Do you think so ?
> 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
> Priority: Minor
>
> 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}
>
> If the filters follow with on, push then operators down , will be better
> agile！
> Do you think so ?
>
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
