You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Ahmet AKYOL (JIRA)" <ji...@apache.org> on 2012/06/24 21:17:42 UTC
[jira] [Created] (CASSANDRA-4369) Sortable counter type for 'top N'
type query use cases
Ahmet AKYOL created CASSANDRA-4369:
--------------------------------------
Summary: Sortable counter type for 'top N' type query use cases
Key: CASSANDRA-4369
URL: https://issues.apache.org/jira/browse/CASSANDRA-4369
Project: Cassandra
Issue Type: New Feature
Reporter: Ahmet AKYOL
Current counter type is not sortable by values, AFAIK. Here's a related question :
http://stackoverflow.com/questions/8428364/how-to-get-sorted-counters-from-cassandra
This feature can be very handy for 'top N' type query use cases like sorting user points and finding top users in a reputation system.
Of course, support in CQL 3 is trivial.
IMHO, from implementation point of view, this looks unnatural to C* since C* sorts column names not the values.Maybe a composite column solution like (counter,char) is more proper but I can't imagine a way to make this work right now, it doesn't make sense to me. On the other hand, it would be very useful for us, the users.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4369) Sortable counter type for 'top N'
type query use cases
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams updated CASSANDRA-4369:
----------------------------------------
Labels: ponies (was: )
> Sortable counter type for 'top N' type query use cases
> ------------------------------------------------------
>
> Key: CASSANDRA-4369
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4369
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Ahmet AKYOL
> Labels: ponies
>
> Current counter type is not sortable by values, AFAIK. Here's a related question :
> http://stackoverflow.com/questions/8428364/how-to-get-sorted-counters-from-cassandra
> This feature can be very handy for 'top N' type query use cases like sorting user points and finding top users in a reputation system.
> Of course, support in CQL 3 is trivial.
> IMHO, from implementation point of view, this looks unnatural to C* since C* sorts column names not the values.Maybe a composite column solution like (counter,char) is more proper but I can't imagine a way to make this work right now, it doesn't make sense to me. On the other hand, it would be very useful for us, the users.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira