Hi Xuyang, Thanks for starting this discussion. Join Hint is a long-time requested feature. I have briefly gone through the design doc. Join Hint is a public API for SQL syntax. It should work for both streaming and batch SQL. I understand some special hints may only work for batch SQL. Could you demonstrate how the hints affect stream SQL as well?
Besides that, could you move your design docs into the wiki? Google docs are usually used for offline discussion. The discussion on google docs is not very visible to the community. So we would like to move designs to the wiki and move discussions to the mailing list. Best, Jark On Fri, 6 May 2022 at 11:07, Xuyang <xyzhong...@163.com> wrote: > Hi, all. > I want to start a discussion about the FLIP-229: Introduces Join Hint > for Flink SQL Batch Job(The cwiki[1] is not ready completely but you can > see the whole details in docs[2]). > Join Hint is a common solution in many popular computing engines and DBs > to improve the shortcomings of the optimizer by intervening in optimizing > the plan. By Join Hint, users can intervene in the selection of the join > strategy in optimizer, and manually optimize the execution plan to improve > the performance of the query. > In this FLIP, we propose some join hints by the existing join > strategies in Flink SQL for Batch job. > I'm look forward to your feedback about FLIP-229. > > > > > -- > > Best！ > Xuyang > > > [1] > https://cwiki.apache.org/confluence/display/FLINK/FLIP-229%3A+Introduces+Join+Hint+for+Flink+SQL+Batch+Job > [2] > https://docs.google.com/document/d/1IL00ME0Z0nlXGDWTUPODobVQMAm94PAPr9pw9EdGkoQ/edit?usp=sharing
