[
https://issues.apache.org/jira/browse/CASSANDRA-5267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Ellis resolved CASSANDRA-5267.
---------------------------------------
Resolution: Won't Fix
This doesn't work with Cassandra's storage engine. Partitions are ordered by
the partitioner, and data within a partition is ordered by the comparator...
> Index organized table
> ---------------------
>
> Key: CASSANDRA-5267
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5267
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Srdjan Mitrovic
> Priority: Minor
>
> 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).
> {noformat}CREATE TABLE blog_entries (
> posted_at timestamp,
> blog_id int
> author text,
> content text,
> PRIMARY KEY (posted_at)
> )
> ORGANIZATION INDEX ON (blog_id);
> {noformat}
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
