[
https://issues.apache.org/jira/browse/CASSANDRA-14089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16275398#comment-16275398
]
Taylor Cressy commented on CASSANDRA-14089:
-------------------------------------------
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
