try this: CREATE COLUMNFAMILY post ( KEY uuid, author uuid, blog timeuuid, -- sortable name text, data text, PRIMARY KEY ( KEY, blog ) );
create index on post (author); SELECT * FROM post WHERE blog >= 4d6b5fc5-487b-11e3-a6f4-406c8f1838fa AND blog <= 50573ef8-487b-11e3-be65-406c8f1838fa AND author= a6c9f405-487b-11e3-bd38-406c8f1838fa ; works if blog can be modeled this way... ml On Fri, Nov 8, 2013 at 6:58 AM, Сергей Нагайцев <mcd....@gmail.com> wrote: > CREATE COLUMNFAMILY post ( > KEY uuid, > author uuid, > blog uuid, > name text, > data text, > PRIMARY KEY ( KEY ) > ); > > SELECT * FROM post WHERE blog IN (1,2) AND author=3 ALLOW FILTERING; > (don't look at fact numbers are not uuids :) > > Error: IN predicates on non-primary-key columns (blog) is not yet supported > > And how to workaround this ? > Manual index tables ? Any guidelines how to design them ? >