[jira] [Created] (CALCITE-4705) calcite should support hint like /*+ skewjoin(a(c0, c1)) */

["jibiyr (Jira)" <ji...@apache.org>]

jibiyr created CALCITE-4705:
-------------------------------

             Summary: calcite should support hint like /*+ skewjoin(a(c0, c1)) */
                 Key: CALCITE-4705
                 URL: https://issues.apache.org/jira/browse/CALCITE-4705
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.27.0
            Reporter: jibiyr
            Assignee: jibiyr
             Fix For: 1.28.0


Dear community,

calcite parse support hint now,but it can not parse hint like follew,

_*select /*+ skewjoin(a(c0, c1)) */ * from T0 a join T1 b on a.c0 = b.c0,*_

this is the bnf which is calcite supported now,
{code:java}
// 
hint:
      hintName
  |   hintName '(' hintOptions ')'

hintOptions:
      hintKVOption [, hintKVOption ]*
  |   optionName [, optionName ]*
  |   optionValue [, optionValue ]*

hintKVOption:
      optionName '=' stringLiteral
  |   stringLiteral '=' stringLiteral

optionValue:
      stringLiteral
  |   numericLiteral
{code}
I think the hintOptions should support the function call pattern,like a(c0,c1).  and this pattern can be parsed by spark/presto now.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)