frontends

Name

SinceVersion dev

frontends

description

表函数，生成frontends临时表，可以查看当前doris集群中的 FE 节点信息。

该函数用于from子句中。

syntax

frontends()

frontends()表结构：

1. mysql> desc function frontends();
2. +-------------------+------+------+-------+---------+-------+
3. | Field             | Type | Null | Key   | Default | Extra |
4. +-------------------+------+------+-------+---------+-------+
5. | Name              | TEXT | No   | false | NULL    | NONE  |
6. | Host              | TEXT | No   | false | NULL    | NONE  |
7. | EditLogPort       | TEXT | No   | false | NULL    | NONE  |
8. | HttpPort          | TEXT | No   | false | NULL    | NONE  |
9. | QueryPort         | TEXT | No   | false | NULL    | NONE  |
10. | RpcPort           | TEXT | No   | false | NULL    | NONE  |
11. | ArrowFlightSqlPort| TEXT | No   | false | NULL    | NONE  |
12. | Role              | TEXT | No   | false | NULL    | NONE  |
13. | IsMaster          | TEXT | No   | false | NULL    | NONE  |
14. | ClusterId         | TEXT | No   | false | NULL    | NONE  |
15. | Join              | TEXT | No   | false | NULL    | NONE  |
16. | Alive             | TEXT | No   | false | NULL    | NONE  |
17. | ReplayedJournalId | TEXT | No   | false | NULL    | NONE  |
18. | LastHeartbeat     | TEXT | No   | false | NULL    | NONE  |
19. | IsHelper          | TEXT | No   | false | NULL    | NONE  |
20. | ErrMsg            | TEXT | No   | false | NULL    | NONE  |
21. | Version           | TEXT | No   | false | NULL    | NONE  |
22. | CurrentConnected  | TEXT | No   | false | NULL    | NONE  |
23. +-------------------+------+------+-------+---------+-------+
24. 17 rows in set (0.022 sec)

frontends() tvf展示出来的信息基本与 show frontends 语句展示出的信息一致,但是 frontends() tvf的各个字段类型更加明确，且可以利用tvf生成的表去做过滤、join等操作。

对 frontends() tvf信息展示进行了鉴权，与 show frontends 行为保持一致，要求用户具有 ADMIN/OPERATOR 权限。

example

1. mysql> select * from frontends()\G
2. *************************** 1. row ***************************
3. Name: fe_5fa8bf19_fd6b_45cb_89c5_25a5ebc45582
4. IP: 10.xx.xx.14
5. EditLogPort: 9013
6. HttpPort: 8034
7. QueryPort: 9033
8. RpcPort: 9023
9. ArrowFlightSqlPort: 9040
10. Role: FOLLOWER
11. IsMaster: true
12. ClusterId: 1258341841
13. Join: true
14. Alive: true
15. ReplayedJournalId: 186
16. LastHeartbeat: 2023-06-15 16:53:12
17. IsHelper: true
18. ErrMsg:
19. Version: doris-0.0.0-trunk-4b18cde0c7
20. CurrentConnected: Yes
21. 1 row in set (0.060 sec)

keywords

1. frontends