select - Cassandra 1.2 CQL query set -

i have table in cassandra containing name, item.

using following data types: name text, item set<text>.

f.e. have these entries:

name | item    | {item1, item3} b    | {item2, item3} c    | {item1, item2}

now question: there way names having item1?

i tried this, didn't work:

select name  table  item = 'item1';

i error 'item1' string, item set<text>.

i guess there way this, can't think of how.

thanks in advance.

unlikely not yet supported in cassandra. may in upcoming version able index collection items.

Three