morrySnow commented on code in PR #1807:
URL: https://github.com/apache/doris-website/pull/1807#discussion_r1917828525
##########
docs/sql-manual/sql-functions/table-valued-functions/backends.md:
##########
@@ -24,89 +24,69 @@ specific language governing permissions and limitations
under the License.
-->
-## `backends`
+## Description
-### Name
+The table function generates the backends temporary table, and you can view
the BE node information in the current doris cluster.
-backends
-
-### description
+## Syntax
+```sql
+backends()
+```
-Table-Value-Function, generate a temporary table named `backends`. This tvf is
used to view the information of BE nodes in the doris cluster.
+## Access Control Requirements
-This function is used in `FROM` clauses.
+| Privilege | Object | Notes |
+| :--------- |:-------|:------|
+| ALTER_PRIV | global | |
-#### syntax
+## Examples
+show backends cluster information
+```sql
+show backends();
Review Comment:
我们没有`show backends();` 吧？这行是不是应该删掉？
##########
docs/sql-manual/sql-functions/table-valued-functions/backends.md:
##########
@@ -24,89 +24,69 @@ specific language governing permissions and limitations
under the License.
-->
-## `backends`
+## Description
-### Name
+The table function generates the backends temporary table, and you can view
the BE node information in the current doris cluster.
-backends
-
-### description
+## Syntax
+```sql
+backends()
Review Comment:
use upper case
```suggestion
BACKENDS()
```
##########
docs/sql-manual/sql-functions/table-valued-functions/backends.md:
##########
@@ -24,89 +24,69 @@ specific language governing permissions and limitations
under the License.
-->
-## `backends`
+## Description
-### Name
+The table function generates the backends temporary table, and you can view
the BE node information in the current doris cluster.
-backends
-
-### description
+## Syntax
+```sql
+backends()
+```
-Table-Value-Function, generate a temporary table named `backends`. This tvf is
used to view the information of BE nodes in the doris cluster.
+## Access Control Requirements
-This function is used in `FROM` clauses.
+| Privilege | Object | Notes |
+| :--------- |:-------|:------|
+| ALTER_PRIV | global | |
-#### syntax
+## Examples
+show backends cluster information
+```sql
+show backends();
+select * from backends();
+```
-`backends()`
+```text
++-----------+-----------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+----------+-----------+
+| BackendId | Host | HeartbeatPort | BePort | HttpPort | BrpcPort |
ArrowFlightSqlPort | LastStartTime | LastHeartbeat | Alive |
SystemDecommissioned | TabletNum | DataUsedCapacity | TrashUsedCapacity |
AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | RemoteUsedCapacity |
Tag | ErrMsg | Version | Status
| HeartbeatFailureCounter | NodeRole |
CpuCores | Memory |
++-----------+-----------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+----------+-----------+
+| 10020 | 10.xx.xx.90 | 9050 | 9060 | 8040 | 8060 | -1
| 2025-01-13 14:11:31 | 2025-01-16 13:24:55 | true | false
| 359 | 295.328 MB | 0.000 | 231.236 GB |
3.437 TB | 93.43 % | 93.43 % | 0.000 | {"location" :
"default"} | | doris-0.0.0--83f899b32b |
{"lastSuccessReportTabletsTime":"2025-01-16
13:24:07","lastStreamLoadTime":1737004982210,"isQueryDisabled":false,"isLoadDisabled":false,"isActive":true,"currentFragmentNum":0,"lastFragmentUpdateTime":1737004982195}
| 0 | mix | 96 | 375.81 GB |
++-----------+-----------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+----------+-----------+
+```
-The table schema of `backends()` tvf：
+backends() table schema
Review Comment:
不要放到示例中，放到返回值小节吧
##########
docs/sql-manual/sql-functions/table-valued-functions/frontends.md:
##########
@@ -24,79 +24,62 @@ specific language governing permissions and limitations
under the License.
-->
-## `frontends`
+## Description
-### Name
+The table function generates the frontends temporary table, which allows you
to view the FE node information in the current doris cluster.
-frontends
-
-### description
-
-Table-Value-Function, generate a temporary table named `frontends`. This tvf
is used to view the information of BE nodes in the doris cluster.
-
-This function is used in `FROM` clauses.
+## Syntax
+```sql
+frontends()
Review Comment:
```suggestion
FRONTENDS()
```
##########
docs/sql-manual/sql-functions/table-valued-functions/frontends.md:
##########
Review Comment:
整体上，需要做和 backends 同样的改动
##########
docs/sql-manual/sql-functions/table-valued-functions/backends.md:
##########
@@ -24,89 +24,69 @@ specific language governing permissions and limitations
under the License.
-->
-## `backends`
+## Description
-### Name
+The table function generates the backends temporary table, and you can view
the BE node information in the current doris cluster.
-backends
-
-### description
+## Syntax
+```sql
+backends()
+```
Review Comment:
需要一个返回值的章节，介绍生成的表的每一列的意义
##########
docs/sql-manual/sql-functions/table-valued-functions/backends.md:
##########
@@ -24,89 +24,69 @@ specific language governing permissions and limitations
under the License.
-->
-## `backends`
+## Description
-### Name
+The table function generates the backends temporary table, and you can view
the BE node information in the current doris cluster.
-backends
-
-### description
+## Syntax
+```sql
+backends()
+```
-Table-Value-Function, generate a temporary table named `backends`. This tvf is
used to view the information of BE nodes in the doris cluster.
+## Access Control Requirements
-This function is used in `FROM` clauses.
+| Privilege | Object | Notes |
+| :--------- |:-------|:------|
+| ALTER_PRIV | global | |
Review Comment:
应该不是alter_priv 而是 ADMIN_PRIV 或者 NODE_PRIV
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
