[
https://issues.apache.org/jira/browse/CASSANDRA-18102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17702333#comment-17702333
]
Stefan Miklosovic edited comment on CASSANDRA-18102 at 3/19/23 6:09 PM:
------------------------------------------------------------------------
I was discussing with Andres that we might add CQL functions taking longs and
returning whatever size unit one wants. Like sizeof('true_size', 'MiB') would
return it in MiB. So, I think that having just a simple long as a base to start
with is fine. However, it might be quite confusing to parse that number
"visually" to see what the size is, we have human-friendly output in nodetool
already afaik but for this future flexibility in size representation it might
be worth it (plus doing selects on it as in the above example).
was (Author: smiklosovic):
I was discussing with Andres that we might add CQL functions taking longs and
returning whatever size unit one wants. Like sizeof('true_size', 'MiB') would
return it in MiB. So, I think that having just a simple long as a base to start
with is fine. However, it might be quite confusing to parse that number
"visually" to see what the size is, we have human-friendly output in nodetool
already afaik but fo this future flexibility in size representation is might be
worth it (plus doing selects on it as in the above example).
> 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]
