[
https://issues.apache.org/jira/browse/FLINK-28366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17562175#comment-17562175
]
Jeya Prakash Thanigaivel commented on FLINK-28366:
--------------------------------------------------
Hi [~martijnvisser], Yes I want to run flink on bounded mysql database using
Table API connector.
Lets consider :
I have two tables TABLE_A and TABLE_B.
I need to join both tables and get the records whose id column matches.
But currently flink selects all the records from both table and perform joins
in-memory. But I want to push this join to underlying SQL Engine. Is this
possible ?
> Support for custom query for JDBC Table API source connector
> ------------------------------------------------------------
>
> Key: FLINK-28366
> URL: https://issues.apache.org/jira/browse/FLINK-28366
> Project: Flink
> Issue Type: Improvement
> Components: Connectors / JDBC
> Affects Versions: 1.15.0
> Reporter: Jeya Prakash Thanigaivel
> Priority: Major
>
> Support for custom query for JDBC Table API source connector.
> Eg : Select a,b from TABLE_A a, TABLE_B b where a.id=b.id and a.id > 1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)