[CASSANDRA-5267] Index organized table

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Won't Fix
• Assignee: Unassigned
• Reporter: Srdjan Mitrovic
• Created: 18/Feb/13 21:36
• Updated: 16/Apr/19 09:32
• Resolved: 19/Feb/13 01:22

Description

The purpose is to enable very fast scans for queries which use WHERE indexed_column_value='foo';

We could borrow syntax from Oracle (with a small difference).

CREATE TABLE blog_entries (
    posted_at timestamp,
    blog_id int
    author text,
    content text,
    PRIMARY KEY (posted_at)
)
ORGANIZATION INDEX ON (blog_id);

In the background we could have a CF having only (key, indexed_value), in this case (posted_at, blog_id) so that we can maintain our index when we delete a row or change blog_id, and we would store other values within the index.