[CASSANDRA-18102] Add a virtual table to list snapshots

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.0-alpha1, 5.0
• Component/s: Feature/Virtual Tables, Local/Snapshots
• Change Category: Operability
• Complexity: Normal
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/fc9efd6357fb4255174689b3c107b897254a7d2f

Test and Documentation Plan

ut

• Assignee: Maxwell Guo
• Reporter: Paulo Motta

Authors

Maxwell Guo

Reviewers

Paulo Motta, Stefan Miklosovic

• Created: 08/Dec/22 01:06
• Updated: 12/Sep/23 13:03
• Resolved: 22/Mar/23 13:24

Description

It should be possible to query a node's snapshots via virtual tables.

The table should expose the same fields/columns as the TableSnapshot class.

Something along these lines:

cqlsh> SELECT * FROM system_views.snapshots;
 
tag | keyspace_name | table_name |  table_id | is_ephemeral | created_at | expires_at | directories
----+---------------+------------+-----------+--------------+-----------+------------+------------
1670460346841 | system | compaction_info | 123e4567-e89b-12d3-a456-426614174000 | false | 2022-12-08T00:45:47.108Z | null | {'/var/lib/cassandra/data/system/compaction_history-b4dbb7b4dc493fb5b3bfce6e434832ca/snapshots/1670460346841'}

Issue Links

• is related to: CASSANDRA-13338 JMX: EstimatedPartitionCount / SnapshotSize are expensive
• relates to: CASSANDRA-18111 Centralize all snapshot operations to SnapshotManager and cache snapshots