cql - Find upserted keys in Cassandra columnfamily within time interval -
Is it possible to get a list of the affected keys within the Casandra column family within a time interval? Sisandra maintains column level timestamps. Can it be leveraged in some way?
I have a simple column (key, value) and I want to know which key was updated / inserted in the last one day. Unfortunately, I can not modify the column family to include timestamp columns and indexes, as is usually recommended. Does anyone have any other ideas / hacks that can solve this problem?
If you want to modify the table that you have to scan the cluster across the table. CQL 3 and later you can write
SELECT key, value, WRITETIME (value) from kvtable; This is the only way and it is very hard for the cluster.
HTH, Carlo
Comments
Post a Comment