[jira] [Comment Edited] (CASSANDRA-12367) Add an API to request the size of a CQL partition
[ https://issues.apache.org/jira/browse/CASSANDRA-12367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15488541#comment-15488541 ] sankalp kohli edited comment on CASSANDRA-12367 at 9/13/16 9:50 PM: This JIRA is for getting the size on disk for a CQL partition. You might want to create a separate JIRA for SIZE ON feature. Like I said, SIZE ON won't work for this. was (Author: kohlisankalp): This JIRA is for getting the size on disk for a CQL partition. You might want to create a separate JIRA for SIZE ON feature. > Add an API to request the size of a CQL partition > - > > Key: CASSANDRA-12367 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12367 > Project: Cassandra > Issue Type: Improvement >Reporter: Geoffrey Yu >Assignee: Geoffrey Yu >Priority: Minor > Fix For: 3.x > > Attachments: 12367-trunk-v2.txt, 12367-trunk.txt > > > It would be useful to have an API that we could use to get the total > serialized size of a CQL partition, scoped by keyspace and table, on disk. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-12367) Add an API to request the size of a CQL partition
[ https://issues.apache.org/jira/browse/CASSANDRA-12367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15488541#comment-15488541 ] sankalp kohli edited comment on CASSANDRA-12367 at 9/13/16 9:50 PM: This JIRA is for getting the size on disk for a CQL partition. You might want to create a separate JIRA for SIZE ON feature. was (Author: kohlisankalp): This JIRA we created is for getting the size on disk for a CQL partition. You might want to create a separate JIRA for SIZE ON feature. > Add an API to request the size of a CQL partition > - > > Key: CASSANDRA-12367 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12367 > Project: Cassandra > Issue Type: Improvement >Reporter: Geoffrey Yu >Assignee: Geoffrey Yu >Priority: Minor > Fix For: 3.x > > Attachments: 12367-trunk-v2.txt, 12367-trunk.txt > > > It would be useful to have an API that we could use to get the total > serialized size of a CQL partition, scoped by keyspace and table, on disk. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-12367) Add an API to request the size of a CQL partition
[ https://issues.apache.org/jira/browse/CASSANDRA-12367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15484582#comment-15484582 ] Russell Bradberry edited comment on CASSANDRA-12367 at 9/12/16 4:40 PM: I agree with [~thobbs] that it doesn't really belong in CQL directly. The writeTime and ttl meta information in CQL is at the column level and makes sense. What about exposing it in the same way that TRACING is exposed? where setting something like "SIZES ON" will modify the output and can be implemented in the clients in a similar fashion This way, the size of the query can be returned and the user doesn't have to modify the query to understand how it is stored. was (Author: devdazed): I agree with [~thobbs] that it doesn't really belong in CQL directly. The writeTime and ttl meta information in CQL is at the column level and makes sense. What about exposing it in the same way that TRACING is exposed? where setting something like "SIZES ON" will modify the output and can be implemented in the clients in a similar fashion > Add an API to request the size of a CQL partition > - > > Key: CASSANDRA-12367 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12367 > Project: Cassandra > Issue Type: Improvement >Reporter: Geoffrey Yu >Assignee: Geoffrey Yu >Priority: Minor > Fix For: 3.x > > Attachments: 12367-trunk-v2.txt, 12367-trunk.txt > > > It would be useful to have an API that we could use to get the total > serialized size of a CQL partition, scoped by keyspace and table, on disk. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CASSANDRA-12367) Add an API to request the size of a CQL partition
[ https://issues.apache.org/jira/browse/CASSANDRA-12367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15432280#comment-15432280 ] Marcus Eriksson edited comment on CASSANDRA-12367 at 8/23/16 7:31 AM: -- Could we use {{SSTableReader.getScanner(Range range, ...)}} instead of scanning all the partitions in the sstable? We would need to create the range so that it includes the token requested but I think it should save us some time by seeking to the correct position directly. edit: And maybe we should output more information about the partition? Like average row size, number of rows, tombstones, etc? was (Author: krummas): Could we use {{SSTableReader.getScanner(Range range, ...)}} instead of scanning all the partitions in the sstable? We would need to create the range so that it includes the token requested but I think it should save us some time by seeking to the correct position directly. > Add an API to request the size of a CQL partition > - > > Key: CASSANDRA-12367 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12367 > Project: Cassandra > Issue Type: Improvement >Reporter: Geoffrey Yu >Assignee: Geoffrey Yu >Priority: Minor > Fix For: 3.x > > Attachments: 12367-trunk.txt > > > It would be useful to have an API that we could use to get the total > serialized size of a CQL partition, scoped by keyspace and table, on disk. -- This message was sent by Atlassian JIRA (v6.3.4#6332)