Re: how to effectively drop table

2016-11-29 Thread joseph gao
OK! I'll drop keyspaces. Thanks 2016-11-24 19:14 GMT+08:00 Vladimir Yudovin : > Actually you shouldn't drop tables prior to dropping keyspace. Just drop > keyspace with all its tables. > > Best regards, Vladimir Yudovin, > *Winguzone -

Re: how to effectively drop table

2016-11-24 Thread Vladimir Yudovin
Actually you shouldn't drop tables prior to dropping keyspace. Just drop keyspace with all its tables. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 05:38:36 -0500joseph gao gaojf.bok...@gmail.com wrote Hi,Vladimir, I have

Re: how to effectively drop table

2016-11-24 Thread joseph gao
Hi,Vladimir, I have to do the whole stuff in 2 step. DROP whole keyspace works in step2. But in step 1, I have to drop 2000 tables。 All I could wait and skip step 1 and do all jobs in step 2. Anyway, thanks very much! 2016-11-24 16:25 GMT+08:00 Vladimir Yudovin : >

Re: how to effectively drop table

2016-11-24 Thread Vladimir Yudovin
Hi, Is DROP whole keyspace an option? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 03:00:40 -0500joseph gao gaojf.bok...@gmail.com wrote Hi, all I've had a very bad system design before. This caused about 1 tables in

how to effectively drop table

2016-11-24 Thread joseph gao
Hi, all I've had a very bad system design before. This caused about 1 tables in my cassandra cluster, and the cluster is very unstable. Now I want to redesign the system, but it's so suffering to drop the former tables. Dropping a table may cost 30 seconds or even worse(170s) using cqlsh