Thanks Eric for the information. It looks like it will be supported in future versions.
Raj On Mon, May 19, 2014 at 10:03 AM, Eric Plowe <eric.pl...@gmail.com> wrote: > 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 >> >> > -- 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
