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 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 <vla...@winguzone.com>: 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 10000 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 or driver client. So is there an effectively way to drop these unused table ? Thanks very much. -- ------ Joseph Gao PhoneNum:18136950721 QQ: 409343351 -- ------ Joseph Gao PhoneNum:15210513582 QQ: 409343351