[jira] [Commented] (CASSANDRA-11601) Add ability to remove TTL on table

["Danyang Li (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-11601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15247163#comment-15247163 ] 

Danyang Li commented on CASSANDRA-11601:
----------------------------------------

I created a tool to do batch TTL removing. If any interest.

> Add ability to remove TTL on table
> ----------------------------------
>
>                 Key: CASSANDRA-11601
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11601
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Danyang Li
>            Priority: Minor
>             Fix For: 2.2.x
>
>
> If tables are TTLed in your Cassandra and you try to backup the corresponding SSTable to a new cluster, your backup will be lost automatically after a certain period of time, because TTL are still expiring data in the backup SStable. Once the TTL elapsed, data become inaccessible and finally will be deleted physically by compaction after GCGraceSecondes. So we cannot really keep the backup data in a new cluster without removing these existing TTL. 
> So it might be good to add ability to do batch TTL removing. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)