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 [2] 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 Best, JING ZHANG Paul Lam <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 > >
