cqlsh> create table test.test(test int, x int, primary key(test));

cqlsh> insert into test.test(test) values(1);

cqlsh> select * from test.test;

 test | x

------+------

    1 | null

cqlsh> DROP TABLE IF EXISTS googleplus.user_followee_recent_relation

cqlsh> CREATE TABLE googleplus.user_followee_recent_relation(

   ...   followee_id int,

   ...   profile_id int,

   ...   counter_value counter,

   ...   PRIMARY KEY (followee_id, profile_id)

   ... );

cqlsh> update googleplus.user_followee_recent_relation set counter_value = counter_value + 1 where followee_id = 1 and profile_id = 1;

cqlsh> select * from googleplus.user_followee_recent_relation;

 followee_id | profile_id | counter_value

-------------+------------+---------------

           1 |          1 |             1

 cqlsh> insert into googleplus.user_followee_recent_relation(followee_id, profile_id, counter_value) values (1,1,0) using ttl 2;

InvalidRequest: code=2200 [Invalid query] message="INSERT statement are not allowed on counter tables, use UPDATE instead"

cqlsh> update googleplus.user_followee_recent_relation set counter_value = counter_value + 1 where followee_id = 2 and profile_id = 2 using ttl 3 ;

SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:122 missing EOF at 'using' (...2 and profile_id = 2 [using] ttl...)">

cqlsh> update using ttl 10 googleplus.user_followee_recent_relation set counter_value = counter_value + 1 where followee_id = 2 and profile_id = 2;

SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:25 no viable alternative at input '.' (update using ttl 10 googleplus[.]...)">

https://docs.datastax.com/en/cql/3.1/cql/cql_using/use_counter_t.html

To load data into a counter column, or to increase or decrease the value of the counter, use the UPDATE command. Cassandra rejects USING TIMESTAMP or USING TTL in the command to update a counter column.