Skip to main content
Version: Candidate-4.0

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​