You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by joseph gao <ga...@gmail.com> on 2016/11/24 08:00:40 UTC
how to effectively drop table
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
Re: how to effectively drop table
Posted by joseph gao <ga...@gmail.com>.
OK! I'll drop keyspaces. Thanks
2016-11-24 19:14 GMT+08:00 Vladimir Yudovin <vl...@winguzone.com>:
> Actually you shouldn't drop tables prior to dropping keyspace. Just drop
> keyspace with all its tables.
>
> Best regards, Vladimir Yudovin,
> *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting*
>
>
> ---- On Thu, 24 Nov 2016 05:38:36 -0500*joseph gao
> <gaojf.bokecc@gmail.com <ga...@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 <vl...@winguzone.com>:
>
>
> Hi,
>
> Is DROP whole keyspace an option?
>
> Best regards, Vladimir Yudovin,
> *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting*
>
>
> ---- On Thu, 24 Nov 2016 03:00:40 -0500*joseph gao
> <gaojf.bokecc@gmail.com <ga...@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
>
>
--
------
Joseph Gao
PhoneNum:15210513582
QQ: 409343351
Re: how to effectively drop table
Posted by Vladimir Yudovin <vl...@winguzone.com>.
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.bokecc@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 <vladyu@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.bokecc@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
Re: how to effectively drop table
Posted by joseph gao <ga...@gmail.com>.
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 <vl...@winguzone.com>:
> Hi,
>
> Is DROP whole keyspace an option?
>
> Best regards, Vladimir Yudovin,
> *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting*
>
>
> ---- On Thu, 24 Nov 2016 03:00:40 -0500*joseph gao
> <gaojf.bokecc@gmail.com <ga...@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
Re: how to effectively drop table
Posted by Vladimir Yudovin <vl...@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.bokecc@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