CODEWITHSUNDEEP
transactionscassandratimestamp
Housekl
Housekl

Reputation: 31

how to check if a value is modified from the last time (UPDATE -INSERT) in Cassandra

if UPDATE USING Timestamp is the answer, then how does it work? How can I get the current timestamp value to know if has been modified or not?

Upvotes: 1

Views: 61

Answers (1)

Chris Lohfink
Chris Lohfink

Reputation: 16400

You can use writetime() function to get timestamp of when a cell was written.

INSERT INTO excelsior.clicks (userid, url, date, name)
  VALUES (
    cfd66ccc-d857-4e90-b1e5-df98a3d40cd6,
    'http://google.com',
    '2013-10-11', 'Bob'
);

SELECT url, date, name, WRITETIME(name) FROM excelsior.clicks
  WHERE userid = cfd66ccc-d857-4e90-b1e5-df98a3d40cd6;

Upvotes: 2

Related Questions