cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5313) provide a cardinality function for collection types ( CQL3 )
Date Tue, 05 Mar 2013 17:48:12 GMT

    [ 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

Mime
View raw message