Return-Path: 
 <user-return-25785-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
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 B63D89811
	for <apmail-cassandra-user-archive@www.apache.org>;
 Thu, 26 Apr 2012 19:34:45 +0000 (UTC)
Received: (qmail 82509 invoked by uid 500); 26 Apr 2012 19:34:43 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 82474 invoked by uid 500); 26 Apr 2012 19:34:43 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 82466 invoked by uid 99); 26 Apr 2012 19:34:43 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2012 19:34:43 +0000
X-ASF-Spam-Status: No, hits=1.7 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of edjone6@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; Thu, 26 Apr 2012 19:34:37 +0000
Received: by ghbg16 with SMTP id g16so1438239ghb.31
        for <user@cassandra.apache.org>; Thu, 26 Apr 2012 12:34:16 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=L8VUeUWpz43v53tCOYqgWxNo6cT6hfbhXAgfYGOUZdU=;
        b=hzMUC+KwpXjCN/Pawg2ip6aK7ZXesCQjho6hchGKmQTY3Tjmaj72hZ9ZL7peVIhG9v
         qPptFXcFBgG/NNpusTsu6Q7w+qJfw+FowRU+EIMQbgj8FC3NzvPKOKYBG+WkHYrvL8us
         GsRj7vJjZnqK3aSKACzvNrLvlT3cVmrEKC+lLgJMFUhgGnkglmy8OGNc5fGy5T08QTsy
         Awh3FYCrWzgo2e7UNrR/uM7n9QSBChrcJtAjHzH/dum80yd9qfql8IbslrVW9IKIR4Ao
         iryxT0oveG0r17oOFWm34vbsU0OqT9pTSOd9mBgFInvi700MiDjUDnqIpRumXi0ar6hp
         Zk1g==
MIME-Version: 1.0
Received: by 10.60.2.198 with SMTP id 6mr10522960oew.34.1335468856352; Thu, 26
 Apr 2012 12:34:16 -0700 (PDT)
Received: by 10.76.19.136 with HTTP; Thu, 26 Apr 2012 12:34:16 -0700 (PDT)
Date: Thu, 26 Apr 2012 15:34:16 -0400
Message-ID: 
 <CACZJzw_36+zUBXyVktoM37Dv4oc4zUqYHmfXMtjhqcoEqMae7g@mail.gmail.com>
Subject: Is this possible.
From: Ed Jone <edjone6@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=e89a8fb1f460ca9fea04be9a122a
X-Virus-Checked: Checked by ClamAV on apache.org

--e89a8fb1f460ca9fea04be9a122a
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I am new to cassandra and was hoping if someone can tell me if the
following is possible.


Given I have a columnfamily with a list of users in each Row.

Each user has the properties: name, highscore, x, y, z.

I want to use name as the column key, but I want the columns to be sorted
by highscore (always).

The only reads would be to get the top N users by highscore in a given row.
I thought about adding the weight to the name as the key (eg:
299.76-johnsmith) but then I would not be able to update a given user.

This was not possible in the past, but I am not familiar, with the newer
cassandra versions.

--e89a8fb1f460ca9fea04be9a122a
Content-Type: text/html; charset=ISO-8859-1

<div>Hello,</div><div><br></div><div>I am new to cassandra and was hoping if someone can tell me if the following is possible.</div><div><br></div><div><br></div><div>Given I have a columnfamily with a list of users in each Row.</div>
<div><br></div><div>Each user has the properties: name, highscore, x, y, z.</div><div><br></div><div>I want to use name as the column key, but I want the columns to be sorted by highscore (always).</div><div><br></div><div>
The only reads would be to get the top N users by highscore in a given row.</div><div>I thought about adding the weight to the name as the key (eg: 299.76-johnsmith) but then I would not be able to update a given user.</div>
<div><br></div><div>This was not possible in the past, but I am not familiar, with the newer cassandra versions.</div>

--e89a8fb1f460ca9fea04be9a122a--