Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 61825 invoked from network); 4 Apr 2010 23:04:23 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 4 Apr 2010 23:04:23 -0000 Received: (qmail 98793 invoked by uid 500); 4 Apr 2010 23:04:22 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 98763 invoked by uid 500); 4 Apr 2010 23:04:22 -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 98755 invoked by uid 99); 4 Apr 2010 23:04:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Apr 2010 23:04:22 +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 canovaj@gmail.com designates 209.85.222.190 as permitted sender) Received: from [209.85.222.190] (HELO mail-pz0-f190.google.com) (209.85.222.190) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 04 Apr 2010 23:04:16 +0000 Received: by pzk28 with SMTP id 28so416333pzk.11 for ; Sun, 04 Apr 2010 16:03:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:date :x-google-sender-auth:received:message-id:subject:from:to :content-type; bh=szkCnZsINFIrFax+4BvgVGpZ7duoD1DJfPUM0LioYVw=; b=dNpIvRrsEVFbCnP3GLWJP9Zw1JpdS56TcsSL79tMq7VbBlKTzGJGLhJnb46rrYnEOd 2eWHuIxotolikjc+axKg3Y2o+gZvEqc3N036Hv4X+/9Y3JKv1u4ULa8OSsW4G/q+y6ta bOF41DbANHGrAxvL8jOu1yeJr9Z0sd7n7Y7n0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=ODD+On25LfiNwfJC54zbo4c+94NyQ3qIi7b4+8twrYw/VRKh+/GOX6OlTenY4UXMOw jcYSX0/4CvU1akD+rZoQNuO93Bo6QiqaWmt7eneO3flSHAn0HR9EGnsPMD660/YVZi07 qLzMATSLSkXYqezFIfqr8hUciEDbK7JAzuTxU= MIME-Version: 1.0 Sender: canovaj@gmail.com Received: by 10.115.18.14 with HTTP; Sun, 4 Apr 2010 16:03:56 -0700 (PDT) Date: Sun, 4 Apr 2010 16:03:56 -0700 X-Google-Sender-Auth: 0f6df16c0214d8c5 Received: by 10.114.33.18 with SMTP id g18mr3982927wag.2.1270422236052; Sun, 04 Apr 2010 16:03:56 -0700 (PDT) Message-ID: Subject: how to paginate through CF From: AJ Chen To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001636b1495d183bd50483713ae5 --001636b1495d183bd50483713ae5 Content-Type: text/plain; charset=ISO-8859-1 Pagination is be numbers, e.g. get 10 rows starting from number 100 or getRows(100, 10). Column family uses KeyRange to get a section of the table. This assumes the key is always sorted. Is it true? Secondly, the key normally a string. How do you translate the starting row number to a string key? You can start from row 0 until row 100 and then collect 10 rows. This may not be efficient. Is there a better way to paginate through CF? thanks, AJ --001636b1495d183bd50483713ae5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Pagination is be numbers, e.g. get 10 rows starting from number 100 or=20 getRows(100, 10). Column family uses KeyRange to get a section of the=20 table. This assumes the key is always sorted. Is it true? Secondly, the=20 key normally a string.=A0 How do you translate the starting row number=A0 t= o a string key?=A0 You can start from row 0 until row 100 and then collect= =20 10 rows. This may not be efficient. Is there a better way to paginate=20 through CF?
thanks,=A0
AJ

--001636b1495d183bd50483713ae5--