Hello,

I'm experimenting with SAI indexes and following the instructions on this
page
https://cassandra.apache.org/doc/latest/cassandra/developing/cql/indexing/sai/sai-working-with.html#querying-with-sai
But some of the queries are not working for me.
For example,
https://cassandra.apache.org/doc/latest/cassandra/developing/cql/indexing/sai/sai-working-with.html#multiple-indexes-matched-with-in
where it says I can run a query like this with SAI:
SELECT * FROM cycling.comments_vs WHERE created_at IN ('2017-03-21
21:11:09.999000+0000' ,'2017-03-22 01:16:59.001000+0000');
After creating the same table and indexes on my own cassandra, I get this
error:
Cannot execute this query as it might involve data filtering and thus may
have unpredictable performance. If you want to execute this query despite
the performance unpredictability, use ALLOW FILTERING

So do I have to use ALLOW FILTERING even if I have created a SAI index?

I'm using cassandra:5.0-rc1 on Docker.

Thanks in advance

Reply via email to