[CASSANDRA-5970] FilteredRangeSlice command for regex searches against column names on known sets of keys

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Nate McCall
• Created: 02/Sep/13 19:23
• Updated: 16/Apr/19 09:32
• Resolved: 15/Dec/14 22:04

Description

This is the ability to apply a regex against columns when the set of keys is known. In filtering the keys, we would like to allow for the following clauses: E, GTE, LTE, NE, inclusive list, exclusive list.

The end goal is to provide for efficient searching in the case where you have some knowledge of the keys. A specific use case would be, say, searching user agent strings in the given set of date buckets in the classic time-series web log use case. This is a "sweet spot" for Cassandra and providing a more direct method of access for such will help a lot of users.

Additionally, this will provide some level of feature parity with RDBMS crowd who've had this feature for some time.

Internally, this will include the introduction of a new Verb, SSTableScanner extension and an ExtendedFilter implementation which applies the regex as well as a new method on StorageProxy.

This issue does not cover exposing this new query method to thrift and CQL, but obviously that will be required for this to be of any practical use. Those should be covered by separate issues.

Issue Links

• duplicates: CASSANDRA-8488 Filter by UDF