Drop all keyspaces in cassandra

cassandra cql3 cqlsh
Rahul Rohilla picture Rahul Rohilla · Dec 26, 2013 · Viewed 9.7k times · Source

How to drop all keyspace in cassandra, I have requirement where I have to delete all keyspaces created by some test scripts.

Thanks

Answer

dkblinux98 picture dkblinux98 · Dec 26, 2013

Are you looking for a method other than drop keyspace?

Okay based on your clarification...

I would say the best way to reset cassandra would be to delete the contents of the <data dir>/data/* <data dir>/commitlog/* <data dir>/saved_caches/*

and then restart the services on the nodes beginning with the seed node and continuing with a 2 minute gap between each node start. That will take the nodes back to a clean state with respect to the data but leave the customizations in cassandra.yaml intact. This would also reset any changes made to the "system" keyspaces at the cqlsh level such as changing a replication factor.

Related questions

How to list column families in keyspace?

How can I get list of all column families in keyspace in Cassandra using CQL 3?

Read More
alter composite primary key in cassandra CQL 3.0

I'm in a situation where I need to change the the composite primary key as follows: Old Primary Key: (id, source, attribute_name, updated_at); New Primary Key I want: (source, id, attribute_name, updated_at); I issued the following (…

Read More
How to copy data from a Cassandra table to another structure for better performance

In several places it's advised to design our Cassandra tables according to the queries we are going to perform on them. In this article by DataScale they state this: The truth is that having many similar tables with similar data …

Read More