Matthieu Nantern created CASSANDRA-11207:
--------------------------------------------
Summary: Can not remove TTL on table with default_time_to_live
Key: CASSANDRA-11207
URL: https://issues.apache.org/jira/browse/CASSANDRA-11207
Project: Cassandra
Issue Type: Bug
Reporter: Matthieu Nantern
I've created a table with a default TTL:
{code:sql}
CREATE TABLE testmna.ndr (
device_id text,
event_year text,
event_time timestamp,
active boolean,
PRIMARY KEY ((device_id, event_year), event_time)
) WITH CLUSTERING ORDER BY (event_time DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 600
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
{code}
When I insert data with a "runtime TTL" (INSERT ... USING TTL 86400) everything
works as expected (ttl is set to 86400).
But I can't insert data without TTL at runtime: INSERT ... USING TTL 0; does
not work.
Tested on C* 2.2.4, CentOS 7
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
