Thank you for your help :) On Tue, Aug 13, 2024 at 6:36 PM Caleb Rackliffe <calebrackli...@gmail.com> wrote:
> 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 > >
