Skip to main content
Version: Latest-3.5

DELETE BACKEND BLACKLIST

DELETE BACKEND BLACKLIST removes a BE node from the BE Blacklist. Please note that StarRocks will not remove the BE nodes that are manually blacklisted by users.

This feature is supported from v3.3.0 onwards. For more information, see Manage BE Blacklist.

note

Only users with the SYSTEM-level BLACKLIST privilege can perform this operation.

Syntax​

DELETE BACKEND BLACKLIST <be_id>[, ...]

Parameters​

be_id: ID of the BE node to be removed from the blacklist. You can obtain the ID of the blacklisted BE by executing SHOW BACKEND BLACKLIST.

Examples​

DELETE BACKEND BLACKLIST 10001;

Relevant SQLs​