Yes it is possible, read this: http://www.slideshare.net/doanduyhai/datastax-day-2016-cassandra-data-modeling-basics/24
and the following slides On Sun, Oct 9, 2016 at 2:04 AM, Ali Akhtar <ali.rac...@gmail.com> wrote: > Is it possible to have multiple clustering keys in cassandra, or some > other way to order by multiple columns? > > For example, say I have a table of songs, and each song has a rating and a > date. > > I want to sort songs by rating first, and then with newer songs on top. > > So if two songs have 5 rating, and one's date is 1st Feb, the other is 2nd > Feb, then I want the 2nd feb one to be sorted above the 1st feb one. > > Like this: > > Select * from songs order by rating, createdAt > > Is this possible? >
