Updating a distributed index

General Discussions - English
1

I have a distributed index, eg.

CREATE TABLE aaa type=‘distributed’ agent=‘manticore-worker0:9312:aaa’;

Then when I want to change the agent, I get an error:

ALTER TABLE aaa type=‘distributed’ agent=‘manticore-worker1:9312:aaa’;
ERROR 1064 (42000): table ‘aaa’ is not found, or not real-time

So how can I alter the agent specified in a distributed table?

2

You need to drop it and create again. Since this is a disitributed table, it’s instant.