Return-Path: 
 <user-return-5540-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: (qmail 37589 invoked from network); 9 May 2010 07:00:37 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 9 May 2010 07:00:37 -0000
Received: (qmail 72713 invoked by uid 500); 9 May 2010 07:00:36 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 72646 invoked by uid 500); 9 May 2010 07:00:35 -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 72637 invoked by uid 99); 9 May 2010 07:00:35 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 May 2010 07:00:35 +0000
X-ASF-Spam-Status: No, hits=2.7 required=10.0
	tests=AWL,HTML_MESSAGE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 May 2010 07:00:29 +0000
Received: by fxm4 with SMTP id 4so1866248fxm.31
        for <user@cassandra.apache.org>; Sun, 09 May 2010 00:00:08 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.103.66.9 with SMTP id t9mr1217852muk.73.1273388407928;
 Sun, 09
	May 2010 00:00:07 -0700 (PDT)
Received: by 10.102.228.18 with HTTP; Sun, 9 May 2010 00:00:07 -0700 (PDT)
X-Originating-IP: [80.179.102.198]
In-Reply-To: <AANLkTinopVo9OaLIiq5yWMc3DSehPuDl_f0Qz00dOOmF@mail.gmail.com>
References: <AANLkTimW_VDGMqeJo6QcYl_ErTo2TC0ToUowEvltKHqn@mail.gmail.com>
	 <1273263449.442916359@192.168.2.230>
	 <AANLkTinopVo9OaLIiq5yWMc3DSehPuDl_f0Qz00dOOmF@mail.gmail.com>
Date: Sun, 9 May 2010 10:00:07 +0300
Message-ID: <AANLkTikvIVB70aasweV_Fmx52AQSIqmUQ8YPmkhnA2C1@mail.gmail.com>
Subject: Re: key is sorted?
From: David Boxenhorn <david@lookin2.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016e6567e86b73981048623d78d

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

This is something that I'm not sure that I understand. Can somebody
confirm/deny that I understand it? Thanks.

If you use random partitioning, you can loop through all keys with a range
query, but they will not be sorted.

True or False?

On Sat, May 8, 2010 at 3:45 AM, AJ Chen <ajchen@web2express.org> wrote:

> thanks, that works. -aj
>
>
> On Fri, May 7, 2010 at 1:17 PM, Stu Hood <stu.hood@rackspace.com> wrote:
>
>> Your IPartitioner implementation decides how the row keys are sorted: see
>> http://wiki.apache.org/cassandra/StorageConfiguration#Partitioner . You
>> need to be using one of the OrderPreservingPartitioners if you'd like a
>> reasonable order for the keys.
>>
>> -----Original Message-----
>> From: "AJ Chen" <ajchen@web2express.org>
>> Sent: Friday, May 7, 2010 3:10pm
>> To: user@cassandra.apache.org
>> Subject: key is sorted?
>>
>> I have a super column family for "topic", key being the name of the topic.
>> <ColumnFamily Name="Topic" CompareWith="UTF8Type" ColumnType="Super"
>> CompareSubcolumnsWith="BytesType" />
>> When I retrieve the rows, the rows are not sorted by the key. Is the row
>> key
>> sorted in cassandra by default?
>>
>> -aj
>> --
>> AJ Chen, PhD
>> Chair, Semantic Web SIG, sdforum.org
>> http://web2express.org
>> twitter @web2express
>> Palo Alto, CA, USA
>>
>>
>>
>
>
> --
> AJ Chen, PhD
> Chair, Semantic Web SIG, sdforum.org
> http://web2express.org
> twitter @web2express
> Palo Alto, CA, USA
>

--0016e6567e86b73981048623d78d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">This is something that I&#39;m not sure that I understand.=
 Can somebody confirm/deny that I understand it? Thanks.<br><br>If you use =
random partitioning, you can loop through all keys with a range query, but =
they will not be sorted.<br>
<br>True or False? <br><br><div class=3D"gmail_quote">On Sat, May 8, 2010 a=
t 3:45 AM, AJ Chen <span dir=3D"ltr">&lt;<a href=3D"mailto:ajchen@web2expre=
ss.org">ajchen@web2express.org</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid=
 rgb(204, 204, 204); padding-left: 1ex;">
<tt>thanks, that works. -aj</tt><div><div></div><div class=3D"h5"><br><br><=
div class=3D"gmail_quote">On Fri, May 7, 2010 at 1:17 PM, Stu Hood <span di=
r=3D"ltr">&lt;<a href=3D"mailto:stu.hood@rackspace.com" target=3D"_blank">s=
tu.hood@rackspace.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Your IPartitioner implementation decides how the row keys are sorted: see <=
a href=3D"http://wiki.apache.org/cassandra/StorageConfiguration#Partitioner=
" target=3D"_blank">http://wiki.apache.org/cassandra/StorageConfiguration#P=
artitioner</a> . You need to be using one of the OrderPreservingPartitioner=
s if you&#39;d like a reasonable order for the keys.<br>



<div><div></div><div><br>
-----Original Message-----<br>
From: &quot;AJ Chen&quot; &lt;<a href=3D"mailto:ajchen@web2express.org" tar=
get=3D"_blank">ajchen@web2express.org</a>&gt;<br>
Sent: Friday, May 7, 2010 3:10pm<br>
To: <a href=3D"mailto:user@cassandra.apache.org" target=3D"_blank">user@cas=
sandra.apache.org</a><br>
Subject: key is sorted?<br>
<br>
I have a super column family for &quot;topic&quot;, key being the name of t=
he topic.<br>
&lt;ColumnFamily Name=3D&quot;Topic&quot; CompareWith=3D&quot;UTF8Type&quot=
; ColumnType=3D&quot;Super&quot;<br>
CompareSubcolumnsWith=3D&quot;BytesType&quot; /&gt;<br>
When I retrieve the rows, the rows are not sorted by the key. Is the row ke=
y<br>
sorted in cassandra by default?<br>
<br>
-aj<br>
--<br>
AJ Chen, PhD<br>
Chair, Semantic Web SIG, <a href=3D"http://sdforum.org" target=3D"_blank">s=
dforum.org</a><br>
<a href=3D"http://web2express.org" target=3D"_blank">http://web2express.org=
</a><br>
twitter @web2express<br>
Palo Alto, CA, USA<br>
<br>
<br>
</div></div></blockquote></div><br><br clear=3D"all"><br>-- <br>AJ Chen, Ph=
D<br>Chair, Semantic Web SIG, <a href=3D"http://sdforum.org" target=3D"_bla=
nk">sdforum.org</a><br><a href=3D"http://web2express.org" target=3D"_blank"=
>http://web2express.org</a><br>

twitter @web2express<br>
Palo Alto, CA, USA<br>
</div></div></blockquote></div><br></div>

--0016e6567e86b73981048623d78d--