[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2016-11-21 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15683790#comment-15683790
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

Feeling bad having drop the review on what's basically an ok patch, so took on 
myself to rebase below:
| [6538-3.X|https://github.com/pcmanus/cassandra/commits/6538-3.X] | 
[utests|http://cassci.datastax.com/job/pcmanus-6538-3.X-testall] | 
[dtests|http://cassci.datastax.com/job/pcmanus-6538-3.X-dtest] |
I added a simple unit test and I put the function in {{BytesConversionFcts}}, 
which I renamed in {{BytesFcts}}, to keep function declarations somewhat 
grouped.

[~snazy], since you commented somewhat recently, mind having a quick 
double-check on that rebase?


> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538-v2.patch, 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2016-05-03 Thread Robert Stupp (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268767#comment-15268767
 ] 

Robert Stupp commented on CASSANDRA-6538:
-

[~anuja_mandlecha], do you want to go ahead with this one? If yes, can you 
rebase it against current trunk and add the ASF copyright header to the new 
class source file?

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538-v2.patch, 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-23 Thread Anuja Mandlecha (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14334419#comment-14334419
 ] 

Anuja Mandlecha commented on CASSANDRA-6538:


Attached the updated patch (6538-v2.patch).

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538-v2.patch, 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-23 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14333484#comment-14333484
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

You're right, I forgot that we got that as part of CASSANDRA-6766 and did made 
the blob type accept anything. In hindisght, I'm not sure this was the best of 
idea (and it is somewhat inconcistent with how drivers deals with blob), but I 
guess it's too late now. And in any case, it's not really something that is in 
scope for this ticket. And that's my main point: we shouldn't special case any 
part of the code every time we add a new function or we'll end up with 
inconsistent behavior all over the place.

But as a side note, your changes to {{Selection}} makes even less sense in this 
light, they are basically a no-op since you're just inlining the BytesType 
{{isValueCompatible}} body.

Anyway, since we do accept everything for a blob, then I suggest we just let it 
be that way. That is, let's just remove the {{Selection}} changes from your 
patch, fix the use of {{ByteBuffer.array().length}} and rename the method to 
{{byteSizeOf}} ({{sizeOf}} is just too generic a name imo, people will be 
confused that applied to a collection this doesn't return the number of 
elements of the collection).


> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-23 Thread Anuja Mandlecha (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14333243#comment-14333243
 ] 

Anuja Mandlecha commented on CASSANDRA-6538:


{quote} As long as BytesType is declared as the type of argument, the type 
system ensure it will only be called on that{quote}
This is what is expected, but as per the code in BytesType.java as given below:
{code}
public boolean isValueCompatibleWithInternal(AbstractType otherType)
{
// BytesType can read anything
return true;
}
{code}
true is returned for every standard type (like text,int etc) and the sizeof 
calculates size for them,which is contradictory to how we want the sizeof() to 
behave. That is why I had introduced the type check in Selection.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-20 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14328900#comment-14328900
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

bq. we will have to check the datatype of providedArgs against BytesType

Well, no. As long as {{BytesType}} is declared as the type of argument, the 
type system ensure it will only be called on that. Really, what I'm suggesting 
is simply that you remove the change to {{Selection}} from your patch. 
Actually, that and the fact that you shouldn't use {{bb.array().length}} (as 
this return the length of the array backing the ByteBuffer but 1) that's *not* 
in general the same as the length of the ByteBuffer and 2) it's assuming that 
the ByteBuffer is backed by an array which is not an assumption it should 
make). Instead, just use {{ByteBuffer.remaining()}}.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, CodeSnippet.txt, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-20 Thread Anuja Mandlecha (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14328895#comment-14328895
 ] 

Anuja Mandlecha commented on CASSANDRA-6538:


I looked into the code and as per you requirement of allowing only blob types 
as input to sizeof() we will have to check the datatype of providedArgs against 
BytesType which is used for BLOB using the condition
{code}
if(fun.name().equalsIgnoreCase("sizeof")&& 
!args.get(0).getType().equals(BytesType.instance))
throw new InvalidRequestException(String.format("Type 
error: %s cannot be passed as argument 0 of function %s of type blob", 
args.get(0), fun.name()));
{code}
But as we can see in attached CodeSnippet.txt, to apply the same condition in 
validateTpes() where other validations are being done, we need getType() of 
providedArgs which we cannot get here since it is an object of class that 
implements interface AssignementTestable.
Hence to resolve this there can be two approaches,
1. Add one more argument of type Function to isAssignable() and check for the 
functionName and valid types and return value accordingly.
2. Use the if condition before calling validateTypes() (i.e. in makeSelector() 
of Selection class)
Note: Approach 1 can result into a lot of code change since the function 
declaration is getting changed.
Please let me know your thoughts on this.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-17 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14324018#comment-14324018
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

I have 2 "problems" with this ticket so far:
# I'm on the fence on whether allowing such function on non-frozen collection 
really make sense. In that case, the size returned will *not* be the size the 
collection has in the database, and I'm a bit afraid people will 
misunderstand/misuse it.
# We actually don't currently have a good way to declare a function that 
applies to _any_ type. The attached patch works around this by basically 
breaking the type system, making the blob type an "accept everything type" but 
that's not ok (I'm *strongly* against doing that).

