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

This topic was automatically closed after 30 days. New replies are no longer allowed.