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.