question

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