You need to specify all the clustering key components in the CLUSTERING ORDER
BY clause
create table demo(oid int,cid int,ts timeuuid,PRIMARY KEY (oid,cid,ts)) WITH
CLUSTERING ORDER BY (cid ASC, ts DESC);
cheers
-
Aaron Morton
New Zealand
@aaronmorton
Co-Founder & Principal C
Hi All,
My Usecase
I want query result by ordered by timestamp DESC. But I don't want
timestamp to be the second column in the primary key as that will take of
my querying capability
for example
create table demo(oid int,cid int,ts timeuuid,PRIMARY KEY
(oid,cid,ts)) WITH CLUSTERING ORDER BY (ts
