Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cassandra-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of michael.greene@gmail.com
 designates 209.85.219.209 as permitted sender)
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:content-transfer-encoding;
        b=v2U/inZupWif7ocWCzCt3h2G8kSEusA7v6csx3HpExeE1C7liwV4Vw+Cx3iHjADmA7
         BFI6oxF1g9+psE9Z7+ZNb1i8i0sQgofyotCiJ4GVNUKJ/KIMFv5txPoV7qRsyN4MBQKx
         bfrBjSEkE4r57FapGNNBPS9OSsuAh6JGMhh4w=
MIME-Version: 1.0
In-Reply-To: <ff027e5c0910251826t7ce74347gb4ac11cf696f80bd@mail.gmail.com>
References: <ff027e5c0910251617l73a1a71fne75f18d4d3ca39f6@mail.gmail.com>
	 <e06563880910251740k32ff1fdge13550e0b7692876@mail.gmail.com>
	 <ff027e5c0910251826t7ce74347gb4ac11cf696f80bd@mail.gmail.com>
Date: Sun, 25 Oct 2009 20:34:29 -0500
Message-ID: <f4d6a21a0910251834m256d1810r4a1a0f3ee677ee40@mail.gmail.com>
Subject: Re: are columns of a supercolumn name sorted?
From: Michael Greene <michael.greene@gmail.com>
To: cassandra-user@incubator.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

"reversed" is a boolean option on the SliceRange that you pass in the
get_slice method via its predicate parameter.

Michael

On Sun, Oct 25, 2009 at 8:26 PM, kevin <kevincastiglione@gmail.com> wrote:
> hi jonathan
> thanks for the clarification.
>
>>>>subcolumns is what you want (with the reverse option to slice, to get
>>>> most-recent-first).
>
> is reverse an option in get_slice method or in my python code or in the
> config file?
>
>
>
> On Sun, Oct 25, 2009 at 5:40 PM, Jonathan Ellis <jbellis@gmail.com> wrote=
:
>>
>> Sorry, the paragraph about subcolumns always being sorted by time is
>> outdated. =A0(I've taken it out on the 0.4 branch now -- it was already
>> gone in trunk.) =A0Read just below that about how comparewith and
>> comparesubcolumnswith work. =A0Sounds like using TimeUUIDType for
>> subcolumns is what you want (with the reverse option to slice, to get
>> most-recent-first).
>>
>> On Sun, Oct 25, 2009 at 5:17 PM, kevin <kevincastiglione@gmail.com> wrot=
e:
>> > i am inserting three columns x,a,z into a super column named 'sc_2'. t=
he
>> > config file says that the columns of a super column are timesorted, bu=
t
>> > when
>> > i get_slice it is sorted by the name of the columns. how do i get it
>> > time
>> > sorted so that i get the most recently inserted/updated column first?
>> > cassandra version apache-cassandra-incubating-0.4.1-bin.tar.gz, and
>> > lazyboy
>> > latest git clone.
>> > thanks
>> >
>> >
>> >>>> import lazyboy,time, pprint
>> >>>> from cassandra import Cassandra
>> >>>> from cassandra.ttypes import *
>> >
>> >
>> >>>> client=3Dlazyboy.connection.Client(['localhost:9160'])
>> >>>> keyspace =3D "Keyspace1"
>> >>>> key=3D'mykeyx'
>> >>>> column_path =3D
>> >>>> ColumnPath(column_family=3D"Super1",column=3D"x",super_column=3D'sc=
_2')
>> >>>> client.insert(keyspace, key, column_path, 'a', time.time(),
>> >>>> ConsistencyLevel.ONE);
>> >>>> column_path =3D
>> >>>> ColumnPath(column_family=3D"Super1",column=3D"a",super_column=3D'sc=
_2')
>> >>>> client.insert(keyspace, key, column_path, 'a', time.time(),
>> >>>> ConsistencyLevel.ONE);
>> >>>> column_path =3D
>> >>>> ColumnPath(column_family=3D"Super1",column=3D"z",super_column=3D'sc=
_2')
>> >>>> client.insert(keyspace, key, column_path, 'a', time.time(),
>> >>>> ConsistencyLevel.ONE);
>> >
>> >
>> >>>> slice_range =3D SliceRange(start=3D"", finish=3D"")
>> >>>> predicate =3D SlicePredicate(slice_range=3Dslice_range)
>> >>>> column_parent =3D ColumnParent(column_family=3D"Super1")
>> >>>> client.get_slice(keyspace, key, column_parent, predicate,
>> >>>> ConsistencyLevel.ONE)
>> > [ColumnOrSuperColumn(column=3DNone, super_column=3DSuperColumn(name=3D=
'sc_2',
>> > columns=3D[Column(timestamp=3D1256512261, name=3D'a', value=3D'a'),
>> > Column(timestamp=3D1256512252, name=3D'x', value=3D'a'),
>> > Column(timestamp=3D1256512267, name=3D'z', value=3D'a')]))]
>> >
>
>