cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aaron Morton <>
Subject Re: Sorting in Cassandra
Date Tue, 05 Oct 2010 20:36:57 GMT
1. You cannot return just the super columns, you have to get their sub columns as well. The
returned data is ordered, please provide and example of where it is not. 

2. Pull back the entire row and filter/sort the columns client side. It's not possible to
return columns of the same name from different super columns (I think that's what you are
asking). Let me know if you think you have too much data per row to do that. 

Hope that helps. 


On 06 Oct, 2010,at 09:06 AM, "" <> wrote:

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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
    • Unnamed multipart/related (inline, None, 0 bytes)
View raw message