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
Post a Comment