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.
>
>

Reply via email to