# In KsqlDB, how can we clear or reset the RocksDB state store?
**URL:** https://forum.confluent.io/t/in-ksqldb-how-can-we-clear-or-reset-the-rocksdb-state-store/9013
**Category:** ksqlDB
**Created:** [7 November 2023 10:29 UTC](https://forum.confluent.io/t/in-ksqldb-how-can-we-clear-or-reset-the-rocksdb-state-store/9013 "2023-11-07T10:29:11Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@patharapon](https://forum.confluent.io/u/patharapon)
#### Post date: [7 November 2023 10:29 UTC](https://forum.confluent.io/t/in-ksqldb-how-can-we-clear-or-reset-the-rocksdb-state-store/9013/1 "2023-11-07T10:29:11Z")
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
---
### Author:  [@Dan-SPDB](https://forum.confluent.io/u/Dan-SPDB)
#### Post date: [8 November 2023 08:33 UTC](https://forum.confluent.io/t/in-ksqldb-how-can-we-clear-or-reset-the-rocksdb-state-store/9013/2 "2023-11-08T08:33:12Z")
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](https://discord.gg/72MRDXYTV8) and (once you’ve registered) the link to the thread with your question [here](https://discord.com/channels/1001437353312796782/1171666257733488662), if you have more questions or need additional info
---
### Author:  [@system](https://forum.confluent.io/u/system)
#### Post date: [7 December 2023 10:29 UTC](https://forum.confluent.io/t/in-ksqldb-how-can-we-clear-or-reset-the-rocksdb-state-store/9013/3 "2023-12-07T10:29:43Z")
This topic was automatically closed after 30 days. New replies are no longer allowed.