Hello all,

I have the following schema:

CREATE TABLE my_table (
    a varchar,
    b varchar,
    c int,
    d varchar,
    e uuid,
    PRIMARY KEY ((a, b), c, d)
)

SELECT * FROM my_table WHERE a=? AND b=? AND e=? ALLOW FILTERING

The query above gives me the following exception message:

com.datastax.driver.core.exceptions.InvalidQueryException: No indexed
columns present in by-columns clause with Equal operator

SELECT * FROM my_table WHERE a=? AND b=?
Works fine and I see not reason why original query should not be able to do
such filtering.

If I add a secondary index by "e" column, then such query will work, but I
do not want to do that.

Cassandra 2.0.5
Driver 2.0.1

Is that a bug/not implemented feature? Or maybe I'm doing something wrong?

Kind regards,
Mikhail.

Reply via email to