[
https://issues.apache.org/jira/browse/CASSANDRA-19829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18016453#comment-18016453
]
Mohammad Suhel Ksolves Cassandra Experties edited comment on CASSANDRA-19829 at
8/27/25 7:25 AM:
-------------------------------------------------------------------------------------------------
Hi [~maedhroz] , thanks for the clarification.
I tested this on my local 5.0 build:
* {{IN}} works only with {{{}ALLOW FILTERING{}}}, which confirms it’s applied
as a post-filter and not by the index.
* {{LIKE}} is not supported (as expected).
* {{OR}} is not supported.
So I am planning to update the docs to:
Numerics: =, <, >, <=, >=, AND, IN (post-filter only, requires ALLOW FILTERING)
Strings: =, CONTAINS, CONTAINS KEY, AND, IN (post-filter only, requires ALLOW
FILTERING)
If this looks good to you, please give me a go-ahead and I’ll make the changes.
was (Author: suhel):
Hi [~maedhroz] , thanks for the clarification.
I tested this on my local 5.0 build:
* {{IN}} works only with {{{}ALLOW FILTERING{}}}, which confirms it’s applied
as a post-filter and not by the index.
* {{LIKE}} is not supported (as expected).
* {{OR}} is not supported.
So I am planning to update the docs to:
Numerics: =, <, >, <=, >=, AND, IN (post-filter only, requires ALLOW FILTERING)
Strings: =, CONTAINS, CONTAINS KEY, AND, IN (post-filter only, requires ALLOW
FILTERING)
{{}}
If this looks good to you, please give me a go-ahead and I’ll make the changes.
{{}}
> Revise support for operators in the SAI docs
> --------------------------------------------
>
> Key: CASSANDRA-19829
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19829
> Project: Apache Cassandra
> Issue Type: Task
> Components: Documentation/Website
> Reporter: Ekaterina Dimitrova
> Assignee: Mohammad Suhel Ksolves Cassandra Experties
> Priority: Normal
> Fix For: 5.0.x, 5.x
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> https://cassandra.apache.org/doc/latest/cassandra/getting-started/sai-quickstart.html#try-out-cql-queries
> We do not support OR yet, I do not think we support IN, too.
> We need to double-check the docs as this will be very disappointing
> experience for users expecting we support certain operators when in reality
> we don't...yet.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
