[ 
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)

Reply via email to