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 petr.odut@gmail.com
 designates 209.85.216.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=Ype2UMIzVvIJatcZe7LoGP7MqBpCO2ieH8oefSiTolOAjmx4Eo840LXZuubWbCAlQm
         8Txziold/hWjBxm8ftujwjcDjY/N05YBSnroa7unHcIsrlGIKAvXi4r7vzbrC7YAdKi+
         wH2nHR1A4QMbsQlahXpbeWMRoLo0TdxRlt9I8=
MIME-Version: 1.0
In-Reply-To: <AANLkTik+0BW3Rv3-YAaoX+WyUaa9NHUPXVuqvETAfiCe@mail.gmail.com>
References: <AANLkTinHDhUU1cGc4jUVeTBBN1ofVoScHGgtSnmP53Vr@mail.gmail.com>
	<AANLkTik+0BW3Rv3-YAaoX+WyUaa9NHUPXVuqvETAfiCe@mail.gmail.com>
Date: Fri, 1 Oct 2010 17:55:34 +0200
Message-ID: <AANLkTimc3qMD9KyhRFTme5M5uy64gonWRwbbSK89viTK@mail.gmail.com>
Subject: Re: Sorting by secondary index
From: Petr Odut <petr.odut@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016364edb5e99692a04919039eb

--0016364edb5e99692a04919039eb
Content-Type: text/plain; charset=ISO-8859-1

OK,
I have a query with 2 expressions:
1st: with GTE operator
2nd: with EQ operator

both columns are indexed, but results are sorted in token order (I should
expect to be sorted by 1st expression column values).
Am I correct?

On Fri, Oct 1, 2010 at 5:18 PM, Jonathan Ellis <jbellis@gmail.com> wrote:

> secondary index results are always sorted by indexed column value.
> rows with the same index value are sorted in token order (although
> support for comparator order is planned).
>
> sorting by a different column is not possible to do efficiently
> server-side and therefore is left to the client.
>
> On Fri, Oct 1, 2010 at 10:13 AM, Petr Odut <petr.odut@gmail.com> wrote:
> > Hi,
> > is it possible to sort results based on secondary index search?
> > Typical use case is to get most recent comments from specified group
> > CF: comments
> >  * SI: group
> >  * SI: timestamp
> > I've asked before, but I can't still found any information.
> > Thanks
> > --
> > Petr Odut [petr.odut@gmail.com]
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>


-- 
Petr Odut [petr.odut@gmail.com]

--0016364edb5e99692a04919039eb
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

OK,<div>I have a query with 2 expressions:</div><div>1st: with GTE operator=
</div><div>2nd: with EQ operator</div><div><br></div><div>both columns are =
indexed, but results are sorted in token order (I should expect to be sorte=
d by 1st expression column values).</div>
<div>Am I correct?</div><div><br></div><div><div class=3D"gmail_quote">On F=
ri, Oct 1, 2010 at 5:18 PM, Jonathan Ellis <span dir=3D"ltr">&lt;<a href=3D=
"mailto:jbellis@gmail.com">jbellis@gmail.com</a>&gt;</span> wrote:<br><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex;">
secondary index results are always sorted by indexed column value.<br>
rows with the same index value are sorted in token order (although<br>
support for comparator order is planned).<br>
<br>
sorting by a different column is not possible to do efficiently<br>
server-side and therefore is left to the client.<br>
<div><div></div><div class=3D"h5"><br>
On Fri, Oct 1, 2010 at 10:13 AM, Petr Odut &lt;<a href=3D"mailto:petr.odut@=
gmail.com">petr.odut@gmail.com</a>&gt; wrote:<br>
&gt; Hi,<br>
&gt; is it possible to sort results based on secondary index search?<br>
&gt; Typical use case is to get most recent comments from specified group<b=
r>
&gt; CF: comments<br>
&gt; =A0* SI: group<br>
&gt; =A0* SI: timestamp<br>
&gt; I&#39;ve asked before, but I can&#39;t still found any information.<br=
>
&gt; Thanks<br>
&gt; --<br>
&gt; Petr Odut [<a href=3D"mailto:petr.odut@gmail.com">petr.odut@gmail.com<=
/a>]<br>
&gt;<br>
<br>
<br>
<br>
</div></div><font color=3D"#888888">--<br>
Jonathan Ellis<br>
Project Chair, Apache Cassandra<br>
co-founder of Riptano, the source for professional Cassandra support<br>
<a href=3D"http://riptano.com" target=3D"_blank">http://riptano.com</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>Petr Odut [<a hr=
ef=3D"mailto:petr.odut@gmail.com">petr.odut@gmail.com</a>]<br>
</div>

--0016364edb5e99692a04919039eb--