[ https://issues.apache.org/jira/browse/CASSANDRA-18102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698946#comment-17698946 ]
Stefan Miklosovic commented on CASSANDRA-18102: ----------------------------------------------- it is still flaky https://app.circleci.com/pipelines/github/instaclustr/cassandra/1972/workflows/21722109-cb38-4d57-80bb-f477037ab770/jobs/10408/tests#failed-test-0 very interesting. I do not have time for looking into that right now. Take a look if you want. > Add a virtual table to list snapshots > ------------------------------------- > > Key: CASSANDRA-18102 > URL: https://issues.apache.org/jira/browse/CASSANDRA-18102 > Project: Cassandra > Issue Type: Improvement > Components: Feature/Virtual Tables, Local/Snapshots > Reporter: Paulo Motta > Assignee: maxwellguo > Priority: Normal > Fix For: 5.0 > > Time Spent: 8h 40m > Remaining Estimate: 0h > > It should be possible to query a node's snapshots via virtual tables. > The table should expose the same fields/columns as the > [TableSnapshot|https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/service/snapshot/TableSnapshot.java] > class. > Something along these lines: > {noformat} > 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'} > {noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org