News Feed

No results for 'undefined'
Powered by Algolia

How to delete all rows in Cassandra Keyspace


Author: red

Originally Sourced from: https://stackoverflow.com/questions/64135800/how-to-delete-all-rows-in-cassandra-keyspace

I need to delete all rows in Cassandra but with Amazon Keyspace isn't possible to execute TRUNCATE tbl_name because the TRUNCATE api isn't supported yet.

Now the few ideas that come in my mind are a little bit tricky:

Solution A

  • select all the rows
  • cycle all the rows and delete it (one by one or in a batch)

Solution B

  • DROP TABLE
  • CREATE TABLE with the structure of the old table

Do you have any idea to keep the process simplest?

Tnx in advance