cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hiller, Dean" <>
Subject Re: Simple data model for 1 simple range query?
Date Wed, 03 Oct 2012 20:04:43 GMT
Is timeframe/date your composite key? Where timeframe is the first time of a partition of time
(ie. If you partition by month, it is the very first time of that month).  If so, then, yes,
it will be very fast.  The smaller your partitions are, the smaller your indexes are as well(ie.
B-trees which you can grow pretty big).  Realize you always have to have timeframe with equals(=)
NOT >, <,<=,>= but  the other columns you can use the other operators.

Also, if you ever find a need to partition the same data twice, you can always look into PlayOrm
with multi-partitioning and it's Scalable SQL which can do joins when necessary.


From: T Akhayo <<>>
Reply-To: "<>" <<>>
Date: Wednesday, October 3, 2012 1:00 PM
To: "<>" <<>>
Subject: Simple data model for 1 simple range query?

Good evening,

I have a quite simple data model. Pseudo CQL code:

create table bars(
timeframe int,
date Date,
info1 double,
info2 double,
primary key( timeframe, date )

My most important query is (which might be the only one actually):
select * from bars where timeframe=X and date>Y and date <Z

I came to this model because i did read in the past (when 0.7 came out) was very fast at range
queries (using a slice method) when the fields were keys. And now with cql all the nasty details
are hidden ( i have not tested this yet ;-) )

Is it correct that the above model is a good and fast solution for my query?

Kind regards.

View raw message