Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 27C69994C for ; Tue, 12 Jun 2012 03:32:38 +0000 (UTC) Received: (qmail 44357 invoked by uid 500); 12 Jun 2012 03:32:35 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44256 invoked by uid 500); 12 Jun 2012 03:32:35 -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 44235 invoked by uid 99); 12 Jun 2012 03:32:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jun 2012 03:32:34 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rajatmathurr@gmail.com designates 209.85.216.49 as permitted sender) Received: from [209.85.216.49] (HELO mail-qa0-f49.google.com) (209.85.216.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jun 2012 03:32:28 +0000 Received: by qabj40 with SMTP id j40so80488qab.8 for ; Mon, 11 Jun 2012 20:32:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=5MnHin9RbmDVI164IeojLFkpqzQmkGinZgCaoHGMAGQ=; b=Vz1MCIIihDo+52FbfAd8SwQC1tkt276SKusjgzd8OZKi5VdfR9mrry444zLhLDOL9J hVHcbR79d3UR2drNSJcixIUj6QDpYKhcM72u+xDk0NpHqy5CtZ+wkHirvH75xzW+ewXR O4ObDnvivjD1bLg4uMrfvVkl8Ygj0J9ciDXQ50r99L3gBFQ9vt9Sm27LOWsB2WxOlMaB iCR9GBd9VJ1+Ojbh4JBbA542LwO6CblC2GJPxSDXBSD8flWBmqBViMoQuwiC/khImpwr v03+l+6O6GFBShM647rtoVy/pA9yziUSVQci3Xvdja8A98V/TY2tMFq2/6kDYeCmIXXO P3Sg== MIME-Version: 1.0 Received: by 10.224.105.69 with SMTP id s5mr17392679qao.92.1339471927588; Mon, 11 Jun 2012 20:32:07 -0700 (PDT) Received: by 10.229.47.139 with HTTP; Mon, 11 Jun 2012 20:32:07 -0700 (PDT) In-Reply-To: References: Date: Tue, 12 Jun 2012 09:02:07 +0530 Message-ID: Subject: Re: Offset in slicequeries for pagination From: Rajat Mathur To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=20cf3074d9566e377c04c23e1ce9 --20cf3074d9566e377c04c23e1ce9 Content-Type: text/plain; charset=ISO-8859-1 Hi Cyril, This may help. http://architecturalatrocities.com/post/13918146722/implementing-column-pagination-in-cassandra On Tue, Jun 12, 2012 at 3:18 AM, Cyril Auburtin wrote: > If my columns are ("k1:k2" => data1), ("k11:k32" => data211), ("k10:k211" > => data91) > > U mean transforming to ("1:k1:k2" => data1), ("2:k11:k32" => data211) but > I need the previous columns names to slice query on them > > 2012/6/11 R. Verlangen > > I solved this with creating a manual index with as column keys integers >> and column values the uuid's of the results. Then run a slicequery to >> determine the batch to fetch. >> >> >> 2012/6/11 Cyril Auburtin >> >>> using 10 results maximum per page, >>> >>> to go directly to 14th page, there is no offset=141 possibility I guess? >>> or does a Java client proposes that? >>> >>> What is the best solution, perform a get with a limit = page*10, and >>> then a get with a column_start equals the lastest column received, and a >>> limit of 10, >>> I guess also, client side should cache results but it's off topic >>> >> >> >> >> -- >> With kind regards, >> >> Robin Verlangen >> *Software engineer* >> * >> * >> W http://www.robinverlangen.nl >> E robin@us2.nl >> >> Disclaimer: The information contained in this message and attachments is >> intended solely for the attention and use of the named addressee and may be >> confidential. If you are not the intended recipient, you are reminded that >> the information remains the property of the sender. You must not use, >> disclose, distribute, copy, print or rely on this e-mail. If you have >> received this message in error, please contact the sender immediately and >> irrevocably delete this message and any copies. >> >> > -- *Rajat Mathur B.Tech (IT) Final Year IIIT Allahabad 09945990291 Find me @ Facebook Follow me @ Twitter * --20cf3074d9566e377c04c23e1ce9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Cyril,

This may help.

htt= p://architecturalatrocities.com/post/13918146722/implementing-column-pagina= tion-in-cassandra

On Tue, Jun 12, 2012 at 3:18 AM, Cyril Aubur= tin <cyril.auburtin@gmail.com> wrote:
If my columns are ("k1:k2" =3D> data1),=A0("k11:k32"= =3D> data211),=A0("k10:k211" =3D> data91)

U m= ean transforming to=A0=A0("1:k1:k2" =3D> data1),=A0("2:k1= 1:k32" =3D> data211)=A0but I need the previous columns names to sli= ce query on them

2012/6/11 R. Verlangen <robin@us2.nl>= ;

I solved this with creating a manual index with as column keys integers and= column values the uuid's of the results. Then run a slicequery to dete= rmine the batch to fetch.


2012/6/11 Cyril Auburtin <cyril.auburtin@gmail.com>
using=A0=A010 results maximum per page,
=
to go directly to 14th page, there is no offset=3D141 possib= ility I guess? or does a Java client proposes that?

What is the best solution, perform a get with a limit = =3D page*10, and then a get with a column_start equals the lastest column r= eceived, and a limit of 10,
I guess also, client side should cache results but it's off topic<= /div>



<= font color=3D"#888888">--
With kind regards,

Robin V= erlangen
Software engineer

E robin@us2.nl

Disclaimer: The information= contained in this message and attachments is intended solely for the atten= tion and use of the named addressee and may be confidential. If you are not= the intended recipient, you are reminded that the information remains the = property of the sender. You must not use, disclose, distribute, copy, print= or rely on this e-mail. If you have received this message in error, please= contact the sender immediately and irrevocably delete this message and any= copies.





--
Rajat Mathur
B.Tech (IT) Final Year
IIIT Al= lahabad

09945990291

Find me @ Facebook
Follow me @ Twitter
--20cf3074d9566e377c04c23e1ce9--