Nope, I didn’t comment on that query. I specifically answered your question about "select * from hello where a='foo' allow filtering;”
The query you’ve listed here looks like it would also do a full table scan (again, I don’t see how it would be avoided).
I recommend firing up a 3 node cluster using CCM, creating a key space with RF=1, and seeing what it does.
Are you saying The following query select max(b) from hello where a='a1' allow filtering; doesn't result in a table scan? I got the result for this query and yes I just tried tracing it and looks like it is indeed doing a table scan on ReadStage-2 although I am not sure if I am interpreting it right? Finally is there anyway to prevent table scan while providing the partial partition key and get the max b ?
<Screen Shot 2017-05-09 at 7.07.46 AM.png>