First, this is a compound primary key, not a composite [partition] key.
You don't have a column definition for dpci, your partition key.
Compact storage requires precisely and exactly and only one non-primary key
column, but you have two. Maybe dpci and item were supposed to be the same.
-- Jack
Thank you for your reply Jack!
That's my mistake. This is the actual table
CREATE TABLE store ( item text, location text, type text,
PRIMARY KEY (item, location) ) WITH COMPACT STORAGE;
And it gives the same error to me. Have been finding a way to solve it. But
no luck so far.
Tha