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.
-Bryan On Wed, Mar 27, 2013 at 12:17 PM, Kanwar Sangha <kan...@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 ? **** > > ** ** > > Thanks,**** > > Kanwar**** > > ** ** >