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

Index search in provided set of rows (support of sub query)

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Normal
    • Resolution: Won't Fix
    • Fix Version/s: None
    • Component/s: Legacy/CQL
    • Labels:
      None

      Description

      This issue is related to discussion on mailing list:
      http://www.mail-archive.com/user@cassandra.apache.org/msg17135.html

      Idea is to support Cassandra build-in index search over specified set of rows.

      From API view:

      It can be extension of get_indexed_slices, for example:

      List<byte[]> rowKys = ... ; //list of row keys
      IndexClause indexClause = new IndexClause();

      indexClause.setKeys(keys); //required API to set list of keys

      indexClause.setExpressions(someFilteringExpressions);
      List finalResult = get_indexed_slices(colParent, indexClause, colPredicate, cLevel);

      or create specified API method.

      From conceptual view it was noticed:
      That would be implementation of sub query.

      The index clause is applied to the set of all rows in the database, not a sub set, applying them to a sub set is implicitly supporting a sub query

      Benefits of this feature is that search can be split in 2 stages:
      1) Search over external engine (for example full text search)
      2) Cassandra build-in index search over result from first stage

      This combination could solve most of limitations that came with solution based only on external search engine.

        Attachments

        1. CASSANDRA-3249-draft1.patch
          11 kB
          Evgeny Ryabitskiy

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                apparition Evgeny Ryabitskiy
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: