Query with SSTable-attached secondary indexes (SASI)

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.

Storage-attached indexes (SAI) can be used in queries to improve performance. SAIs are not a replacement for primary keys, but can be used to improve performance in some cases.

Prerequisites

Query using SASI:

  SELECT * FROM cycling.cyclist_base WHERE name LIKE 'A%';

Results

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

 cid                                  | age | birthday   | country       | name
--------------------------------------+-----+------------+---------------+--------------
 15a116fc-b833-4da6-ab9a-4a7775752836 |  18 | 1997-08-19 | United States | Adrien COSTA
 e7ae5cf3-d358-4d99-b900-85902fda9bb0 |  22 | 1993-06-18 |   New Zealand |   Alex FRAME

(2 rows)

Query with SSTable-attached secondary indexes (SASI)

Prerequisites

Was this helpful?

Give Feedback