[CASSANDRA-18534] Make sstable format configurable per table

• Type: Improvement
• Status: Patch Available
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Cluster/Schema, Local/SSTable
• Change Category: Semantic
• Complexity: Normal
• Platform: All

Test and Documentation Plan

ut and jvm dt

• Assignee: Maxwell Guo
• Reporter: Branimir Lambov

Authors

Maxwell Guo

• Created: 18/May/23 09:41
• Updated: 02/Nov/23 16:52

Description

Some SSTable format settings need to be configurable per table for better efficiency. This includes:

• row_index_granularity
• bloom_filter_fp_chance
• crc_check_chance
• min/max_index_interval

Some of these are currently configurable using direct properties of tables. Having them as format properties makes better sense and should also support specifying useable combinations of settings, e.g.

CREATE TABLE ... WITH sstable_format = "bti-fast";
CREATE TABLE ... WITH sstable_format = "bti-small";

where bti-fast and bti-small can be defined in cassandra.yaml e.g. as

sstable.format.options:
  - bti-fast:
      row_index_granularity: 1kiB
      bloom_filter_fp_chance: 0.01
  - bti-small:
      row_index_granularity: 32kiB
      bloom_filter_fp_chance: 0.1

Issue Links

• depends upon: CASSANDRA-18441 Improvements to SSTable format configuration
• relates to: CASSANDRA-18398 CEP-25: Trie-indexed SSTable format
• links to: GitHub Pull Request #2786