Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

Thanks a lot guys! On Tue, May 9, 2017 at 7:32 AM, Alexander Dejanovski wrote: > Hi Kant, > > Unless you provide the full partition key, I see no way for Cassandra to > avoid doing a full table scan. > In order to know on which specific nodes to search (and in which sstables > ,etc...) it needs

Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

Hi Kant, Unless you provide the full partition key, I see no way for Cassandra to avoid doing a full table scan. In order to know on which specific nodes to search (and in which sstables ,etc...) it needs to have a token. The token is a hash of the whole partition key. For a specific value of colu

Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

Output from both queries, demonstrating full cluster scans: https://gist.github.com/rustyrazorblade/c4947fc37da85bca50e08aa1ef3c7a06 Jon > On May 9, 2017, at 9:24 AM, Jon Haddad wrote: > > Nope, I didn’t comment on tha

Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

Nope, I didn’t comment on that query. I specifically answered your question about "select * from hello where a='foo' allow filtering;” The query you’ve listed here looks like it would also do a full table scan (again, I don’t see how it would be avoided). I recommend firing up a 3 node cluste

Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

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 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 wrote: > > > > Hi All, > >

Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?

I don’t see any way it wouldn’t. Have you tried tracing it? > On May 9, 2017, at 8:32 AM, Kant Kodali 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 te