Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 1065 invoked from network); 2 Feb 2010 15:53:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Feb 2010 15:53:20 -0000 Received: (qmail 34283 invoked by uid 500); 2 Feb 2010 15:53:19 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 34261 invoked by uid 500); 2 Feb 2010 15:53:19 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 34252 invoked by uid 99); 2 Feb 2010 15:53:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 15:53:19 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of erikholstad@gmail.com designates 209.85.216.174 as permitted sender) Received: from [209.85.216.174] (HELO mail-px0-f174.google.com) (209.85.216.174) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 15:53:11 +0000 Received: by pxi4 with SMTP id 4so177318pxi.32 for ; Tue, 02 Feb 2010 07:52:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=9QSN0Y2rPDUeryihTNNq2Ip6dC9b16TyhXWPQP4kYJQ=; b=NEwoKnQyAvhDjCkN7d+RGar3HOjXtiDvsx7PuBIE+PqoHW/YNf6UitZNxKNF6FxPfj mEijiyLEy/6N/sIcE4X1xGvaS110n9r9q4wBqdx+3+GamtCi1tZ0CIAUUfk+z1kgTZOe yewjVH4WOixaZ6ZuALcCB8Vv0DKkcl4Lz/DsU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=KvkfmY+X8EjWwptqdgmRfCGzLflyjJDZ0VpyAaKYCKTNZA3yNutfp3r+D1lRpu6npi 2h+fmgdHIv0GsnGP5VjYvq3V3PdFzHkQey+IvcgQ+wa/wzfAgpkqb/TMT5I0GEr8bnAy eBTHT5LzCzYkLBpKJby//dER8+oLfk/ASqRN8= MIME-Version: 1.0 Received: by 10.114.188.37 with SMTP id l37mr4054587waf.9.1265125969872; Tue, 02 Feb 2010 07:52:49 -0800 (PST) In-Reply-To: References: <74f4d40b1002011520xd1c9f21ye2aaa6ca6fb36518@mail.gmail.com> <74f4d40b1002020727j73765089vd6b7253fa498f196@mail.gmail.com> Date: Tue, 2 Feb 2010 07:52:49 -0800 Message-ID: <74f4d40b1002020752w7b3ed789sc3bcc411d7de534a@mail.gmail.com> Subject: Re: Best design in Cassandra From: Erik Holstad To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=0016e64e575607c88e047ea01823 X-Virus-Checked: Checked by ClamAV on apache.org --0016e64e575607c88e047ea01823 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Feb 2, 2010 at 7:45 AM, Brandon Williams wrote: > On Tue, Feb 2, 2010 at 9:27 AM, Erik Holstad wrote: >> >> A supercolumn can still only compare subcolumns in a single way. >>> >> Yeah, I know that, but you can have a super column per sort order without >> having to restart the cluster. >> > > You get a CompareWith for the columns, and a CompareSubcolumnsWith for > subcolumns. If you need more column types to get different sort orders, you > need another ColumnFamily. > Not sure what column types mean. What I want to do is to have a few things sorted by asc and desc order, like {a,b}, {b,a} and {1,2}, {2,1} > > -Brandon > > -- Regards Erik --0016e64e575607c88e047ea01823 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

On Tue, Feb 2, 2010 at 7:45 AM, Brandon = Williams <driftx@g= mail.com> wrote:
On Tue, Feb 2, 2010 at 9:27 AM= , Erik Holstad <erikholstad@gmail.com> wrote:
A supercolumn can still only= compare subcolumns in a single way.
Yeah, I know that, but you can have a s= uper column per sort order without having to restart the cluster.

You get a CompareWith for the colu= mns, and a=A0CompareSubcolumnsWith for subcolumns. =A0If you need more colu= mn types to get different sort orders, you need another ColumnFamily.
Not sure what column types mean. What I want to do = is to have a few things sorted by asc and desc order, like {a,b}, {b,a} and= {1,2}, {2,1}

-Brandon




--
Regards Erik
--0016e64e575607c88e047ea01823--