How do you update gc_grace_seconds using cassandra-cli?

Question

What is the command to update a column family and alter its gc_grace_seconds value using cassandra-cli?

score 35 · Answer 1 · answered Feb 26 '14 at 02:56

35

For CQLSH

alter table <table_name> with GC_GRACE_SECONDS = <timeout>;

e.g:

alter table yawn with GC_GRACE_SECONDS = 3600;

where yawn is our table name and 3600 is an hour;

answered Feb 26 '14 at 02:56

1

CLI approach doesn't work, we get an error message to use CQLSH now, hence this answer. Cassandra 2.0. HTH – Ravindranath Akila Feb 26 '14 at 02:57
Please check the value of max_hint_window_in_ms if the hinted_handoff is enabled – S.Bao Aug 13 '20 at 11:52
1

This is the correct solution even on Cassandra 3.11. – lapo Oct 05 '21 at 06:49

score 11 · Accepted Answer · edited Apr 30 '14 at 12:19

11

On cassandra-cli is without "seconds"

UPDATE COLUMN FAMILY cf with GC_GRACE = 86400; //one day

edited Apr 30 '14 at 12:19

Adrian Frühwirth

answered Nov 20 '13 at 13:46

Christian Agrazar

i updated my columnfamily as above to delete the rowkey, but rowkey remains same – Jan 15 '14 at 06:54

score 1 · Answer 3 · answered Mar 20 '13 at 21:46

1

use ks;
update column family cf with gc_grace_seconds = 864000;

answered Mar 20 '13 at 21:46

Richard

it giving this java.lang.IllegalArgumentException: No enum constant org.apache.cassandra.cli.CliClient.ColumnFamilyArgument.GC_GRACE_SECONDS – Jan 15 '14 at 06:57
See the accepted answer, it's meant to be gc_grace not gc_grace_seconds. – Richard Jan 15 '14 at 15:40

3 Answers3