Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

DROP OBSERVER

Description​

This statement deletes the node with the OBSERVER role of FRONTEND (only used by administrators!)

Syntax​

ALTER SYSTEM DROP OBSERVER "<observer_host>:<edit_log_port>"

Required Parameters​

1. <observer_host>

Can be the hostname or IP address of the FE node

2. <edit_log_port>

bdbje communication port of FE node, the default is 9010

Access Control Requirements​

The user executing this SQL command must have at least the following permissions:

PrivilegeObjectNotes
NODE_PRIV

Usage Notes​

  1. After deleting the OBSERVER node, use the SHOW FRONTENDS command to verify that they were successfully deleted.

Examples​

  1. Deleting an OBSERVER node

    ALTER SYSTEM DROP OBSERVER "host_ip:9010"

    This command deletes an OBSERVER node in the cluster (IP host_ip, port 9010)