incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Coli <rc...@eventbrite.com>
Subject Re: Table Creation Error
Date Mon, 02 Dec 2013 20:20:15 GMT
On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews <
charlieandrews.cwa@gmail.com> wrote:

> Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or
> is the keyspace schema separate from the data it describes?
>

Lol, sorry, yes. You will have to restore the data from the automatically
created snapshot.

1) echo "DESCRIBE KEYSPACE <keyspace_name>;" | cqlsh >
keyspace_name.schema.cqlsh
2) DROP KEYSPACE <keyspace_name>;
3) restore keyspace's data from the snapshots created automatically when
you DROP
4) use the contents of keyspace_name.schema.cqlsh to re-create your schema
5) rolling restart of all nodes (or use "nodetool refresh")

=Rob

Mime
View raw message