cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raj Janakarajan <...@zephyrhealthinc.com>
Subject Filtering on Collections
Date Mon, 19 May 2014 16:50:19 GMT
Hello all,

I am using Cassandra version 2.0.7.  I am wondering if "collections" is
efficient for filtering.  We are thinking of using "collections" to
maintain a list for a customer row but we have to be able to filter on the
collection values.

Select UUID from customer where eligibility_state IN (CA, NC)

Eligibility_state being a collection.  The above query would be used
frequently.
Would you recommend collections for modeling from a performance perspective?

Raj
-- 

Data Architect ❘ Zephyr Health
589 Howard St. ❘ San Francisco, CA 94105
m: +1 9176477433 ❘ f: +1 415 520-9288
o: +1 415 529-7649 | s: raj.janakarajan

http://www.zephyrhealth.com

Mime
View raw message