cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Haddad <jonathan.had...@gmail.com>
Subject Re: Cassandra 3.10 has partial partition key search but does it result in a table scan?
Date Tue, 09 May 2017 13:33:47 GMT
I don’t see any way it wouldn’t.  Have you tried tracing it?

> On May 9, 2017, at 8:32 AM, Kant Kodali <kant@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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org


Mime
View raw message