News Feed

No results for 'undefined'
Powered by Algolia

How to delete all rows in Cassandra Keyspace

Author: red

Originally Sourced from:

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

  • CREATE TABLE with the structure of the old table

Do you have any idea to keep the process simplest?

Tnx in advance