[jira] [Created] (CASSANDRA-14089) Time Window Compaction Strategy: Determine window by column value

["Taylor Cressy (JIRA)" <ji...@apache.org>]

Taylor Cressy created CASSANDRA-14089:
-----------------------------------------

             Summary: Time Window Compaction Strategy: Determine window by column value
                 Key: CASSANDRA-14089
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14089
             Project: Cassandra
          Issue Type: New Feature
            Reporter: Taylor Cressy


Recently, we came across an issue where we needed to repartition a column family and alter it's compaction strategy to TWCS. 

We wanted to ensure that the time series data was bucketized properly into it's appropriate window when we migrate data from the old CF to the new one. However, there appears to be no simple way to do this unless we:

1) Set the time window to some arbitrary length
2) Backload a chunk of the data within that time window 
3) After all chunks backload, reset the time window to the desired size

I propose that we allow TWCS to have the ability to key off a column value for placing it in a window. 

Also, maybe we can adjust the TTL accordingly - based on that column value, upon insert - considering TTLs and TWCS are generally based on some form of business logic. Of course, the user could calculate the TTL on the fly, but it could be a nice feature.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org