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?
>
>
>
>
>

Reply via email to