Thanks Ben. I've just been trying to nail this down - it's difficult knowing if you are getting it right when it feels like you're going backwards.
Anthony From: Benjamin Black [mailto:b...@b3k.us] Sent: Tuesday, 29 June 2010 1:00 PM To: user@cassandra.apache.org Subject: Re: Understanding SuperColumns On Sun, Jun 27, 2010 at 7:36 PM, Anthony Ikeda <anthony.ik...@cardlink.com.au> wrote: Say my query is: Get all Work addresses in New York and the address owner. Steps to get the data would be: If this is the query you want to run, then you probably just want to put the owner in the index with the address. If you want to be able to ask any arbitrary combination of things in your query, then, yes, you do the denormalization dance and reassemble things from a variety of indices. b _____________________________________________________________________ This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com ********************************************************************** This e-mail message and any attachments are intended only for the use of the addressee(s) named above and may contain information that is privileged and confidential. If you are not the intended recipient, any display, dissemination, distribution, or copying is strictly prohibited. If you believe you have received this e-mail message in error, please immediately notify the sender by replying to this e-mail message or by telephone to (02) 9646 9222. Please delete the email and any attachments and do not retain the email or any attachments in any form. **********************************************************************