[CASSANDRA-7458] functional indexes

• Type: New Feature
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Legacy/CQL
• Labels: CQL doc-impacting
• Assignee: Unassigned
• Reporter: Jonathan Ellis
• Tester: Shawn Kumar
• Created: 26/Jun/14 22:17
• Updated: 07/Mar/23 10:54

Description

Indexing information derived from the row can be powerful. For example, using the hypothetical extract_date function,

create table ticks (
    symbol text,
    ticked_at datetime,
    price int,
    tags set<text>,
    PRIMARY KEY (symbol, ticked_at)
);

CREATE INDEX ticks_by_day ON ticks(extract_date(ticked_at));

SELECT * FROM ticks_by_day WHERE extract_date(ticked_at) = '2014-5-13';

http://www.postgresql.org/docs/9.3/static/indexes-expressional.html

Issue Links

• depends upon: CASSANDRA-7395 Support for pure user-defined functions (UDF)
• relates to: CASSANDRA-7461 operator functionality in CQL