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

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

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