CREATE TABLE tutorialkeyspace.countries ( country text, state text, total_pop int STATIC, PRIMARY KEY (country, state) ); INSERT INTO tutorialkeyspace.countries (country, total_pop) VALUES ('USA', 328000000); SELECT * FROM tutorialkeyspace.countries;
According to the spec, the INSERT should fail. But it works fine in Amazon Keyspaces (using Apache Cassandra 3.11.2). And DataStax Astra (DSE DB 4.0.0.687).
I suspect it has something to do with the STATIC field. Without it, it doesn't work indeed.