table-popular-count

cql

BEGIN COUNTER BATCH

  UPDATE cycling.popular_count
  SET popularity = popularity + 1
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

  UPDATE cycling.popular_count
  SET popularity = popularity + 125
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

  UPDATE cycling.popular_count
  SET popularity = popularity - 64
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

APPLY BATCH;

cql

SELECT * FROM cycling.popular_count;

cql

CREATE TABLE IF NOT EXISTS cycling.popular_count (
  id UUID PRIMARY KEY,
  popularity counter
);

cql

DESCRIBE TABLE cycling.popular_count;

cql

DROP TABLE IF EXISTS cycling.popular_count;

cql

UPDATE cycling.popular_count SET popularity = popularity + 2
  WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;

Was this helpful?

Give Feedback