Hi JING, Thanks for your inputs! It helps a lot.
Best, Paul Lam > 2021年8月12日 13:13，JING ZHANG <beyond1...@gmail.com> 写道： > > Hi Paul, > There are Table hints and Query hints. > Query hints are on the way, there is a JIRA to track this issue [3]. AFAIK, > the issue is almost close to submit a pull request now. > > Table hints[1][2] are already supported since Flink 1.11. You could find more > detail information in [1][2]. > For table hints, you could define any valid connector properties in OPTIONS > hint, framework would merge those properties defined in OPTIONS hint with > properties defined in DDL, then try to find a table factory. > > [1] > https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL > > <https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+Supports+Dynamic+Table+Options+for+Flink+SQL> > [2] > https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/ > > <https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/dev/table/sql/queries/hints/> > [3] https://issues.apache.org/jira/browse/FLINK-20670 > <https://issues.apache.org/jira/browse/FLINK-20670> > > Best, > JING ZHANG > > Paul Lam <paullin3...@gmail.com <mailto:paullin3...@gmail.com>> 于2021年8月12日周四 > 下午12:10写道： > Hi community, > > I’m trying out SQL hints on DML, but there’s not very much about the > supported SQL hints on the docs. > > Are the SQL hints limited to source/sink tables only at the moment? And where > can I find the full list of > supported SQL hints? > > Thanks in advance! > > Best, > Paul Lam >
