Hi, it's possible to create both regular secondary index and SASI on the same column: CREATE TABLE ks.tb (id int PRIMARY KEY, name text); CREATE CUSTOM INDEX tb_name_idx_1 ON ks.tb (name) USING 'org.apache.cassandra.index.sasi.SASIIndex'; CREATE INDEX tb_name_idx ON ks.tb (name);
But which one is used for SELECT? Assuming we have regular index and would like to migrate to SASI, can we first create SASI, than drop regular? And how can we check then index build is completed? Thanks.