The short answer is that the OR and IN (which is basically OR under the hood) operators are not supported yet in 5.0. See https://issues.apache.org/jira/browse/CASSANDRA-19829
> On Aug 13, 2024, at 3:51 AM, Soheil Rahsaz <soheilrahsaz...@gmail.com> wrote: > > > 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
