There is one table (or called column family) in Cassandra. I want to know how many records of this table were inserted or updated since a given timestamp. How to do it?
Asked
Active
Viewed 2,020 times
2
-
You could add columns for created/updated timestamps. – approxiblue Aug 24 '15 at 05:28
-
um...yeah, but this is an existing table. And want to know the recent insertion/update history. So, add one more column is a little late now. – Finix Aug 24 '15 at 06:01
-
add new columns and use your code to update the new columns with the value of writetime of your primary key (writetime(column) function) – Aravind Chamakura Aug 25 '15 at 05:04
1 Answers
2
Your best option is to try writetime(column_name). That way you will get the write times of particular columns. You won't get, however, write times of already deleted columns. It's far from what you want, but that's the only possibility.
piotrwest
- 2,098
- 23
- 35