Thanks, I just wanted to make sure I understand how it worke= d. Sounds like the additional mapping vs super column method will work better for my purposes.

From: Benjamin Coverston [mailto:ben.coverston@datastax.com]
Sent: Tuesday, February 08, 2011 2:22 PM
To: user@cassandra.apache.org
Subject: Re: Subcolumn Indexing

Does this just mean the exhaustive list of the column names not all the values? =

No, this means the entire supercolumn, names and value= s. When the client tries to access any subcolumn in the supercolumn it has to = read the entire supercolumn.

So if I have a super column that has a map of keys that only contain two colum= ns max each this shouldn’t really be a performance concern correct? This becomes an issue when you have lots of subcolumns if I’m reading this correctly? I’m looking at using the super column as a good way to clu= ster data, say I was storing home addresses I might use the zipcode as the super column if I cared mostly about accessing data by logical area for instance. Thanks for the help.

That is one way to logically group the values, but I t= hink that a simpler solution may be to store the home address as a single row in= a column family, then use a dynamic column family to store references to thos= e addresses per zip code.

_____________________= __________________________

This e-mail may conta= in information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachm= ents and notify the sender that you have received it in error. Unless specifical= ly indicated, this e-mail is not an offer to buy or sell or a solicitation to = buy or sell any securities, investment products or other financial product or s= ervice, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author an= d do not necessarily represent those of Barclays. This e-mail is subject to term= s available at the following link: www.barcap.com/emaildisclaim= er. By messaging with Barclays you cons= ent to the foregoing. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with it= s registered office at 1 Churchill Place, London, E14 5HP. This email m= ay relate to or be sent from other members of the Barclays Group.<= /o:p>

_____________________= __________________________