[CASSANDRA-3249] Index search in provided set of rows (support of sub query)

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Won't Fix
• Component/s: Legacy/CQL
• Assignee: Unassigned
• Reporter: Evgeny Ryabitskiy
• Created: 23/Sep/11 13:29
• Updated: 31/May/19 23:34
• Resolved: 31/May/19 23:34

Description

This issue is related to discussion on mailing list:
http://www.mail-archive.com/[e-mail]/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.

Issue Links

• is related to: CASSANDRA-2915 Lucene based Secondary Indexes