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 <furkanci...@gmail.com> wrote: > 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 > 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? > > > > >