[
https://issues.apache.org/jira/browse/CASSANDRA-5313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13593656#comment-13593656
]
Sylvain Lebresne commented on CASSANDRA-5313:
---------------------------------------------
Such a function would be relatively easy to provide in itself, but with the
caveat that it wouldn't be smart. It would just compute the size of the
collection server side before returning it to the client. So the only "win"
would be avoiding the transfer of the collection over the wire between client
and server. Which I'd be fine with, but there is always the worry that people
will expect it to be smarter than that when it isn't.
> provide a cardinality function for collection types ( CQL3 )
> ------------------------------------------------------------
>
> Key: CASSANDRA-5313
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5313
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Ahmet AKYOL
> Labels: cql3, ponies
>
> Currently , cql3 doesn't provide a cardinality function for collection types.
> It'll be great to have one:
> {code}
> select content, cardinality(like_set),cardinality(dislike_set) from comments
> where id=?;
> {code}
> or size as keyword
> {code}
> select content, size(like_set),size(dislike_set) from comments where id=?;
> {code}
> Something similar in SQL is [cardinality of nested
> tables|http://www.techonthenet.com/oracle/functions/cardinality.php] .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
