[
https://issues.apache.org/jira/browse/CASSANDRA-18112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17911180#comment-17911180
]
Caleb Rackliffe edited comment on CASSANDRA-18112 at 1/8/25 9:08 PM:
---------------------------------------------------------------------
It looks like, from the dev list discussion, we might try to move forward with
something along the lines of...
{noformat}
SELECT ... FROM ... WHERE ... WITH OPTIONS = { 'exclude_indexes' : [<ks.idx1>,
<ks.idx2>] }
{noformat}
There are going to be some corner cases here:
1.) What happens when we mention a non-existent index?
2.) What should happen when we exclude all the indexes that could be used for a
query?
3.) Should we provide a simple syntax for single-index exclusions, or just go
with a list-based format for everything?
It feels like the answer for 1 and 2 above is that we should just fail the
query outright.
was (Author: maedhroz):
It looks like, from the dev list discussion, we might try to move forward with
something along the lines of...
{noformat}
SELECT ... FROM ... WHERE ... WITH OPTIONS = { 'exclude_indexes' : [<ks.idx1>,
<ks.idx2>] }
{noformat}
> Add the feature of INDEX HINT for CQL
> --------------------------------------
>
> Key: CASSANDRA-18112
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18112
> Project: Apache Cassandra
> Issue Type: Improvement
> Components: CQL/Syntax, Feature/SAI, Legacy/CQL
> Reporter: Maxwell Guo
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x
>
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
