Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of doanduyhai@gmail.com designates
 209.85.223.182 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAAX2xq6E--2Xkgz1vZW8-9LBg0x5BJ0c-o1Qw3wja0HNthOZvw@mail.gmail.com>
References: 
 <CAAX2xq6E--2Xkgz1vZW8-9LBg0x5BJ0c-o1Qw3wja0HNthOZvw@mail.gmail.com>
Date: Thu, 18 Sep 2014 18:35:55 +0200
Message-ID: 
 <CABNXB2DZ59G5P_0H6NFwE78wTf2bgM+6Rhs+XAYvcZnmZpD_kQ@mail.gmail.com>
Subject: Re: index partition key
From: DuyHai Doan <doanduyhai@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=bcaec51718651736aa05035994b6

--bcaec51718651736aa05035994b6
Content-Type: text/plain; charset=UTF-8

Your query "select * from testcf where key1 > 'Lucas';" does work if you
choose the old OrderPartioner but since it's considered absolute evil (for
good reason, load distribution is horrendous), pratically it is not
possible to do your query.

And it's the same thing with secondary index. Query with inequality on
secondary index translates into full cluster scan...

Regards

 Duy Hai DOAN

On Thu, Sep 18, 2014 at 5:44 PM, Marcelo Elias Del Valle <
marcelo@s1mbi0se.com.br> wrote:

> Hi,
>
> This question is just for curiosity purposes, I don't need this in my
> solution, but it's something I was asking myself...
>
> Is there a way of indexing the partition key values in Cassandra? Does
> anyone needed this and found a solution of any kind?
>
> For example, I know the sample bellow doesn't work, but would it be
> possible somehow?
> I know select * from testcf where token(key1) > token('Lucas'); works, but
> the question is ordering by the values, even using another CF or index of
> any kind...
>
> CREATE KEYSPACE IF NOT EXISTS testks
>   WITH REPLICATION = { 'class' : 'SimpleStrategy',
>   'replication_factor': '1' };
>
>
> CREATE TABLE IF NOT EXISTS testcf (
>   key1 varchar,
>   value varchar,
>   PRIMARY KEY ((key1)));
>
> CREATE INDEX testidx on testks.testcf (key1);
>
> insert into testcf (key1, value) values ('Lucas', 'value1');
> insert into testcf (key1, value) values ('Luiz', 'value2');
> insert into testcf (key1, value) values ('Edu', 'value3');
> insert into testcf (key1, value) values ('Marcelo', 'value4');
>
> select * from testcf order by key1;
> select * from testcf where key1 > 'Lucas';
>
>
> Best regards,
> Marcelo.
>

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

<div dir=3D"ltr"><div><div>Your query &quot;select * from testcf where key1=
 &gt; &#39;Lucas&#39;;&quot; does work if you choose the old OrderPartioner=
 but since it&#39;s considered absolute evil (for good reason, load distrib=
ution is horrendous), pratically it is not possible to do your query.<br><b=
r></div>And it&#39;s the same thing with secondary index. Query with inequa=
lity on secondary index translates into full cluster scan...<br><br></div>R=
egards<br><br>=C2=A0Duy Hai DOAN<br></div><div class=3D"gmail_extra"><br><d=
iv class=3D"gmail_quote">On Thu, Sep 18, 2014 at 5:44 PM, Marcelo Elias Del=
 Valle <span dir=3D"ltr">&lt;<a href=3D"mailto:marcelo@s1mbi0se.com.br" tar=
get=3D"_blank">marcelo@s1mbi0se.com.br</a>&gt;</span> wrote:<br><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></div><div>This question i=
s just for curiosity purposes, I don&#39;t need this in my solution, but it=
&#39;s something I was asking myself...</div><div><br></div><div>Is there a=
 way of indexing the partition key values in Cassandra? Does anyone needed =
this and found a solution of any kind?</div><div><br></div><div>For example=
, I know the sample bellow doesn&#39;t work, but would it be possible someh=
ow?</div><div>I know=C2=A0select * from testcf where token(key1) &gt; token=
(&#39;Lucas&#39;); works, but the question is ordering by the values, even =
using another CF or index of any kind...</div><div><br></div><div><div>CREA=
TE KEYSPACE IF NOT EXISTS testks</div><div>=C2=A0 WITH REPLICATION =3D { &#=
39;class&#39; : &#39;SimpleStrategy&#39;,</div><div>=C2=A0 &#39;replication=
_factor&#39;: &#39;1&#39; };</div><div><br></div><div><br></div><div>CREATE=
 TABLE IF NOT EXISTS testcf (</div><div>=C2=A0 key1 varchar,</div><div>=C2=
=A0 value varchar,</div><div>=C2=A0 PRIMARY KEY ((key1)));</div><div><br></=
div><div>CREATE INDEX testidx on testks.testcf (key1);</div><div><br></div>=
<div>insert into testcf (key1, value) values (&#39;Lucas&#39;, &#39;value1&=
#39;);</div><div>insert into testcf (key1, value) values (&#39;Luiz&#39;, &=
#39;value2&#39;);</div><div>insert into testcf (key1, value) values (&#39;E=
du&#39;, &#39;value3&#39;);</div><div>insert into testcf (key1, value) valu=
es (&#39;Marcelo&#39;, &#39;value4&#39;);</div><div><br></div><div>select *=
 from testcf order by key1;</div><div>select * from testcf where key1 &gt; =
&#39;Lucas&#39;;</div></div><div><br></div><div><br></div><div>Best regards=
,</div><div>Marcelo.</div></div>
</blockquote></div><br></div>

--bcaec51718651736aa05035994b6--