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?
