[
https://issues.apache.org/jira/browse/CASSANDRA-18112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17646908#comment-17646908
]
maxwellguo commented on CASSANDRA-18112:
----------------------------------------
Besides I think the Hint feature is not limited to Index Hint , can be extends
to others , see https://phoenix.apache.org/language/index.html#hint and mysql
hint https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html , so in the
future the hint can be extends to some what CQL's hint for cassandra.
> Add the feature of INDEX HINT for CQL
> --------------------------------------
>
> Key: CASSANDRA-18112
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18112
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL/Syntax, Feature/2i Index
> Reporter: maxwellguo
> Priority: Normal
>
> It seems that CQL do not have the ability of INDEX HINT , such as when we
> have more than one secondary index for some data table,And if the query hit
> the indexes, the index with more estimate rows will be returned. But if we
> want the query to be executed under our willing , we can use a hint like
> ,hint specified index or ignore the index.
> At first I want to open a jira that to add the feature of hint for CQL ,But I
> think that may be a gigantic task with no clear goal.
> Besides I think there may need a DISSCUSS for the specific grammatical form
> before starting the work.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
