It should be Key4 --> 123 And you store it in the Image CF or the Documents CF or the MultiMedia CF….then it ends up all on the same machine as the CF breaks the row apart.
Dean From: Alicia Leong <lccali...@gmail.com<mailto:lccali...@gmail.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <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>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Subject: Re: Key-Token mapping in cassandra 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 <aa...@thelastpickle.com<mailto:aa...@thelastpickle.com>> 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 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 New Zealand @aaronmorton http://www.thelastpickle.com On 18/04/2013, at 1:32 PM, Ravikumar Govindarajan <ravikumar.govindara...@gmail.com<mailto:ravikumar.govindara...@gmail.com>> wrote: 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 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 Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com<http://www.thelastpickle.com/> On 17/04/2013, at 11:25 PM, Ravikumar Govindarajan <ravikumar.govindara...@gmail.com> wrote: 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 should be the Partitioner that I should most likely extend and write my own to achieve the desired result? -- Ravi
