Re: slow read for cassandra time series

2013-05-30 Thread Sylvain Lebresne
> I have a slow query that is making me think I don't understand the data model for > time series: > select asset, returns from marketData where date >= 20130101 and date <= 20130110 > allow filtering; > > create table marketData { > asset varchar, > returns double, > date timestamp, > PRIMARY KEY(

slow read for cassandra time series

2013-05-29 Thread michael
I have a slow query that is making me think I don't understand the data model for time series: select asset, returns from marketData where date >= 20130101 and date <= 20130110 allow filtering; create table marketData { asset varchar, returns double, date timestamp, PRIMARY KEY(asset, date) }