Creating index on part of composite key with Cassandra 1.2.0-beta1

2012-11-05 Thread Maxim Veksler
Hi, I'm attempting to build an index on a column acting as part of a composite key. This is what I have so far: CREATE TABLE userinfo2 ( campaignId int, TS timestamp, somevalue text, PRIMARY KEY (campaignId, TS) ); INSERT INTO userinfo2 (campaignId, TS,

Re: Creating index on part of composite key with Cassandra 1.2.0-beta1

2012-11-05 Thread Sylvain Lebresne
On Mon, Nov 5, 2012 at 10:53 AM, Maxim Veksler ma...@vekslers.org wrote: Are indexes on composite column supported ? Index on any part of the PRIMARY KEY is not supported (whether the PRIMARY KEY is composite or not btw), not yet at least. If not, a suggestion for a work around? In your

Re: Creating index on part of composite key with Cassandra 1.2.0-beta1

2012-11-05 Thread Maxim Veksler
OK, A different question then, Is there any meaning of discussing composite key not in the context of a table primary key ? For making additional hierarchy inside a single row by using columns. On Mon, Nov 5, 2012 at 12:14 PM, Sylvain Lebresne sylv...@datastax.comwrote: On Mon, Nov 5, 2012 at