Alter SASI index

Astra DB and DSE 6.9 do not support SSTable-Attached Secondary Indexing (SASI). SASI is an experimental feature in Apache Cassandra® and Hyper-Converged Database, and a beta feature in DataStax Enterprise 6.8.

DataStax does not recommend using SASI in production. Instead, use Storage Attached Indexes (SAI) for indexing in Cassandra 5.0 or later, DSE 6.8 or later, HCD, and Astra DB.

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