[jira] [Updated] (CASSANDRA-5313) provide a cardinality function for collection types ( CQL3 )
[ https://issues.apache.org/jira/browse/CASSANDRA-5313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] C. Scott Andreas updated CASSANDRA-5313: Component/s: CQL > 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 > Components: CQL >Reporter: Ahmet AKYOL >Priority: Major > Labels: cql > > 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 was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-5313) provide a cardinality function for collection types ( CQL3 )
[ https://issues.apache.org/jira/browse/CASSANDRA-5313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ahmet AKYOL updated CASSANDRA-5313: --- Summary: provide a cardinality function for collection types ( CQL3 ) (was: add a cardinality function for collection types ( CQL3 )) > 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