archiving - cassandra data purging for time series data based on timestamp column -


i storing time series data in cassandra on daily basis. archive/purge data older 2 days on daily basis. using hector api store data. can 1 suggest me approach delete cassandra data on daily basis data older 2 days? using ttl approach cassandra row not feasible, number of days delete data configurable. right there no timestamp column in table. planning add timestamp column. problem is, timestamp alone cannot used in clause, new column not part of primary key. please provide suggestion.

ttl right answer, there internal timestamp attached every mutation used don't need add one. manually purging never idea. may need work on data model bit, check datastax academy examples time series

also thrift has been frozen 2 years , officially deprecated (removal in 4.0). hector , other thrift clients not maintained anymore (see here). using cql , java driver give better results more resources available learn well.


Comments

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

ios - UITEXTFIELD InputView Uipicker not working in swift -

Python Pig Latin Translator -