[CASSANDRA-13798] Disallow filtering on non-primary-key base column for MV

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.11.1, 4.0-alpha1, 4.0
• Component/s: Feature/Materialized Views
• Bug Category: Correctness - API / Semantic Implementation
• Severity: Normal
• Assignee: Zhao Yang
• Reporter: Zhao Yang

Authors

Zhao Yang

Reviewers

Paulo Motta

• Created: 25/Aug/17 03:02
• Updated: 15/May/20 08:06
• Resolved: 31/Aug/17 10:43

Description

We should probably consider disallow filtering conditions on non-primary-key base column for Materialized View which is introduced in CASSANDRA-10368.

The main problem is that the liveness of view row is now depending on multiple base columns (multiple filtered non-pk base column + base column used in view pk) and this semantic could not be properly support without drastic storage format changes. (SEE CASSANDRA-11500, background)

We should step back and re-consider the non-primary-key filtering feature together with supporting multiple non-PK cols in MV clustering key in CASSANDRA-10226.

Issue Links

• is related to: CASSANDRA-11500 Obsolete MV entry may not be properly deleted
• is related to: CASSANDRA-10226 Support multiple non-PK cols in MV clustering key when partition key is shared
• is related to: CASSANDRA-10368 Support Restricting non-PK Cols in Materialized View Select Statements
• relates to: CASSANDRA-13956 Cannot restrict columns on materialized view