Hi Danny, +1 for table hints, thanks for driving. I took a look to FLIP, most of content are talking about query hints. It is hard to discussion and voting. So +1 to split it as Jark said.
Another thing is configuration that suitable to config with table hints: "connector.path" and "connector.topic", Are they really suitable for table hints? Looks weird to me. Because I think these properties are the core of table. Best, Jingsong Lee On Mon, Mar 9, 2020 at 5:30 PM Jark Wu <imj...@gmail.com> wrote: > Thanks Danny for starting the discussion. > +1 for this feature. > > If we just focus on the table hints not the query hints in this release, > could you split the FLIP into two FLIPs? > Because it's hard to vote on partial part of a FLIP. You can keep the table > hints proposal in FLIP-113 and move query hints into another FLIP. > So that we can focuse on the table hints in the FLIP. > > Thanks, > Jark > > > > On Mon, 9 Mar 2020 at 17:14, DONG, Weike <kyled...@connect.hku.hk> wrote: > > > Hi Danny, > > > > This is a nice feature, +1. > > > > One thing I am interested in but not mentioned in the proposal is the > error > > handling, as it is quite common for users to write inappropriate hints in > > SQL code, if illegal or "bad" hints are given, would the system simply > > ignore them or throw exceptions? > > > > Thanks : ) > > > > Best, > > Weike > > > > On Mon, Mar 9, 2020 at 5:02 PM Danny Chan <yuzhao....@gmail.com> wrote: > > > > > 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 > > > > > > -- Best, Jingsong Lee