Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jens.rantil@tink.se
 designates 209.85.215.53 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAFKmhPuZVQRTFOEqo=_pWoF2XLS0-rN_Xd43MR9EGvqf-7EriA@mail.gmail.com>
References: 
 <CAL+ArfXEgygnG6Mk_e3LWp1FSQ9A83-ENVcm26K-PKSV4wmXmA@mail.gmail.com>
 <CAFKmhPuZVQRTFOEqo=_pWoF2XLS0-rN_Xd43MR9EGvqf-7EriA@mail.gmail.com>
From: Jens Rantil <jens.rantil@tink.se>
Date: Wed, 6 Aug 2014 09:41:06 +0200
Message-ID: 
 <CAL+ArfUrjZ7woeENQ4hojaLXguGSVXUbN0Xvm_Er8xbYLNFpCA@mail.gmail.com>
Subject: Re: Issue with ALLOW FILTERING
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11340764776dc604fff119d7

--001a11340764776dc604fff119d7
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi S=C3=A1vio,

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=C3=A1vio 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=C3=A1vio S. Teles de Oliveira
> voice: +55 62 9136 6996
> http://br.linkedin.com/in/savioteles
>  Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG
> Arquiteto de Software
> CUIA Internet Brasil
>

--001a11340764776dc604fff119d7
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi S=C3=A1vio,<div><br></div><div>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&#39;m struggling to =
see any reason for it not being supported.</div>

<div><br></div><div>Also, I don&#39;t believe the CQL specification makes i=
t entirely clear that only secondary indexes are supported. Or is it consid=
ered implementation specific under what circumstances ALLOW FILTERING can b=
e used?</div>

<div><br></div><div>Thanks,</div><div>Jens</div></div><div class=3D"gmail_e=
xtra"><br><br><div class=3D"gmail_quote">On Tue, Aug 5, 2014 at 8:11 PM, S=
=C3=A1vio S. Teles de Oliveira <span dir=3D"ltr">&lt;<a href=3D"mailto:savi=
o.teles@cuia.com.br" target=3D"_blank">savio.teles@cuia.com.br</a>&gt;</spa=
n> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">You need to create an index=
 on attribute <b>c.</b></div><div class=3D"gmail_extra"><br><br><div class=
=3D"gmail_quote">

2014-08-05 9:24 GMT-03:00 Jens Rantil <span dir=3D"ltr">&lt;<a href=3D"mail=
to:jens.rantil@tink.se" target=3D"_blank">jens.rantil@tink.se</a>&gt;</span=
>:<div><div class=3D"h5"><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></div><div>I=
9;m having an issue with ALLOW FILTERING with Cassandra 2.0.8. See a minima=
l example here: <a href=3D"https://gist.github.com/JensRantil/ec43622c26acb=
56e5bc9" target=3D"_blank">https://gist.github.com/JensRantil/ec43622c26acb=
56e5bc9</a></div>


<div><br></div><div>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 selec=
t using the clustering primary id and then do filtering.</div><div><br>


</div><div>I&#39;ve been reading=C2=A0<a href=3D"https://cassandra.apache.o=
rg/doc/cql3/CQL.html#selectStmt" target=3D"_blank">https://cassandra.apache=
.org/doc/cql3/CQL.html#selectStmt</a> &quot;ALLOW FILTERING&quot; and can&#=
39;t wrap my head around why this won&#39;t work.</div>


<div><br></div><div>Could anyone clarify this for me?</div><div><br></div><=
div>Thanks,</div><div>Jens</div></div>
</blockquote></div></div></div><span class=3D"HOEnZb"><font color=3D"#88888=
8"><br><br clear=3D"all"><div><br></div>-- <br><font color=3D"#888888">Aten=
ciosamente,<br>S=C3=A1vio S. Teles de Oliveira<br><div>voice: <a href=3D"te=
l:%2B55%2062%209136%206996" value=3D"+556291366996" target=3D"_blank">+55 6=
2 9136 6996</a><br>

<a href=3D"http://br.linkedin.com/in/savioteles" target=3D"_blank">http://b=
r.linkedin.com/in/savioteles</a><br>
<div>

Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG <br>Arquiteto de S=
oftware<br></div><div><div>CUIA Internet Brasil<br></div></div></div></font=
>
</font></span></div>
</blockquote></div><br></div>

--001a11340764776dc604fff119d7--