The specific issue is I have a fairly large table, which is immutable, and I need to get it in a form where it can be downloaded, page by page, via an API.
This would involve reading the whole table. I'd like to page through it by key order to efficiently read the rows to minimize random reads. It's slightly more complicated then that in that it's a log structured table… basically holding the equivalent of apache logs.. I need to read these out by time and give them to API callers. On Fri, May 30, 2014 at 12:21 AM, DuyHai Doan <doanduy...@gmail.com> wrote: > Hello Kevin > > Can you be more specific on the issue you're facing ? What is the table > design ? What kind of query are you doing ? > > Regards > > > On Fri, May 30, 2014 at 7:10 AM, Kevin Burton <bur...@spinn3r.com> wrote: > >> I'm trying to grok this but I can't figure it out in CQL world. >> >> I'd like to efficiently page through a table via primary key. >> >> This way I only involve one node at a time and the reads on disk are >> contiguous. >> >> I would have assumed it was a combination of > pk and order by but that >> doesn't seem to work. >> >> -- >> >> Founder/CEO Spinn3r.com >> Location: *San Francisco, CA* >> Skype: *burtonator* >> blog: http://burtonator.wordpress.com >> … or check out my Google+ profile >> <https://plus.google.com/102718274791889610666/posts> >> <http://spinn3r.com> >> War is peace. Freedom is slavery. Ignorance is strength. Corporations are >> people. >> >> > -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* Skype: *burtonator* blog: http://burtonator.wordpress.com … or check out my Google+ profile <https://plus.google.com/102718274791889610666/posts> <http://spinn3r.com> War is peace. Freedom is slavery. Ignorance is strength. Corporations are people.
