It is not a bug/not implemented feature and you are not doing nothing wrong. As you can check on the documentation you can only filter on a key name or a column that has a secondary index created on it:
I have the following schema:
CREATE TABLE my_table (
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.
Is that a bug/not implemented feature? Or maybe I'm doing something wrong?