[
https://issues.apache.org/jira/browse/FLINK-23687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17462956#comment-17462956
]
Jing Zhang edited comment on FLINK-23687 at 12/21/21, 3:16 AM:
---------------------------------------------------------------
Hi, [~HunterHunter] Thanks for attention.
Since look up join is commonly used, there are many optimization requirements
on this topic. Such as:
1. Enable partitioned join to raise cache hint ratio.
2. Solve the data skew case in the first point
3. Enable miniBatch optimization to reduce RPC call.
We have finished the those points in the internal version already and validate
them in production jobs.
We are planning to push all of the optimization to the community.
Currently, we have discussed this topic.
Including hear requirements from more users, designing SQL syntax, API update
and implement update.
Maybe would create a FLIP after we have achieved same goals and send a discuss
in user and dev mail list.
Welcome to join the discuss.
was (Author: qingru zhang):
Hi, [~HunterHunter] Thanks for attention.
> Add Sql query hint to enable LookupJoin shuffle by join key of left input
> -------------------------------------------------------------------------
>
> Key: FLINK-23687
> URL: https://issues.apache.org/jira/browse/FLINK-23687
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / Planner
> Reporter: Jing Zhang
> Assignee: Jing Zhang
> Priority: Major
>
> Add Sql query hint to enable LookupJoin shuffle by join key of left input
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
