Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 1 Mar 2016 16:50:18 +0000 (UTC)
From: "Benjamin Lerer (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12941157.1456171235000.184230.1456851018103@Atlassian.JIRA>
In-Reply-To: <JIRA.12941157.1456171235000@Atlassian.JIRA>
References: <JIRA.12941157.1456171235000@Atlassian.JIRA>
 <JIRA.12941157.1456171235594@arcas>
Subject: [jira] [Updated] (CASSANDRA-11207) Can not remove TTL on table with
 default_time_to_live
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-11207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin Lerer updated CASSANDRA-11207:
---------------------------------------
    Fix Version/s: 3.x
      Component/s: CQL
       Issue Type: Improvement  (was: Bug)

> 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: Improvement
>          Components: CQL
>            Reporter: Matthieu Nantern
>            Assignee: Benjamin Lerer
>             Fix For: 3.x
>
>
> 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)