The below CQL query resulted in an error saying
No indexed columns present in by-columns clause with equals operator
Note that the column age was already secondary indexed.
select * from employee where age > 25
However I had another secondary indexed column type. So when I used that...
select * from employee where type='engineer' and age > 25
I seemed to get proper results.
How does this happen?