[CASSANDRA-18112] Add the feature of INDEX HINT for CQL

• Type: Improvement
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.0.x
• Component/s: CQL/Syntax, Feature/SAI, Legacy/CQL
• Epic Link: Storage Attached Indexes (Phase 3)
• Change Category: Semantic
• Complexity: Normal
• Platform: All
• Assignee: Maxwell Guo
• Reporter: Maxwell Guo

Authors

Maxwell Guo

• Created: 13/Dec/22 14:30
• Updated: 23/Apr/24 16:17

Description

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.

Issue Links

• relates to: CASSANDRA-18782 Forbid analyzed SAI indexes on primary key columns