Overall, what I'd suggest would be to add a method that only work on blobs. If 
you nedd the size of another type, we actually have the {{xAsBlob}} method for 
that so that's easily done (and it makes it more clear what is returned imo). 
It's worth noting that this won't work for frozen types (or collection in 
general) since we don't have {{xAsBlob}} functions for those, but imo it's a 
somewhat separate problem, one that should be tackled in another ticket.


> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-10 Thread Aleksey Yeschenko (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314580#comment-14314580
 ] 

Aleksey Yeschenko commented on CASSANDRA-6538:
--

But they all are variable-length (can be empty bb).

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-10 Thread Tyler Hobbs (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314573#comment-14314573
 ] 

Tyler Hobbs commented on CASSANDRA-6538:


[~anuja_mandlecha] only calculating for variable-length types makes sense to me.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch, sizeFzt.PNG
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-10 Thread Anuja Mandlecha (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314180#comment-14314180
 ] 

Anuja Mandlecha commented on CASSANDRA-6538:


I am taking a step back and reuploading the patch. Now I am considering 
everything as BLOB(bytebuffer) and the sizeOf() calculates the size for all 
data types(including standard data types like int,float).
But on a second thought I think calculating size of data types like integers, 
floats etc is of no use since they are fixed and the sizeOf() should only 
calculate the size for variable length data types like text,BLOB and collection 
types. Let me know your views and comments on the same.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
> Attachments: 6538.patch
>
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-02-09 Thread Anuja Mandlecha (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14312216#comment-14312216
 ] 

Anuja Mandlecha commented on CASSANDRA-6538:


I have taken up this bug and introduced a size() to calculate the size of the 
cell(each row) of the column given as parameter to the function. This function 
supports all standard and collection types. 
I am attaching the patch for the same. 

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2015-01-19 Thread Prajakta Bhosale (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14282474#comment-14282474
 ] 

Prajakta Bhosale commented on CASSANDRA-6538:
-

Yes even I agree, It would be useful in my scenario : 
I am trying to copy the columnfamily data to .csv files using "COPY TO" 
command: for records > "7 lakh" cassandra node going down without copying the 
data into .csv file.
So we decided to copy only required columns instead of complete table, which 
allow me to copy records > 7lakh without node failure.
If we will come to know the size of columns it will help us to decide number of 
columns to copy in .csv using "COPY TO" command. 

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-06-30 Thread Aleksey Yeschenko (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14048525#comment-14048525
 ] 

Aleksey Yeschenko commented on CASSANDRA-6538:
--

