Deleting data from future

2020-03-02 Thread Furkan Cifci
Greetings, In our C* cluster, one node lost time sync and it went to future(16 Mar 2020) for a while. After fixing timesync, we couldnt update or delete records which were inserted while node's system time was from the future. Inspecting sstables, we found that timestamp(TS field value) of these r

Re: Deleting data from future

2020-03-02 Thread Jon Haddad
You can issue a delete using a future timestamp. http://cassandra.apache.org/doc/latest/cql/dml.html#grammar-token-update-parameter Look for USING TIMESTAMP. Jon On Mon, Mar 2, 2020, 3:28 AM Furkan Cifci wrote: > Greetings, > In our C* cluster, one node lost time sync and it went to future(16

Re: Deleting data from future

2020-03-03 Thread Erick Ramirez
> > Inspecting sstables, we found that timestamp(TS field value) of these > records was 1584349956844022, Monday, 16 March 2020 09:12:36.844. > We neither delete these records nor truncate table. > Is there anyway to manipulate records inside sstable manually? > Not really unless you plan to wri