[CASSANDRA-6477] Materialized Views (was: Global Indexes)

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0 alpha 1
• Component/s: Feature/Materialized Views, Legacy/CQL
• Labels: cql
• Assignee: Carl Yeksigian
• Reporter: Jonathan Ellis

Authors

Carl Yeksigian

Reviewers

Joshua McKenzie

• Created: 11/Dec/13 23:16
• Updated: 16/Apr/19 09:31
• Resolved: 30/Jul/15 00:55

Description

Local indexes are suitable for low-cardinality data, where spreading the index across the cluster is a Good Thing. However, for high-cardinality data, local indexes require querying most nodes in the cluster even if only a handful of rows is returned.

Issue Links

• duplicates: CASSANDRA-9826 Expose tuning parameters from CREATE TABLE to MV
• is related to: CASSANDRA-9917 MVs should validate gc grace seconds on the tables involved
• is related to: CASSANDRA-9967 Determine if a Materialized View is finished building, without having to query each node
• is related to: CASSANDRA-9928 Add Support for multiple non-primary key columns in Materialized View primary keys
• is related to: CASSANDRA-8517 Make client-side Token Aware Balancing possible with Global Indexes
• is related to: CASSANDRA-9826 Expose tuning parameters from CREATE TABLE to MV
• is related to: CASSANDRA-9927 Security for MaterializedViews
• relates to: CASSANDRA-12888 Incremental repairs broken for MVs and CDC
• relates to: CASSANDRA-9779 Append-only optimization
• relates to: CASSANDRA-9664 Allow MV's select statements to be more complex
• relates to: CASSANDRA-9415 Implicit use of Materialized Views on SELECT
• links to: Design doc