A table which contains a particular field whose value can be updated ... and the same field need to be used in where clause without using "allow filtering"
EDIT - I am managing this by creating a secondary index on that column in question. This column is not part of the PK (partition + clustering).
Using the partition-key and the secondary index, I do the query without using "allow filtering".
EDIT - My scenario is different.
CREATE TABLE users ( city text, name text, age int, gender text, favourite_colour text PRIMARY KEY (city, name) )
1. city+name is unique
2. favourite_colour is updated periodically using :
UPDATE users SET favourite_colour='XXX' WHERE city='CCC' AND name='John'
3. I want to query --- find all the people from LA whose fav color is RED.
4. How about PRIMARY KEY (city, name, favourite_colour) ?