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
012 7:23 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Selecting rows efficiently from a Cassandra CF containing time series data I would like to get some opinions on how to select an incremental range of rows efficiently