incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "cbertu81@libero.it" <cbert...@libero.it>
Subject Sorting in Cassandra
Date Tue, 05 Oct 2010 20:06:23 GMT
Hi,
I need some help about sorting data in the right way from Cassandra.
I have a SuperColumnFamily

SCF: UserData {
                   UserID (ROW) {
                                 SuperColumnKey1 {
                                                        firstCol: value
                                                        secondCol: value
                                 }
                                 SuperColumnKey2 {
                                                        firstCol: value
                                                        secondCol: value
                                  }
                    }
}

Both CompareWith (SC & columns) are UTF8type ...

First question: when I make a get of all supercolumns within the UserID row 
I'd expect to receive them sorted alphabetically ... but it does not happen 
(did not understand what's the order ...)
Am I assuming it wrong?

Second question: can i get back all data sorted on firstCol Column? Imagine 
like SCKey is an ID of a Company and FirstCol is the name ... how can I get all 
the companies of a user sorted by name (alphabetic order)?

I am using Pelops Client on Cassandra 0.6.5 

Thanks in advance for any help.


Mime
View raw message