Does azure cosmos db cassandra api support compound primary key?

Question

Referring to https://docs.datastax.com/en/cql-oss/3.3/cql/cql_using/useCompoundPrimaryKeyConcept.html.

I have a schema in which I have multiple primary keys which is something similar to this:

CREATE TABLE cyclist_category ( 
category text, 
points int, 
id UUID, 
lastname text,     
PRIMARY KEY (category, points)
) WITH CLUSTERING ORDER BY (points DESC);

Can I create a similar schema in azure cosmos db with cassandra api?

Answer 1

In Cosmos DB the primary key maps to the partition key where we don't yet support compound partition keys. You would have to concatenate the values here as a work around.

Thanks.