From user-return-21880-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Sat Oct 29 16:43:27 2011 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 CA1DD9F8D for ; Sat, 29 Oct 2011 16:43:27 +0000 (UTC) Received: (qmail 45220 invoked by uid 500); 29 Oct 2011 16:43:25 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 45193 invoked by uid 500); 29 Oct 2011 16:43:25 -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 45185 invoked by uid 99); 29 Oct 2011 16:43:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2011 16:43:25 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of al3xdm@gmail.com designates 209.85.160.172 as permitted sender) Received: from [209.85.160.172] (HELO mail-gy0-f172.google.com) (209.85.160.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2011 16:43:19 +0000 Received: by gyh20 with SMTP id 20so5494314gyh.31 for ; Sat, 29 Oct 2011 09:42:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; bh=3RDU900zhWUwIOuoVSK8kWxs7uwAPmBea08barNNAwA=; b=le7xn+g3FJFvX9se6ZAk1uQI9jk1G143cGJHyVbOecG8NacyvGBP9YkViJI4yzAnMP 1FY5yWc6ypzrYY4fZetlOU/JVDdhtHv5X3O+7ugpk2RaKeqZe1huphj4m+0ZK8cYFYYl ksC8e3dCnqzeCrc4CiRd7OTyfpIKj1HguXY5g= Received: by 10.150.179.17 with SMTP id b17mr6249409ybf.102.1319906578424; Sat, 29 Oct 2011 09:42:58 -0700 (PDT) MIME-Version: 1.0 From: Alex Major Date: Sat, 29 Oct 2011 09:42:58 -0700 Message-ID: <3093482764659232252@unknownmsgid> Subject: RE: Previous Page Pagination? To: Sam Hodgson , "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=000e0cd51506be62ee04b072b28e --000e0cd51506be62ee04b072b28e Content-Type: text/plain; charset=ISO-8859-1 Hey, You can switch the reversed flag on (or off) and use the first key returned as the start key for the previous page. Alex ------------------------------ From: Sam Hodgson Sent: 29/10/2011 16:15 To: user@cassandra.apache.org Subject: Previous Page Pagination? Hi, Is there a good method to use for pagination in Cassandra? I can create a next page link by pulling an extra column when getting however previous page is proving tricky. Im using integer timestamps as column keys so would really need a way to pull out the 10 preceeding columns as well as the 10 following the given timestamp. Cheers Sam --000e0cd51506be62ee04b072b28e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hey,

You can switch the reversed flag on (or off) = and use the first key returned as the start key for the previous page.

Alex

From: Sam Hodgson
Se= nt: 29/10/2011 16:15
To: user@cassandra.apach= e.org
Subject: Previous Page Pagination?

Hi,

Is there a good method to use for pagination in Cassandra? I can= create a next page link by pulling an extra column when getting however pr= evious page is proving tricky.=A0 Im using integer timestamps as column key= s so would really need a way to pull out the 10 preceeding columns as well = as the 10 following the given timestamp.

Cheers

Sam
--000e0cd51506be62ee04b072b28e--