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