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

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

python - Receiving "KeyError" after decoding json result from url -

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -