[CASSANDRA-10307] Avoid always locking the partition key when a table has a materialized view

• Type: Improvement
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Materialized Views
• Labels: materializedviews
• Assignee: Unassigned
• Reporter: T Jake Luciani
• Created: 11/Sep/15 14:14
• Updated: 07/Mar/23 10:54

Description

When a table has associated materialized views we must restrict other concurrent changes to the affected rows. We currently lock the entire partition.

The issue is many updates to the same partition on the base table is now serialized effectively.

We can't lock the primary key instead due to range tombstones cover a range of rows.

If we created (or perhaps reuse if already exists) a clustering range class we can lock at this level.