incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From michael <roya...@yahoo.com>
Subject slow read for cassandra time series
Date Thu, 30 May 2013 05:05:49 GMT
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) }

cassandra blows up with out of memory exception when one's day of data
is only about 1 mb in size.


Mime
View raw message