[
https://issues.apache.org/jira/browse/CASSANDRA-18102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698190#comment-17698190
]
maxwellguo commented on CASSANDRA-18102:
----------------------------------------
[~paulo][~smiklosovic]I am so sorry that the old pr is discard due to an
operation mistake by me and I feeel very sorry. And I have create a new one .
[old pr link that discard by me, but some conversations is left
|https://github.com/apache/cassandra/pull/2117]
[the new pr that have been modify after resolved the conversations
|https://github.com/apache/cassandra/pull/2205]
[java 8
precommit|https://app.circleci.com/pipelines/github/Maxwell-Guo/cassandra/417/workflows/440693db-00d0-4d86-aaf8-008d94f48ed4]
[java11 precommit
|https://app.circleci.com/pipelines/github/Maxwell-Guo/cassandra/417/workflows/0b7c8599-2146-4f8f-83e7-347b60db5711]
> 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: [email protected]
For additional commands, e-mail: [email protected]
