[CASSANDRA-15604] Remove obsolete table/MV options from schema tables

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Won't Fix
• Platform: All
• Assignee: Unassigned
• Reporter: Olivier Michallat
• Created: 26/Feb/20 18:49
• Updated: 04/Mar/20 18:19
• Resolved: 04/Mar/20 18:19

Description

CASSANDRA-13910 removed the read_repair_chance and dclocal_read_repair_chance options for tables and materialized views.

CASSANDRA-12868 made default_time_to_live illegal for materialized views.

However the corresponding columns still exist in system_schema.tables and system_schema.views. Maybe it would make sense to remove them in Cassandra 4. Historically, obsolete options have been removed in similar cases, for example compaction_strategy_class, compaction_strategy_options and compression_parameters were present in 2.2 but removed in 3.0 (arguably there was also a major refactoring of schema tables during that transition).

This is not a huge deal, but it would make things a bit easier for the Java driver (our metadata exposes a "client-side describe" feature, and currently we assume that any column in the schema table must be added to the CREATE TABLE statement).

Issue Links

• is caused by: CASSANDRA-12868 Reject default_time_to_live option when creating or altering MVs
• is caused by: CASSANDRA-13910 Remove read_repair_chance/dclocal_read_repair_chance
• relates to: CASSANDRA-14825 Expose table schema for drivers