incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From E S <>
Subject Efficienct RangeSlice of SuperColumn and Columns in one call
Date Wed, 17 Nov 2010 02:21:46 GMT
I am going to have a supercolumn family where some rows can be quite large 
(10-100 mb).  I'd like to be able to pull a subset of this data without having 
to pull the whole thing into memory and send it over the wire.

Each query will be for only one row.  The supercolumn key and the child column 
keys are going to be dates.  I want to query:

"For row 123, give me all the column values whose date are between 1/1/2000 and 
1/1/2005 for the first supercolumn whose date is before 1/1/2009."

Since super columns and columns are sorted by date, it seems like it should be 
pretty efficient to do this in 1 query, but I can't figure out how to do this in 
the API.  If I knew the super column name, I could do a slicerange for the key 
with the target supercolumn as parent on a range of dates (1/1/2000-1/1/2005), 
but I only know that I want the first supercolumn before a date.

Thanks for any help!


View raw message