In KsqlDB, how can we clear or reset the RocksDB state store?

If I need to clear or reset RockDB state store data every 3 months without drop table, is there any way to do it? in table is simple logic such as sum or count

1 Like

From the Speedb Hive:

RocksDB and Speedb support “delete range” (one operation) the problem is that this is working in the background and may slow down scan. The way I would go is to use a CF for this table and delete & recreate this CF. I am not sure Kafka supports this …

You can find the Speedb hive here and (once you’ve registered) the link to the thread with your question here, if you have more questions or need additional info