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:ezra@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.Ikeda@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.
**********************************************************************