Couldn't decrease number of shards for table

Hi @Jun_Zhou,

You will need to relocate all shards for that table to a single node using ALTER TABLE spl.state_machine_def SET ("routing.allocation.require._name" = '<selected_node_name>');

There is a complete example here: Guide to decrease the number of shards in your cluster

1 Like