Re: select from table with list collection

2015-02-15 Thread reader 1001
I am using Cassandra 2.1.2. 1) yes, it works fine with any single element of the list "contains 'b'" and "contains 'c'" 2) if I add a second condition, it doesn't work 3) if I change list to set, it works properly, but doesn't work for my use case because i may have duplicates I files a Jira ticke

Re: select from table with list collection

2015-02-15 Thread Jack Krupansky
That should work. File a Jira. While release of Cassandra are you using? There were some bugs is indexing for set collections; maybe that affected list as well. Out of curiosity, does a SELECT with only "contains 'b'" work? Also, try using "set" rather than "list". -- Jack Krupansky On Sun, Feb

select from table with list collection

2015-02-15 Thread reader 1001
I have a simple table with an indexed list field, but it shows unexpected behavior when I query the list. Am i doing something incorrect? create table test (whole text PRIMARY KEY, parts list); create index on test (parts); insert into test (whole,parts) values('a', ['a']); insert into test (whole