I think if you use Level compaction, the number of sstables you will touch will be less because sstables in each level is non overlapping except L0.

On Wed, Mar 27, 2013 at 8:20 PM, aaron morton <aaron@thelastpickle.com> wrote:
sstablekey can help you find which sstables your keys are in. 

But yes, a slice call will need to read from all sstables the row has a fragment in. This is one reason we normally suggest partitioning time series data by month or year or something sensible in your problem domain. 

You will probably also want to use reversed comparators so you do not have to use reversed in your query. 

Hope that helps. 

Aaron Morton
Freelance Cassandra Consultant
New Zealand


On 28/03/2013, at 8:25 AM, Bryan Talbot <btalbot@aeriagames.com> wrote:

In the worst case, that is possible, but compaction strategies try to minimize the number of SSTables that a row appears in so a row being in ALL SStables is not likely for most cases.


On Wed, Mar 27, 2013 at 12:17 PM, Kanwar Sangha <kanwar@mavenir.com> wrote:

Hi – I have a query on Read with Cassandra. We are planning to have dynamic column family and each column would be on based a timeseries.


Inserting data — key => ‘xxxxxxx′, {column_name => TimeUUID(now), :column_value => ‘value’ }, {column_name => TimeUUID(now), :column_value => ‘value’ },…………..


Now this key might be spread across multiple SSTables over a period of days. When we do a READ query to fetch say a slice of data from this row based on time X->Y , would it need to get data from ALL sstables ?