[CASSANDRA-7574] Support Custom Predicate in CQL SELECT for Custom Secondary Index

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: Feature/2i Index
• Assignee: Unassigned
• Reporter: Yeshvanthni
• Created: 18/Jul/14 21:40
• Updated: 16/Apr/19 09:31
• Resolved: 25/Jul/14 18:55

Description

The SELECT query validation limits the predicates the custom secondary index can support.

Possible Approaches:
-Introduction of a special predicate string like custom_predicate which by-passes validation

CREATE CUSTOM INDEX ON table(column) USING 'org.example.CustomSecondaryIndex';

Select * from table where custom_predicate=" something_only_custom_class_understands"

This might open up possibilities like,

• Range queries on secondary indexed columns etc
• Wild cards

Issue Links

• duplicates: CASSANDRA-7575 Custom 2i validation