Hello Kevin For the internal working of secondary index and LIMIT, you can have a look at this : https://issues.apache.org/jira/browse/CASSANDRA-5975
The comments and attached patch will give you a hint on how LIMIT is implemented. Alternatively you can look directly in the source code starting from the modified class given in the patch On Fri, May 16, 2014 at 7:53 PM, Kevin Burton <[email protected]> wrote: > I'm struggling with cassandra secondary indexes since the documentation > seems all over the place and I'm having to put together everything from > blog posts. > > Anyway. > > If I have a low cardinality index of say 10 values, and 1M records. This > means each secondary index key will have references to 100,000 rows. > > How does Cassandra page through the rows when using LIMIT and paging by > the reference? Are the row references sorted in the index? > > Thanks! > > -- > > 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. > >
