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 savio.teles@cuia.com.br
 designates 209.85.220.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAL+ArfXEgygnG6Mk_e3LWp1FSQ9A83-ENVcm26K-PKSV4wmXmA@mail.gmail.com>
References: 
 <CAL+ArfXEgygnG6Mk_e3LWp1FSQ9A83-ENVcm26K-PKSV4wmXmA@mail.gmail.com>
Date: Tue, 5 Aug 2014 15:11:47 -0300
Message-ID: 
 <CAFKmhPuZVQRTFOEqo=_pWoF2XLS0-rN_Xd43MR9EGvqf-7EriA@mail.gmail.com>
Subject: Re: Issue with ALLOW FILTERING
From: =?UTF-8?Q?S=C3=A1vio_S=2E_Teles_de_Oliveira?= <savio.teles@cuia.com.br>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a1133f016f9d47f04ffe5c9a9

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

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
>


--=20
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

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

<div dir=3D"ltr">You need to create an index on attribute <b>c.</b></div><d=
iv 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"mailto:jens.rantil@=
tink.se" target=3D"_blank">jens.rantil@tink.se</a>&gt;</span>:<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><br><br clear=3D"all"><div><br></div>-- <br><font color=
=3D"#888888">Atenciosamente,<br>S=C3=A1vio S. Teles de Oliveira<br><div>voi=
ce: +55 62 9136 6996<br><a href=3D"http://br.linkedin.com/in/savioteles" ta=
rget=3D"_blank">http://br.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=
>
</div>

--001a1133f016f9d47f04ffe5c9a9--