Would be useful for cqlsh indeed.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>  Labels: cql
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-15 Thread Johnny Miller (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13872048#comment-13872048
 ] 

Johnny Miller commented on CASSANDRA-6538:
--

bq. OTOH, if it's just a single column, how hard is it really to SELECT it? If 
it's not a blob then it's not huge, and if it is a blob then computing the size 
is pretty straightforward.

True, but it would be nice to have this available via the CQL CLI. I can 
appreciate there are ways to work around this, but I do think its a nice 
(minor) feature to have in there.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-03 Thread Jonathan Ellis (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861607#comment-13861607
 ] 

Jonathan Ellis commented on CASSANDRA-6538:
---

OTOH, if it's just a single column, how hard is it really to SELECT it?  If 
it's not a blob then it's not huge, and if it is a blob then computing the size 
is pretty straightforward.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-03 Thread Johnny Miller (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861593#comment-13861593
 ] 

Johnny Miller commented on CASSANDRA-6538:
--

bq.That being said, if we talking of CQL column values, it's probably not too 
hard to add a sizeof method that would return the size of a value instead of 
the value itself (not talking of doing any aggregation here). Not convinced it 
would be "extremely" useful but it's not particularly crazy either.

Unfortunately there are times when no one knows what was written into the 
column in the first place, so it would help to have this data in there also. 
Also sometime organisationally the people looking after Cassandra are not the 
same people writing to it so it can be a challenge to work this out.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-03 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861443#comment-13861443
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

bq. would this mean we would only be able to find the size of an entire row and 
not an individual cell/column?

For the JMX call, that would be the size of an entire partition (so thrift 
row), yes. But while I can buy that there is situation where a partition would 
grow bigger than you expected and you want to check it, it feels a lot less 
useful to me for a cell in general (because a cell don't "grow" in size, it's 
the size of the data you inserted).

That being said, if we talking of CQL column values, it's probably not too hard 
to add a sizeof method that would return the size of a value instead of the 
value itself (not talking of doing any aggregation here). Not convinced it 
would be "extremely" useful but it's not particularly crazy either.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-03 Thread Johnny Miller (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861408#comment-13861408
 ] 

Johnny Miller commented on CASSANDRA-6538:
--

[~slebresne] That would certainly be useful and if this issue should be 
dependent on CASSANDRA-4914 than it would be handy to have in the interim. 

However, would this mean we would only be able to find the size of an entire 
row and not an individual cell/column?

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>Priority: Minor
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-02 Thread Sylvain Lebresne (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13861305#comment-13861305
 ] 

Sylvain Lebresne commented on CASSANDRA-6538:
-

Whenever we have CASSANDRA-4914, it should be relatively simple to write an 
aggregation function that sum the data size of queried columns, but in the 
meantime, I'm highly skeptical that it's worth adding special casing for it (in 
CQL at least).

If it's only to check that a given partition isn't a lot bigger than one 
though, maybe a simpler option could be a JMX call that given a partition key, 
returns the total size it occupies on disk (which as a bonus we can do without 
actually reading the data, just the index).

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-02 Thread Johnny Miller (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13860622#comment-13860622
 ] 

Johnny Miller commented on CASSANDRA-6538:
--

When debugging issues in environments where the (suspicion) is that specific 
rows contain larger than expected data sizes and I am unable to write a client 
to read the data and check its size.

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6538) Provide a read-time CQL function to display the data size of columns and rows

2014-01-02 Thread Jonathan Ellis (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13860576#comment-13860576
 ] 

Jonathan Ellis commented on CASSANDRA-6538:
---

Useful for what?

> Provide a read-time CQL function to display the data size of columns and rows
> -
>
> Key: CASSANDRA-6538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6538
> Project: Cassandra
>  Issue Type: Improvement
>Reporter: Johnny Miller
>
> It would be extremely useful to be able to work out the size of rows and 
> columns via CQL. 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)