[
https://issues.apache.org/jira/browse/CALCITE-495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233668#comment-14233668
]
James Taylor commented on CALCITE-495:
--------------------------------------
We only allow hints on the top level query, directly after the SELECT, UPSERT,
or DELETE. They are basically "global" to the query. Here's a list of them:
http://phoenix.apache.org/language/index.html#hint
Hints are less important as the optimizer improves, so we're not wed to any of
these. Best-case, we wouldn't need them. It is handy, though, to have a way of
overriding optimizer decisions.
> Support hints to be passed through select/DML commands
> ------------------------------------------------------
>
> Key: CALCITE-495
> URL: https://issues.apache.org/jira/browse/CALCITE-495
> Project: Calcite
> Issue Type: Improvement
> Reporter: James Taylor
> Assignee: Julian Hyde
> Labels: phoenix
>
> Hints are a useful mechanism for allowing the user to override optimizer
> decisions. It'd be nice if Calcite supported passing hints through in the /*+
> MY_HINT MY_OTHER_HINT */ syntax. For examples, see
> http://phoenix.apache.org/language/index.html#select
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
