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 base
d Cassandra access. I’ve been able to create a client that can creat
e data and retrieve a row but I’m struggling to understand how to se
tup 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.
**********************************************************************
