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!