not a support question
rockytriton
Member
Is it possible to select data (either with CQL or not) to retrieve data sorted by a specific column? I tried to do an "order by" in CQL but it gave me some error about the column not being the 2nd key column.
Basically I'm creating a dynamic set of columns in a column space, and I would like to be able to paginate the data and have those columns sorted for the pagination on demand.
This could be of help http://blog.dynatrace.com/2011/12/05/pagination-with-cassandra-and-what-we-can-learn-from-it/
rockytriton
Member
Thanks for the link, this kind of setup would work if I was storing all of my data as individual columns in a single row but I don't think that would be practical, especially if there could be millions of entries.
My data is stored by row with dynamic column entries, generally 2 to 20 column names in the same column space. It looks like I wouldn't really be able to "slice" by that since you always need to provide a row key to do the get on.
