Note: we only plan to support table hints in Flink release 1.11, so please focus mainly on the table hints part and just ignore the planner hints, sorry for that mistake ~
Best, Danny Chan 在 2020年3月9日 +0800 PM4:36，Danny Chan <yuzhao....@gmail.com>，写道： > Hi, fellows ~ > > I would like to propose the supports for SQL hints for our Flink SQL. > > We would support hints syntax as following: > > select /*+ NO_HASH_JOIN, RESOURCE(mem='128mb', parallelism='24') */ > from > emp /*+ INDEX(idx1, idx2) */ > join > dept /*+ PROPERTIES(k1='v1', k2='v2') */ > on > emp.deptno = dept.deptno > > Basically we would support both query hints(after the SELECT keyword) and > table hints(after the referenced table name), for 1.11, we plan to only > support table hints with a hint probably named PROPERTIES: > > table_name /*+ PROPERTIES(k1='v1', k2='v2') *+/ > > I am looking forward to your comments. > > You can access the FLIP here: > https://cwiki.apache.org/confluence/display/FLINK/FLIP-113%3A+SQL+and+Planner+Hints > > Best, > Danny Chan
