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 017129FCA for ; Fri, 16 Mar 2012 21:30:11 +0000 (UTC) Received: (qmail 50298 invoked by uid 500); 16 Mar 2012 21:30:09 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 50251 invoked by uid 500); 16 Mar 2012 21:30: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 50242 invoked by uid 99); 16 Mar 2012 21:30:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2012 21:30:09 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of s5alye@gmail.com designates 209.85.213.172 as permitted sender) Received: from [209.85.213.172] (HELO mail-yx0-f172.google.com) (209.85.213.172) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2012 21:30:03 +0000 Received: by yenm5 with SMTP id m5so5314736yen.31 for ; Fri, 16 Mar 2012 14:29:42 -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=fet51O9T3QOTpTgvjBIb/wB+BuZnkoEa28M6DnB9GGc=; b=n4i2Tlqgrm5+mSAeQ3tUvBnJTND5RmT2iXxmYZc1pqc4o1grjgfRLNt/SWZWaoN/68 cIV26XgRBDuBbHBy2ZWSZoNtMpyMZgCdhVPRE955UcgxLDWkeWdoYrLGokssS9qGkfdd Gw+znSgG8AwfGL0uFdm2fPcflxgk0NDiRcS0uMoRHUPHZriONdJdEldM88KBOBeEmAn4 dcIMGhAv+6TAijDQ+pHk/YXgsCahqDlGby+k4miznGfONgDbce/hh5hnsJ5jzENUo1Iz iJCF3i9luUXZLqxsRL/AT708jZbigLtFTlB8DdA1zEARJXaz/8htReXE8fQfkiDBWH95 8Jcw== MIME-Version: 1.0 Received: by 10.60.28.137 with SMTP id b9mr4717310oeh.57.1331933382794; Fri, 16 Mar 2012 14:29:42 -0700 (PDT) Received: by 10.182.91.165 with HTTP; Fri, 16 Mar 2012 14:29:42 -0700 (PDT) Date: Fri, 16 Mar 2012 17:29:42 -0400 Message-ID: Subject: Order rows numerically From: A J To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org If I define my rowkeys to be Integer (key_validation_class=IntegerType) , how can I order the rows numerically ? ByteOrderedPartitioner orders lexically and retrieval using get_range does not seem to make sense in order. If I were to change rowkey to be UTF8 (key_validation_class=UTF8Type), BOP still does not give numerical enough. For range of rowkey from 1 to 2, I get 1, 10,11.....,2 (lexical ordering). Any workaround for this ? Thanks.