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 <[email protected]> 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:[email protected]] > Sent: Friday, 18 June 2010 12:52 AM > > To: [email protected] > 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" > <[email protected]> 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. > ********************************************************************** >
