incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Сергей Нагайцев <mcd....@gmail.com>
Subject IN predicates on non-primary-key columns (%s) is not yet supported - then will it be ?
Date Fri, 08 Nov 2013 11:58:08 GMT
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 ?

Mime
View raw message