Skip to main content
Version: Preview-4.1

DELETE BACKEND/COMPUTE NOT BLACKLIST

Removes a BE/CN node from the BE Blacklist. Please note that StarRocks will not remove the BE/CN nodes that are manually blacklisted by users.

BE Blacklist is supported from v3.3.0 onwards and CN Blacklist is supported from v4.0 onwards. For more information, see Manage BE and CN Blacklist.

note

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

Syntax

DELETE { BACKEND | COMPUTE NODE } BLACKLIST { <be_id>[, ...] | <cn_id>[, ...] }

Parameters

be_id or cn_id: ID of the BE or CN node to be removed from the blacklist. You can obtain the ID of the blacklisted BE/CN by executing SHOW BACKEND/COMPUTE NODE BLACKLIST.

Examples

DELETE BACKEND BLACKLIST 10001;

Relevant SQLs