Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 9466 invoked from network); 3 Oct 2010 17:09:09 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 Oct 2010 17:09:09 -0000 Received: (qmail 29451 invoked by uid 500); 3 Oct 2010 17:09:07 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 29378 invoked by uid 500); 3 Oct 2010 17:09:07 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 29370 invoked by uid 99); 3 Oct 2010 17:09:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Oct 2010 17:09:06 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of petr.odut@gmail.com designates 209.85.216.179 as permitted sender) Received: from [209.85.216.179] (HELO mail-qy0-f179.google.com) (209.85.216.179) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Oct 2010 17:09:00 +0000 Received: by qyk7 with SMTP id 7so68599qyk.10 for ; Sun, 03 Oct 2010 10:08:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:received :in-reply-to:references:date:message-id:subject:from:to:content-type; bh=rMCcDAFVKFecCV9KXMv9scAij8oyWOiZa+oJR/lSpDQ=; b=TadoNoZoJg+pExy/ekuiBSAChVDgpMAlIhjbelpYrO9pSITR9PsqZJE+3Rx83ZntVa 8wX4M5iPyWyN1/1dB9mmby32EQ54/S9vfd3KYrmO1qTfoCINuQNXHXEjevISiI4hUaSE YpqbJLpjiesrad0aA8Mp25H+7xa75Rh7NQMd0= 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=pxpdxLwkINfHQdVam3XUGYVetRr4/XIYXYypqajGPRPx3p5uT1cpTC2wNoMsLZM1tZ Hsl1hmfOnh2PIIfQFdyt2OGZhQmBCtvtbM1/Oyw56Fmo1mrnIvG13unH5VUEGwwCsstw yIYpLt//iGyPDOKB6ChJIERJt+nzP105AL9yA= MIME-Version: 1.0 Received: by 10.224.54.140 with SMTP id q12mr5929390qag.139.1286125719556; Sun, 03 Oct 2010 10:08:39 -0700 (PDT) Received: by 10.229.110.4 with HTTP; Sun, 3 Oct 2010 10:08:39 -0700 (PDT) Received: by 10.229.110.4 with HTTP; Sun, 3 Oct 2010 10:08:39 -0700 (PDT) In-Reply-To: References: Date: Sun, 3 Oct 2010 19:08:39 +0200 Message-ID: Subject: Re: Sorting by secondary index From: Petr Odut To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0015175cb058a693400491b97a5c --0015175cb058a693400491b97a5c Content-Type: text/plain; charset=ISO-8859-1 Thanks for the info. Will be ever possible to going throught a secondary index (since SI is sorted by default)? My use case is to display newest comments, users, etc. SI from my point of view perfectly fits here. Thanks :) Petr Odut. Dne 2010 10 1 18:26 "Jonathan Ellis" napsal(a): No, additional expressions (the GTE here) only affect what rows come back and do not affect sort order. On Fri, Oct 1, 2010 at 10:55 AM, Petr Odut wrote: > OK, > I have a query with... -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Ca... --0015175cb058a693400491b97a5c Content-Type: text/html; charset=ISO-8859-1

Thanks for the info. Will be ever possible to going throught a secondary index (since SI is sorted by default)? My use case is to display newest comments, users, etc. SI from my point of view perfectly fits here.

Thanks :)
Petr Odut.

Dne 2010 10 1 18:26 "Jonathan Ellis" <jbellis@gmail.com> napsal(a):
No, additional expressions (the GTE here) only affect what rows come
back and do not affect sort order.


On Fri, Oct 1, 2010 at 10:55 AM, Petr Odut <petr.odut@gmail.com> wrote:
> OK,
> I have a query with...

--

Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Ca...

--0015175cb058a693400491b97a5c--