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

Avoid "ALLOW FILTERING" requirement for multiple restricted columns if index can handle them

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Triage Needed
    • Normal
    • Resolution: Unresolved
    • None
    • Feature/SASI
    • None
    • All
    • None

    Description

      When executing following query, "ALLOW FILTERING" is required even if both columns are indexed by SASI and used in QueryPlan:

      SELECT * FROM table WHERE age="20" and address="SF"

      We should consider providing a proper "QueryPlan" under "Index" interface to avoid "ALLOW FILTERING" when all restricted columns are handled by index.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jasonstack Zhao Yang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: