Concept
CREATE MATERIALIZED VIEW: separate table maintained from base. Different partition key. Simplifies querying denormalized data.
Advertisement
Consistency issues
Base + view can drift. Repair complex. Batch semantics tricky. Cassandra 3.x had known bugs.
Advertisement
Deprecation debate
Community discussed removal. Officially 'experimental' since 3.11. Some improvements in 4.x + 5.0 but still uncommon.