Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-7574

Support Custom Predicate in CQL SELECT for Custom Secondary Index

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Low
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: Feature/2i Index
    • Labels:
      None

      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

        Attachments

        Issue Links

          Activity

            People

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment