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 wrote: > On Mon, Nov 5, 2012 at 10

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, somevalue

Re: Range scan returns more results then expected (Using ByteOrderedPartitioner)

2011-01-24 Thread Maxim Veksler
gt; > Hope that helps. > Aaron > > On 25 Jan, 2011,at 09:32 AM, Maxim Veksler wrote: > > Hello, > > Cassandra is configure as following: > > conf/cassandra.yaml | grep 'partitioner:' > partitioner: org.apache.cassandra.dhtByteOrderedPartitioner > > >

Range scan returns more results then expected (Using ByteOrderedPartitioner)

2011-01-24 Thread Maxim Veksler
Hello, Cassandra is configure as following: conf/cassandra.yaml | grep 'partitioner:' partitioner: org.apache.cassandra.dht.ByteOrderedPartitioner Why yet doing range query on part of the key return more results then expected (column, CF and keyspace names masked): [default@KEYSPACE] list CF1

Re: Does Cassandra support range queries on keys ?

2011-01-23 Thread Maxim Veksler
Thank you Peter. Following your suggestions, of using key of super column as range token won't I have a storage problem? I couldn't find information about this so I'll just ask: If I have a (Super/)ColumnFamily that contains 1 "key" for the row but that row contains millions of k:v entries. Would

Does Cassandra support range queries on keys ?

2011-01-19 Thread Maxim Veksler
Hello everyone, I'm new to dynamo. I'm looking to implement something similar to prefix search for keys (much like S3 allows you to list all the keys that match a certain prefix). Can I implement this with Cassandra? I'm using Hector as the client but would gladly go thrift is necessary. Thank