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: local policy)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=content-type
	:mime-version:subject:from:in-reply-to:date
	:content-transfer-encoding:message-id:references:to; q=dns; s=
	thelastpickle.com; b=E7+eE0HDGL21rhCUQJgHTXyzRpj4ktx2B7UPLiQEzev
	D3apJ0mCC1OHskHi0JeGQhemftYYZVDgR6g6Xh+yZGRTAjot7Nz/tz9CO52sfxKs
	aOlumufCQxZruo1GPgIfVRu+sGCsf/ah17nV89JW2cKltHXnO7IeFYRHPrzIfB4k
	=
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1244.3)
Subject: Re: cassandra-cli: Create column family with composite column name
From: aaron morton <aaron@thelastpickle.com>
In-Reply-To: 
 <CAKYY9A+9QAUQDBjJ4HKW7+5ib0tHD8j11rmbCHtBgWz7Y5V=MQ@mail.gmail.com>
Date: Thu, 6 Oct 2011 09:35:33 +1300
Content-Transfer-Encoding: quoted-printable
Message-Id: <BAEC3054-1F7D-448C-8756-5D833485D318@thelastpickle.com>
References: 
 <CAKYY9A+9QAUQDBjJ4HKW7+5ib0tHD8j11rmbCHtBgWz7Y5V=MQ@mail.gmail.com>
To: user@cassandra.apache.org

Hi Jim,=20

The best resource I know so far is =
http://www.slideshare.net/edanuff/indexing-in-cassandra =20

I just started working on a blog post about them last night, and I hope =
to update the wiki with some information when I am done. Feel free to =
mail me directly if you want to collaborate.=20

I'm none the wiser on the ":" issue, one of the things I was hoping to =
learn about.=20

Cheers

-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 6/10/2011, at 9:08 AM, Jim Ancona wrote:

> Using Cassandra 0.8.6, I've been trying to figure out how to use the
> CLI to create column families using composite keys and column names.
> The documentation on CompositeType seems pretty skimpy. But in the
> course of writing this email to ask how to do it, I figured out the
> proper syntax. In the hope of making it easier for the next person, I
> repurposed this message to document what I figured out. I'll also
> update the wiki. Here is the syntax:
>=20
> create column family MyCF
>    with key_validation_class =3D 'CompositeType(UTF8Type, =
IntegerType)'
>    and comparator =3D 'CompositeType(DateType(reversed=3Dtrue), =
UTF8Type)'
>    and default_validation_class=3D'CompositeType(UTF8Type, DateType)'
>    and column_metadata=3D[
>        { column_name:'0:my Column Name', validation_class:LongType,
> index_type:KEYS}
>    ];
>=20
> One weakness of this syntax is that there doesn't seem to be a way to
> escape a ':' in a composite value. There's a FIXME in the code to that
> effect.
>=20
> Jim