Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

contact avatar image
contact asked Erick Ramirez answered

Getting error when creating a SASI index

Hello,

Cassandra returns an error when I try to create a CUSTOM INDEX.

Here is the line to create the table:

CREATE TABLE user_Classification (
    user_id int, 
    user_name text,
    scorpt int,
    PRIMARY KEY(scorpt)
)

Here is the line to create it

CREATE CUSTOM INDEX fn_prefix
ON user_Classification (user_name)
USING 'org.apache.cassandra.index.sasi.SASIIndex';

But cassandra sends me this, I don't know what to do

Error from server: code=2200 [Invalid query] message="Tables cannot have more than 0 SASI indexes, failed to create SASI index fn_prefix on table user_classification"

the aim being to make an order like

Thank you for your help

sstable attached secondary index
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

If you're creating a SASI index on Astra, it isn't supported. SASI is classified as experimental by the Apache project as I've explained in this post -- Why SASI is not supported for production use.

Astra DB includes Storage-Attached Indexing (SAI) however support for the LIKE operator is not available yet. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.