Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is recreating table/ keyspace with same name in Cassandra not good?

Tags:

cassandra

I was going to a blog by Datastax which says it is not recommended to recreate table with same name. That is drop the table and create with the same name. Here is the link for Datastax recreate table faq. It talks about jira ticket CASSANDRA-5202. It was fixed in 2.1.

I have questions, I am on Cassandra 2.1.16

  1. Is it safe to recreate table or keyspace with same name after dropping?
  2. What precautions we must take if we recreate table or keyspace with same name?
like image 840
Manish Khandelwal Avatar asked Nov 17 '25 23:11

Manish Khandelwal


1 Answers

I wrote that post 6 years ago. :)

As it clearly states, the problem existed in older versions of Cassandra. In C* 2.1 (and newer), a table ID (time UUID) is added to the table directory name on disk to prevent the problems I outlined in that post (CASSANDRA-5202). Cheers!

like image 164
Erick Ramirez Avatar answered Nov 21 '25 07:11

Erick Ramirez