[
https://issues.apache.org/jira/browse/CASSANDRA-5313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13593317#comment-13593317
]
Ahmet AKYOL edited comment on CASSANDRA-5313 at 3/5/13 10:58 AM:
-----------------------------------------------------------------
>From schema design point of view, for such use case, maybe mixing counter
>columns and other data types in a table could be better but we can't do that
>in CQL 3 for now.
was (Author: liqusha):
From schema design point of view, for such use case, maybe mixing counter
columns and other data types in a table which we can't, AFAIK...
> add 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;
> {code}
> or size as keyword
> {code}
> select content, size(like_set),size(dislike_set) from comments;
> {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
