So, building indexes has an “all indexes” coverage with:
BUILD INDEX ON `travel-sample` (( SELECT RAW name FROM system:indexes WHERE keyspace_id = 'travel-sample' AND state = 'deferred' ));
the helpful page
but i cannot find any alter index documentation showing a similar implementation that would have one alter command apply to all indexes at once.
the unhelpful page
Is there a savvy way alter all indexes cluster to have two replicas?
I am currently running a single node cluster and would like to upgrade to a triple node cluster, with two of them having the index service.
ps, the current node will not be having the index service after the upgrade, so a querry that creates replica on two nodes and drops replica on one (for all indexes) would be golden.