Counter Table in Cassandra
A counter is a special column used to store an integer value that can be incremented. A counter columns can only be created in dedicated table that has only primary key and counter column. All non-counter columns in the table must be defined as part of the primary key.
CREATE TABLE upvote_counter ( id UUID PRIMARY KEY, upvotes counter );
Use UPDATE command to add/update value to a counter table:
UPDATE upvote_counter SET upvotes = upvotes + 1 WHERE id = 495ede98-0060-11e8-ba89-0ed5f89f718b;
See the counter table data:
SELECT * FROM upvote_counter;