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
