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
