Im trying to create a new table using the command:
create table schema2(city varchar, loc list, pop int, zip varchar,state varchar, primary key (city, zip)) WITH CLUSTERING ORDER BY (city ASC, zip DESC);
But I get the error:
InvalidRequest: Error from server: code=2200 [Invalid query] message="Only clustering key columns can be defined in CLUSTERING ORDER directive"
I specified the primary keys I want and I did the clustering order by with only primary keys but it still gets and error. How do I fix this?