Re: Key-Token mapping in cassandra

2013-04-21 Thread aaron morton
> There are many more such CFs all with prefixes of "grpId". By hashing grpId > to cassandra's token, I thought we can co-locate all the group's data into > one set of replicated nodes. > > Is there a way to achieve this? No. Rows with the same row key are stored on the same nodes. Rows with d

Re: Key-Token mapping in cassandra

2013-04-19 Thread Ravikumar Govindarajan
I think I have simplified my example a little too much. Lets assume that there are groups and users. Ideally a grpId becomes the key and it holds some meta-data. Lets say GroupMetaCF grpId --> key, entityId --> col-name, blobdata --> col-value Now we have a UserTimeSeriesCF grpId/userId --> k

Re: Key-Token mapping in cassandra

2013-04-19 Thread Hiller, Dean
rg<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Thursday, April 18, 2013 8:24 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Key-Token mapping in cassandra Hi Ravi Key1 -->

Re: Key-Token mapping in cassandra

2013-04-18 Thread Alicia Leong
Hi Ravi Key1 --> 123/IMAGE Key2 --> 123/DOCUMENTS Key3 --> 123/MULTIMEDIA Which one is your ROW KEY ?? It is Key1,Key2,Key3? On Thu, Apr 18, 2013 at 3:56 PM, aaron morton wrote: > All rows with the same key go on the same nodes. So if you use the same > row key in different CF's they will

Re: Key-Token mapping in cassandra

2013-04-18 Thread aaron morton
All rows with the same key go on the same nodes. So if you use the same row key in different CF's they will be on the same nodes. i.e. have CF's called Image, Documents, Meta and store rows in all of them with the 123 key. Cheers - Aaron Morton Freelance Cassandra Consultant Ne

Re: Key-Token mapping in cassandra

2013-04-17 Thread Ravikumar Govindarajan
Thanks Aaron. We are looking at co-locating all keys for a given user in one Cassandra node. Are there any other ways to achieve this -- Ravi On Thursday, April 18, 2013, aaron morton wrote: > CASSANDRA-1034 > > That ticket is about removing an assumption which was not correct. > > I would like

Re: Key-Token mapping in cassandra

2013-04-17 Thread aaron morton
> CASSANDRA-1034 That ticket is about removing an assumption which was not correct. > I would like all keys with "123" as prefix to be mapped to a single token. Why? it's not possible nor desirable IMHO. Tokens are used to identify a single row internally. Cheers - Aaron Mor

Key-Token mapping in cassandra

2013-04-17 Thread Ravikumar Govindarajan
We would like to map multiple keys to a single token in cassandra. I believe this should be possible now with CASSANDRA-1034 Ex: Key1 --> 123/IMAGE Key2 --> 123/DOCUMENTS Key3 --> 123/MULTIMEDIA I would like all keys with "123" as prefix to be mapped to a single token. Is this possible? What sh