Alter SASI index

SASI indexes cannot be altered. If you need to modify an SASI index, you will need to drop the current index, create a new index, and rebuild the cycling.

Prerequisites

Keyspace created

Table created

Drop index

  DROP INDEX IF EXISTS cycling.name_sasi_idx;

Create new index

  CREATE CUSTOM INDEX IF NOT EXISTS name_sasi_idx 
    ON cycling.cyclist_base (name)
    USING 'org.apache.cassandra.index.sasi.SASIIndex';

Alter SASI index

Prerequisites

Was this helpful?

Give Feedback