FRONTENDS
Descriptionβ
The table function generates the frontends temporary table, which allows you to view the FE node information in the current doris cluster.
Syntaxβ
FRONTENDS()
Access Control Requirementsβ
Privilege | Object | Notes |
---|---|---|
ADMIN_PRIV | global |
Return Valueβ
Field | Description |
---|---|
Name | The unique name of the frontend node. |
Host | The IP address or hostname of the frontend node. |
EditLogPort | The port used for edit log communication. |
HttpPort | The HTTP port for the frontend node. |
QueryPort | The port used for query execution on the frontend node. |
RpcPort | The port used for RPC communication. |
ArrowFlightSqlPort | The Arrow Flight SQL port (used for integration with Apache Arrow for high-performance data transport). |
Role | The role of the frontend node (e.g., FOLLOWER ). |
IsMaster | Indicates whether the node is a master node (true/false). |
ClusterId | The identifier for the cluster to which the frontend node belongs. |
Join | Indicates if the frontend node is part of the cluster (true/false). |
Alive | Indicates if the frontend node is alive (true/false). |
ReplayedJournalId | The last journal ID that was replayed by the frontend node. |
LastStartTime | The timestamp of the last start time of the frontend node. |
LastHeartbeat | The timestamp for the last heartbeat received from the frontend node. |
IsHelper | Indicates whether the frontend node is a helper node (true/false). |
ErrMsg | Any error messages reported by the frontend node. |
Version | The version of the frontend node. |
Examplesβ
show frontends cluster information
select * from frontends();
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-------------------------+------------------+
| Name | Host | EditLogPort | HttpPort | QueryPort | RpcPort | ArrowFlightSqlPort | Role | IsMaster | ClusterId | Join | Alive | ReplayedJournalId | LastStartTime | LastHeartbeat | IsHelper | ErrMsg | Version | CurrentConnected |
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-------------------------+------------------+
| fe_f4642d47_62a2_44a2_b79d_3259050ab9de | 10.xx.xx.90 | 9010 | 8030 | 9030 | 9020 | -1 | FOLLOWER | true | 917153130 | true | true | 555248 | 2025-01-13 14:11:31 | 2025-01-16 14:27:56 | true | | doris-0.0.0--83f899b32b | Yes |
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-------------------------+------------------+