cqlsh:stats> CREATE TABLE userstats ( username varchar, countername varchar, value counter, PRIMARY KEY (username, countername) ) WITH comment='User Stats' and compact storage;
cqlsh:stats> insert into userstats (username,countername, value) values ('ed','a',1);
Bad Request: INSERT statement are not allowed on counter tables, use UPDATE instead
cqlsh:stats> update userstats (username,countername, value) values ('ed','a',1);
Bad Request: [...]
Cassandra model is so distinct and restrictive compared to a classic relational model that I always had doubt about the suitability of a SQL like language for Cassandra. Here is the proof.