If you have to allow filtering for the query to work it usually always results in a table scan.
greetings Daniel On Tue, 9 May 2017 at 15:33 Jon Haddad <jonathan.had...@gmail.com> wrote: > I don’t see any way it wouldn’t. Have you tried tracing it? > > > On May 9, 2017, at 8:32 AM, Kant Kodali <k...@peernova.com> wrote: > > > > Hi All, > > > > It looks like Cassandra 3.10 has partial partition key search but does > it result in a table scan? for example I can have the following > > > > create table hello( > > a text, > > b int, > > c text, > > d text, > > primary key((a,b), c) > > ); > > > > Now I can do select * from hello where a='foo' allow filtering;// This > works in 3.10 but I wonder if this query results in table scan and if so is > there any way to limit such that I get max b? > > > > Thanks! > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > >
