RE: Mapping a continuous range to a discrete value

Thanks for responding. I was able to hack it out eventually. I removed the ‘upper’ column from the PK so it is no longer a clustering column, and I added a secondary index over it. This assumes there is no overlap in the a continuous ranges. I had to add a ‘dummy’ column with a constant value to

Re: 1, 2, 3...

Looks like this guy (Brian Hess) wrote a script to split the token range and run count(*) on each subrange: https://github.com/brianmhess/cassandra-count - Max > On Apr 8, 2016, at 10:56 pm, Jeff Jirsa wrote: > > SELECT COUNT(*) probably works

Re: disable compaction if all data are read-only?

Thanks for all replies and Date Tiered strategy sounds good to me. I am still using 2.0x version and will consider updating to latest version. On Fri, Apr 8, 2016 at 11:20 PM, Eric Stevens wrote: > Append-only workloads are a good candidate for Date Tiered or better Time > Windowed compaction.