[jira] [Commented] (CASSANDRA-4369) Sortable counter type for 'top N' type query use cases

["Maheedhar Gunturu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-4369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13855946#comment-13855946 ] 

Maheedhar Gunturu commented on CASSANDRA-4369:
----------------------------------------------

It will be really nice to have this issue fixed as we heavily rely on this use-case. [~jbellis]S - Can someone Please take this up.

> 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 was sent by Atlassian JIRA
(v6.1.5#6160)