This is my table
CREATE TABLE videos_by_tag ( tag text, video_id uuid, added_date timestamp, title text, PRIMARY KEY ((tag,added_date),video_id) ) WITH CLUSTERING ORDER BY (added_date desc);
i have been asked to sort by ascending order on column added_date.
when i execute the below query. This is the error i am getting
cqlsh:video> SELECT * FROM videos_by_tag ORDER BY added_date ASC; InvalidRequest: Error from server: code=2200 [Invalid query] message="ORDER BY is only supported when the partition key is restricted by an EQ or an IN."