[
https://issues.apache.org/jira/browse/CASSANDRA-5313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ahmet AKYOL updated CASSANDRA-5313:
-----------------------------------
Description:
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] .
was:
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] .
> 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
> 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
