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:

language-bash

  DESCRIBE INDEX cycling.name_sasi_idx;

Results

WARNING: cqlsh was built against 5.0-beta1, but this server is 5.0.  All features may not work!

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