Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 24812 invoked from network); 25 Oct 2009 23:18:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Oct 2009 23:18:15 -0000 Received: (qmail 57764 invoked by uid 500); 25 Oct 2009 23:18:14 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 57736 invoked by uid 500); 25 Oct 2009 23:18:14 -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 57727 invoked by uid 99); 25 Oct 2009 23:18:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Oct 2009 23:18:14 +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 kevincastiglione@gmail.com designates 209.85.210.174 as permitted sender) Received: from [209.85.210.174] (HELO mail-yx0-f174.google.com) (209.85.210.174) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 25 Oct 2009 23:18:06 +0000 Received: by yxe4 with SMTP id 4so8687218yxe.32 for ; Sun, 25 Oct 2009 16:17:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=n2VhUkM91IHK4qY38QX8ZYy5x3KCKyYW9k9hHDo1KTs=; b=krn84obMB+CfQcF+3L6sfB5vvAz3h2PnCYz03hmWORgqMejOLIrjNLVTZx91QuHutA IFJS5zk3kUZbcFtIXVb50QkREsQ4JIK5upQ1NpjZTiicSpuYd+FLnCx3CO7gdwaAQvPn lwGEqgkVsPWOx6D1b37punD1zHW+BKEAGbqrY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=iSyQix6mkgOtW2UhitfLpd+gQVyoR3Hwg6qC6pC6aKXn61EMVlMeCslDMTkSLUxM6l wS6R+zV1XE1MMMT0pK6zrK4L0CZ0chpL8L8psefv/zvJVUjzVuPSM4Jdirn0NWvlSdLk glVGomJi7vX0Vqlw6xD38EUh+1gKHXzXKnxQw= MIME-Version: 1.0 Received: by 10.101.29.20 with SMTP id g20mr1977685anj.34.1256512665342; Sun, 25 Oct 2009 16:17:45 -0700 (PDT) From: kevin Date: Sun, 25 Oct 2009 16:17:25 -0700 Message-ID: Subject: are columns of a supercolumn name sorted? To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=001636b2b4d012e1fc0476caa79e X-Virus-Checked: Checked by ClamAV on apache.org --001636b2b4d012e1fc0476caa79e Content-Type: text/plain; charset=ISO-8859-1 i am inserting three columns x,a,z into a super column named 'sc_2'. the config file says that the columns of a super column are timesorted, but 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=lazyboy.connection.Client(['localhost:9160']) >>> keyspace = "Keyspace1" >>> key='mykeyx' >>> column_path = ColumnPath(column_family="Super1",column="x",super_column='sc_2') >>> client.insert(keyspace, key, column_path, 'a', time.time(), ConsistencyLevel.ONE); >>> column_path = ColumnPath(column_family="Super1",column="a",super_column='sc_2') >>> client.insert(keyspace, key, column_path, 'a', time.time(), ConsistencyLevel.ONE); >>> column_path = ColumnPath(column_family="Super1",column="z",super_column='sc_2') >>> client.insert(keyspace, key, column_path, 'a', time.time(), ConsistencyLevel.ONE); >>> slice_range = SliceRange(start="", finish="") >>> predicate = SlicePredicate(slice_range=slice_range) >>> column_parent = ColumnParent(column_family="Super1") >>> client.get_slice(keyspace, key, column_parent, predicate, ConsistencyLevel.ONE) [ColumnOrSuperColumn(column=None, super_column=SuperColumn(name='sc_2', columns=[Column(timestamp=1256512261, name='a', value='a'), Column(timestamp=1256512252, name='x', value='a'), Column(timestamp=1256512267, name='z', value='a')]))] --001636b2b4d012e1fc0476caa79e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable i am inserting three columns x,a,z into a super column named 'sc_2'= . the config file says that the columns of a super column are timesorted, b= ut when i get_slice it is sorted by the name of the columns. how do i get i= t 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 lazyb= oy latest git clone.
thanks


>>> import lazyboy,time, pprint
>>> = from cassandra import Cassandra
>>> from cassandra.ttypes impor= t *


>>> client=3Dlazyboy.connection.Client(['localh= ost:9160'])
>>> keyspace =3D "Keyspace1"
>>> key=3D'= mykeyx'
>>> column_path =3D ColumnPath(column_family=3D&quo= t;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')
>>> clien= t.insert(keyspace, key, column_path, 'a', time.time(), ConsistencyL= evel.ONE);
>>> column_path =3D ColumnPath(column_family=3D"Super1",= column=3D"z",super_column=3D'sc_2')
>>> clien= t.insert(keyspace, key, column_path, 'a', time.time(), ConsistencyL= evel.ONE);


>>> slice_range =3D SliceRange(start=3D"", finis= h=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', va= lue=3D'a'), Column(timestamp=3D1256512252, name=3D'x', valu= e=3D'a'), Column(timestamp=3D1256512267, name=3D'z', value= =3D'a')]))]
--001636b2b4d012e1fc0476caa79e--