Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-18102

Add a virtual table to list snapshots

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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'}
      

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            maxwellguo Maxwell Guo Assign to me
            paulo Paulo Motta
            Maxwell Guo
            Paulo Motta, Stefan Miklosovic
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h 50m
                8h 50m

                Slack

                  Issue deployment