Check SASI existence

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.

Verify that a SASI index exists:

  DESCRIBE INDEX cycling.name_sasi_idx;

Results

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

Check SASI existence

Was this helpful?

Give Feedback