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