Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=S9UjbA9wv4wbRD7PWxiVkTdPiWVGVhwX1AaEvrzgMsAExKYr/H3c+k6VawM9KLbZL5
         x5onS+jt8Sqc6H4CWNJzKV67wtLmoxOfedr7NRlsfAikTIvXJvhexKc6G1a80ZXVutLM
         461BI60imjg8M5bdJEoLCbsLDvRs2BTtxUOX4=
MIME-Version: 1.0
In-Reply-To: <AANLkTilIJ7NBhwa3V33oaJ5Joaryxd5Oi_G6UwvH7l6x@mail.gmail.com>
References: <AANLkTilIJ7NBhwa3V33oaJ5Joaryxd5Oi_G6UwvH7l6x@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Mon, 31 May 2010 13:52:32 -0500
Message-ID: <AANLkTimRAzeRMT6a9AojP-dE8gHIAR1xX2rhTbXL9Z7q@mail.gmail.com>
Subject: Re: Start key must sort before (or equal to) finish key in your
	partitioner
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

OPP uses lexical ordering on the keys, which isn't going to be the
same as the natural order for a time-based uuid.

On Mon, May 31, 2010 at 2:57 AM, Leslie Viljoen <leslieviljoen@gmail.com> w=
rote:
> Hello!
>
> I am using an OrderPreservingPartitioner and sequential UUID's as
> keys. When I use get_range I frequently get an error indicating that
> my start key is not before or equal to my finish key, which seems
> impossible. The code to request slices looks like this:
>
> sometime =3D Time.now
> a =3D UUIDTools::UUID.timestamp_create(sometime)
> b =3D UUIDTools::UUID.timestamp_create(sometime + 1)
> slice =3D @cassandra.get_range(:ReportData, :start =3D> a.to_s, :finish =
=3D> b.to_s)
> puts "SORT ERROR!" if a >=3D b =A0 =A0# this never displays
>
>
>
> This is the error I get:
>
> /usr/lib/ruby/gems/1.8/gems/cassandra-0.8.2/lib/../vendor/gen-rb/cassandr=
a.rb:152:in
> `recv_get_range_slices': start key must sort before (or equal to)
> finish key in your partitioner!
> (CassandraThrift::InvalidRequestException)
> =A0 =A0 =A0 =A0from /usr/lib/ruby/gems/1.8/gems/cassandra-0.8.2/lib/../ve=
ndor/gen-rb/cassandra.rb:142:in
> `get_range_slices'
> =A0 =A0 =A0 =A0from /usr/lib/ruby/gems/1.8/gems/thrift_client-0.4.0/lib/t=
hrift_client.rb:140:in
> `send'
> =A0 =A0 =A0 =A0from /usr/lib/ruby/gems/1.8/gems/thrift_client-0.4.0/lib/t=
hrift_client.rb:140:in
> `proxy'
> =A0 =A0 =A0 =A0from (eval):1:in `get_range_slices'
> =A0 =A0 =A0 =A0from /usr/lib/ruby/gems/1.8/gems/cassandra-0.8.2/lib/cassa=
ndra/protocol.rb:78:in
> `_get_range'
> =A0 =A0 =A0 =A0from /usr/lib/ruby/gems/1.8/gems/cassandra-0.8.2/lib/cassa=
ndra/cassandra.rb:230:in
> `get_range'
> =A0 =A0 =A0 =A0from ./read.rb:29:in `get_range'
> =A0 =A0 =A0 =A0from ./read.rb:62
> =A0 =A0 =A0 =A0from ./read.rb:58:in `loop'
> =A0 =A0 =A0 =A0from ./read.rb:58
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com