Collection types cannot be used for filtering (as part of the where statement). They cannot be used as a primary key or part of a primary key. Secondary indexes are not supported as well.
On Mon, May 19, 2014 at 12:50 PM, Raj Janakarajan <r...@zephyrhealthinc.com>wrote: > 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 > >
