[CASSANDRA-18168] Serialize sstable keyspace and table metadata on StatsMetadata component

• Type: Improvement
• Status: Triage Needed
• Priority: Normal
• Resolution: Unresolved
• Component/s: Local/SSTable
• Labels: lhf
• Platform: All
• Assignee: Unassigned
• Reporter: Paulo Motta
• Created: 17/Jan/23 03:42
• Updated: 17/Jan/23 03:50

Description

Currently Cassandra relies on the parent directory structure to figure out the keyspace/table of a given sstable: $data_dir/$keyspace/$tablename-$tableId/$sstable.

Offline tools require sstables to be placed in the well-defined directory structure above to correctly parse keyspace/table information.

We can improve this by serializing keyspace/table metadata (such as keyspace/table names and table id) into the StatsMetadata component, so offline tools can read sstables from any parent directory.

Issue Links

• is related to: CASSANDRA-9587 Serialize table schema as a sstable component
• is related to: CASSANDRA-14013 Keyspace named "snapshots" is empty after service restart