Alter SAI index

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

Prerequisites

Keyspace created
Table created

SAI index created

Drop indexes.

DROP INDEX IF EXISTS cycling.lastname_idx;
DROP INDEX IF EXISTS cycling.age_idx;
DROP INDEX IF EXISTS cycling.country_idx;
DROP INDEX IF EXISTS cycling.registration_idx;

# LLP: next block is printing twice, can’t figure out why

Create new indexes.

CREATE CUSTOM INDEX lastname_idx ON cycling.cyclist_semi_pro (lastname) 
  USING 'StorageAttachedIndex' 
  WITH OPTIONS = {'case_sensitive': 'false', 'normalize': 'true', 'ascii': 'true'}; 
CREATE CUSTOM INDEX age_idx ON cycling.cyclist_semi_pro (age) 
  USING 'StorageAttachedIndex'; 
CREATE CUSTOM INDEX country_idx ON cycling.cyclist_semi_pro (country) 
  USING 'StorageAttachedIndex' 
  WITH OPTIONS = {'case_sensitive': 'false', 'normalize': 'true', 'ascii': 'true'}; 
CREATE CUSTOM INDEX registration_idx ON cycling.cyclist_semi_pro (registration) 
  USING 'StorageAttachedIndex';

end::dse51[]

Alter SAI index

Prerequisites

Was this helpful?

Give Feedback