Re: Selecting rows efficiently from a Cassandra CF containing time series data

2012-12-11 Thread aaron morton
r@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.org>> > Date: Tuesday, December 11, 2012 10:45 AM > To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" > mailto:user@cassandra.apache.org>> > S

Re: Selecting rows efficiently from a Cassandra CF containing time series data

2012-12-11 Thread Hiller, Dean
ember 11, 2012 10:45 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Selecting rows efficiently from a Cassandra CF containing time series data would consider to use wide rows. If you add timestamp to your column name

Re: Selecting rows efficiently from a Cassandra CF containing time series data

2012-12-11 Thread Andrey Ilinykh
I would consider to use wide rows. If you add timestamp to your column name you have naturally sorted data. You can easily select any time range without any indexes. Thank you, Andrey On Tue, Dec 11, 2012 at 6:23 AM, Chin Ko wrote: > I would like to get some opinions on how to select an incr

Re: Selecting rows efficiently from a Cassandra CF containing time series data

2012-12-11 Thread Hiller, Dean
We use PlayOrm to do something similar We have an object like this(typing all this from memory)…. TimeSeries { @NoSqlPartitionedByField private long beginOfMonth; @NoSqlIndexed Private long timestamp; } Then we just use the ScalableSQL to query into the partition itself. This is