[CASSANDRA-10496] Make DTCS/TWCS split partitions based on time during compaction

• Type: Improvement
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Local/Compaction
• Labels: dtcs pull-request-available
• Assignee: Unassigned
• Reporter: Marcus Eriksson
• Created: 09/Oct/15 06:44
• Updated: 07/Mar/23 10:53

Description

To avoid getting old data in new time windows with DTCS (or related, like TWCS), we need to split out old data into its own sstable during compaction.

My initial idea is to just create two sstables, when we create the compaction task we state the start and end times for the window, and any data older than the window will be put in its own sstable.

By creating a single sstable with old data, we will incrementally get the windows correct - say we have an sstable with these timestamps:

[100, 99, 98, 97, 75, 50, 10]
and we are compacting in window [100, 80] - we would create two sstables:
[100, 99, 98, 97], [75, 50, 10], and the first window is now 'correct'. The next compaction would compact in window [80, 60] and create sstables [75], [50, 10] etc.

We will probably also want to base the windows on the newest data in the sstables so that we actually have older data than the window.

Issue Links

• is duplicated by: CASSANDRA-10306 Splitting SSTables in time, deleting and archiving SSTables
• is duplicated by: CASSANDRA-8361 Make DTCS split SSTables to perfectly fit time windows
• links to: GitHub Pull Request #147