[
https://issues.apache.org/jira/browse/CASSANDRA-20808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sunil Ramchandra Pawar reassigned CASSANDRA-20808:
--------------------------------------------------
Assignee: Sunil Ramchandra Pawar
> OR is not working on SAI indexes
> --------------------------------
>
> Key: CASSANDRA-20808
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20808
> Project: Apache Cassandra
> Issue Type: Bug
> Reporter: Andrew Grosser
> Assignee: Sunil Ramchandra Pawar
> Priority: Normal
>
> For 5.0.4 (current) release. It seems the sai indexes are off?
>
> Example:
> ```
> cqlsh:sfpla> create index on test(y) using 'sai';
> cqlsh:sfpla> create table test(x timeuuid primary key);
> cqlsh:sfpla> select * from test where y=982c4900-3256-11ef-9772-1e1480865e16
> or y=982c4900-3256-11ef-9772-1e1480865e16;
> SyntaxException: line 1:64 no viable alternative at input 'or' (...from test
> where y=982c4900-3256-11ef-9772-1e1480865e16 [or]...)
> ```
>
> Docs report his is possible:
> https://cassandra.apache.org/doc/latest/cassandra/developing/cql/indexing/sai/sai-query.html
> ```
> This example uses the following table and indexes:
> {{CREATE TABLE IF NOT EXISTS cycling.comments_vs (
> record_id timeuuid, id uuid,
> commenter text, comment text,
> comment_vector VECTOR <FLOAT, 5>,
> created_at timestamp,
> PRIMARY KEY (id, created_at)
> )WITH CLUSTERING ORDER BY (created_at DESC);CREATE INDEX commenter_idx ON
> cycling.comments_vs (commenter) USING 'sai';CREATE INDEX created_at_idx
> ON cycling.comments_vs (created_at) USING 'sai';CREATE INDEX ann_index
> ON cycling.comments_vs (comment_vector) USING 'sai';}}
> Several indexes are created for the table to demonstrate how to query for
> matches on more than one column.
> Query for a match on either one column or the other:
> * Query
> * Result
> {{SELECT * FROM cycling.comments_vs
> WHERE
> created_at='2017-03-21 21:11:09.999000+0000'
> OR created_at='2017-03-22 01:16:59.001000+0000';}}
> {{```}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
