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 0D793726D for ; Thu, 1 Dec 2011 10:52:12 +0000 (UTC) Received: (qmail 75081 invoked by uid 500); 1 Dec 2011 10:52:09 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 75030 invoked by uid 500); 1 Dec 2011 10:52:09 -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 75021 invoked by uid 99); 1 Dec 2011 10:52:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2011 10:52:09 +0000 X-ASF-Spam-Status: No, hits=1.6 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rajkumar.w93@gmail.com designates 209.85.214.44 as permitted sender) Received: from [209.85.214.44] (HELO mail-bw0-f44.google.com) (209.85.214.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Dec 2011 10:52:02 +0000 Received: by bkbzt19 with SMTP id zt19so2231711bkb.31 for ; Thu, 01 Dec 2011 02:51:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=t/IBIqQxFfRKXdM5zRrvvN5JKsvsyrOpZx9nDTj6slA=; b=U/bxuZ4PXQr/UFJHhEs+XsdOLB+xL+mPCrVNrvzZXQJCgI58u2KY3rhEsRYk0qY+4b pnv1ShyziQMYEwobZHaB5nr+7Hc6yuHx25gCTjbQy6Z1tHOWirlR09Zm8LdKBS2h8aaw bXup4oDnr8s4bJfutxI+py3ViMHMDZH2ZICL4= MIME-Version: 1.0 Received: by 10.205.42.202 with SMTP id tz10mr6906195bkb.57.1322736701644; Thu, 01 Dec 2011 02:51:41 -0800 (PST) Sender: rajkumar.w93@gmail.com Received: by 10.223.88.15 with HTTP; Thu, 1 Dec 2011 02:51:41 -0800 (PST) In-Reply-To: References: Date: Thu, 1 Dec 2011 16:21:41 +0530 X-Google-Sender-Auth: mTRslo9N506s2l6FwruEFe0AHcQ Message-ID: Subject: Re: Strategies to maintain counters sorted row ? From: Aditya To: user Content-Type: multipart/alternative; boundary=bcaec52bf0a33b9f3b04b305a368 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec52bf0a33b9f3b04b305a368 Content-Type: text/plain; charset=ISO-8859-1 In my application, I need to store the total scores/reputation of the users as counters and want to show sorted(by score) lists of users. Also want to implement a name search facility on top of that. Could you suggest any schema to achieve that using cassandra. On Wed, Nov 30, 2011 at 12:53 PM, Aditya wrote: > I know it is not possible to sort columns in a row by counter values so > what are the other strategies to maintain a sorted list (of counters) in > cassandra? Could you propose some schema that might be helpful to achieve > this ? > > Or do I need to retrieve thousands of columns each time and do the sorting > at application level ? > --bcaec52bf0a33b9f3b04b305a368 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable In my application, I need to store the total scores/reputation of the users= as counters and want to show sorted(by score) lists of users. Also want to= implement a name search facility on top of that. Could you suggest =A0any = schema to achieve that using cassandra.=A0


On Wed, Nov 30, 2011 at 12:53= PM, Aditya <adynn= n@gmail.com> wrote:
I know it is not possible to sort columns in a row by counter values so wha= t are the other strategies to maintain a sorted list (of counters) =A0in ca= ssandra? Could you propose some schema that might be helpful to achieve thi= s ?=A0

Or do I need to retrieve thousands of columns each time and = do the sorting at application level ?

--bcaec52bf0a33b9f3b04b305a368--