I'm certain I didn't mention Lucandra, but yes I get the idea about the concepts: * Use indexing tool to reference with queries that returns keys * Store and retrieve data from Cassandra by the keys
Anthony -----Original Message----- From: Benjamin Black [mailto:b...@b3k.us] Sent: Friday, 18 June 2010 1:13 PM To: user@cassandra.apache.org Subject: Re: Best documentation for Java and Cassandra? Lucandra is not a framework, it is Lucene on top of Cassandra. You seem to be falling into the most common trap for relational folks coming to column stores: trying to model your _data_ instead of trying to model your _queries_. You _must_ use the tools as intended to achieve good results. b On Thu, Jun 17, 2010 at 4:12 PM, Anthony Ikeda <anthony.ik...@cardlink.com.au> wrote: > Okay, so that is where frameworks such as Lucene come into play. > > > > Right now we have set up Cassandra and are trying to come up with the best > schema, per se, that is going to be the most effective and I think I'll need > to start looking at something like Lucene to ensure the model can be more > viable. > > > > Thanks, > > Anthony > > > > > > > > From: Ezra Epstein [mailto:e...@ezraepstein.com] > Sent: Friday, 18 June 2010 12:52 AM > > To: user@cassandra.apache.org > Subject: Re: Best documentation for Java and Cassandra? > > > > Hi Anthony, > > > > As I understand it Cassandra, like most other "no SQL" alternative data > stores does not support arbitrary queries. Translation: you can't directly > query by field (that is to say, column) value. You are left with doing a > "row scan" client side. Hence you need to know what queries will be needed a > priori. For the example you gave you'd want a "color" ColumnFamily where the > keys are the color values and the values are whatever you choose - propably > keys to other ColumnFamilies that hold the relevant record data. > > > > HTH, > > Ezra > > > > On Jun 17, 2010, at 12:04 AM, "Anthony Ikeda" > <anthony.ik...@cardlink.com.au> wrote: > > I'm wondering if anyone can suggest the best resources for Java based > Cassandra access. I've been able to create a client that can create data and > retrieve a row but I'm struggling to understand how to setup queries based > on criteria (e.g. return all keys that have a the field "color" equal to > "red"). > > > > Any suggestions? > > > > Anthony Ikeda > > Java Analyst/Programmer > > Cardlink Services Limited > > Level 4, 3 Rider Boulevard > > Rhodes NSW 2138 > > > > Web: www.cardlink.com.au | Tel: + 61 2 9646 9221 | Fax: + 61 2 9646 9283 > > <image001.gif> > > > > ********************************************************************** > 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. > ********************************************************************** > > _____________________________________________________________________ > > 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. > ********************************************************************** > _____________________________________________________________________ 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. **********************************************************************
