[CASSANDRA-8678] CREATE TABLE accepts value for default_time_to_live on counter table

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.13, 2.1.3
• Component/s: Legacy/Tools
• Assignee: Jeff Jirsa
• Reporter: Aaron Ploetz

Authors

Jeff Jirsa

Reviewers

Tom Hobbs

• Created: 24/Jan/15 17:21
• Updated: 16/Apr/19 09:31
• Resolved: 30/Jan/15 22:43

Description

I can create a counter table (via cqlsh) with a default_time_to_live:

CREATE TABLE IF NOT EXISTS metrics2(
time timestamp,
value counter,
PRIMARY KEY ((time))
) WITH default_time_to_live=10;

Upsert a row that increments the counter:

UPDATE metrics2 SET value=value+1 WHERE timestamp='2015-01-24 10:48 -0600';

Wait 10 seconds, and select, and the row is (of course) still there. There should probably be a warning or error preventing the creation of a table that has both counter columns and a value set for default_time_to_live.