Re: How does clustering key works with TimeWindowCompactionStrategy (TWCS)

2017-04-07 Thread Jerry Lam
how the LIMIT clause works and why it > doesn’t (until 3.4) work the way you think it would. > > http://thelastpickle.com/blog/2017/03/07/The-limit-clause- > in-cassandra-might-not-work-as-you-think.html > > On Apr 7, 2017, at 7:23 AM, Jerry Lam wrote: > > Hi Jan, > >

Re: How does clustering key works with TimeWindowCompactionStrategy (TWCS)

2017-04-07 Thread Jerry Lam
_id is > insertet every hour you can end up with reading many sstables decreasing > read performance if the data should be kept a year or so. > > > > Jan > > > > Gesendet von meinem Windows 10 Phone > > > > *Von: *Jerry Lam > *Gesendet: *Frei

How does clustering key works with TimeWindowCompactionStrategy (TWCS)

2017-04-06 Thread Jerry Lam
Hi guys, I'm a new and happy user of Cassandra. We are using Cassandra for time series data so we choose TWCS because of its predictability and its ease of configuration. My question is we have a table with the following schema: CREATE TABLE IF NOT EXISTS customer_view ( customer_id bigint, date