incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jens Rantil <jens.ran...@tink.se>
Subject Re: Issue with ALLOW FILTERING
Date Wed, 06 Aug 2014 07:41:06 GMT
Hi Sávio,

I am really surprised by this. Could anyone explain why ALLOW FILTERING
only is allowed when using secondary index and not together with a PRIMARY
KEY? I'm struggling to see any reason for it not being supported.

Also, I don't believe the CQL specification makes it entirely clear that
only secondary indexes are supported. Or is it considered implementation
specific under what circumstances ALLOW FILTERING can be used?

Thanks,
Jens


On Tue, Aug 5, 2014 at 8:11 PM, Sávio S. Teles de Oliveira <
savio.teles@cuia.com.br> wrote:

> You need to create an index on attribute *c.*
>
>
> 2014-08-05 9:24 GMT-03:00 Jens Rantil <jens.rantil@tink.se>:
>
> Hi,
>>
>> I'm having an issue with ALLOW FILTERING with Cassandra 2.0.8. See a
>> minimal example here:
>> https://gist.github.com/JensRantil/ec43622c26acb56e5bc9
>>
>> I expect the second last to fail, but the last query to return a single
>> row. In particular I expect the last SELECT to first select using the
>> clustering primary id and then do filtering.
>>
>> I've been reading
>> https://cassandra.apache.org/doc/cql3/CQL.html#selectStmt "ALLOW
>> FILTERING" and can't wrap my head around why this won't work.
>>
>> Could anyone clarify this for me?
>>
>> Thanks,
>> Jens
>>
>
>
>
> --
> Atenciosamente,
> Sávio S. Teles de Oliveira
> voice: +55 62 9136 6996
> http://br.linkedin.com/in/savioteles
>  Mestrando em Ciências da Computação - UFG
> Arquiteto de Software
> CUIA Internet Brasil
>

Mime
View raw message