[ https://issues.apache.org/jira/browse/CASSANDRA-14089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16275398#comment-16275398 ]
Taylor Cressy edited comment on CASSANDRA-14089 at 12/2/17 3:53 AM: -------------------------------------------------------------------- Thanks for the info. I initially opened the ticket out of recommendations from some folks in the community only to find out that this is possible with `USING TIMESTAMP`. was (Author: tcressy): Thanks for the info. I initially opened the ticket out of the recommendation from some folks in the community only to find out that this is possible with `USING TIMESTAMP`. > 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-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org