[CASSANDRA-7362] Be able to selectively "mount" a snapshot of a table as a read-only version of that table

• Type: New Feature
• Status: Open
• Priority: Low
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Legacy/Tools
• Assignee: Unassigned
• Reporter: Tupshin Harper
• Created: 06/Jun/14 22:54
• Updated: 07/Mar/23 10:54

Description

When doing batch jobs (thinking hive and shark as prominent examples) or repeated analysis of the same data, it can be challenging to get a consistent result if the data is changing under your feet. Rather than the low level CASSANDRA-2527, I propose that we add the capability to take a named snapshot (exact uuid in 2.1 and later), and be able to activate and deactivate it as a regular sstable (e.g. myks.mytable snapshot could be activated as myks.mytable-longuuid). That table would be queryable just like any other, but would not be writable. Any attempt to insert or update would throw an exception.

Issue Links

• depends upon: CASSANDRA-7190 Add schema to snapshot manifest
• relates to: CASSANDRA-2527 Add ability to snapshot data as input to hadoop jobs