incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hiller, Dean" <Dean.Hil...@nrel.gov>
Subject Re: Selecting rows efficiently from a Cassandra CF containing time series data
Date Tue, 11 Dec 2012 18:20:26 GMT
Wide rows does not work well if you start getting past 10,000,000 columns though so be very
very careful there.  PlayOrm does some wide row indices for us and each row length is as large
as the number of rows in a partition so without playorm you could do partitioning yourself
by the way….It's as simple as store every row and add to the partitions index.

Later,
Dean


From: Andrey Ilinykh <ailinykh@gmail.com<mailto:ailinykh@gmail.com>>
Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <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>" <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 you have naturally
sorted data. You can easily select any time range without any indexes.

Mime
View raw message