This is an automated email from the ASF dual-hosted git repository.
kassiez pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 618dfd992c0 [update] Fix SHOW COMPUTE GROUPS (#2093)
618dfd992c0 is described below
commit 618dfd992c0ec8913952ce5129a0eba50521deb4
Author: KassieZ <139741991+kass...@users.noreply.github.com>
AuthorDate: Thu Feb 20 17:27:06 2025 +0800
[update] Fix SHOW COMPUTE GROUPS (#2093)
## Versions
- [x] dev
- [x] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [ ] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../compute-management/SHOW-COMPUTE-GROUPS.md | 41 +++++++++++++---------
.../compute-management/SHOW-COMPUTE-GROUPS.md | 41 +++++++++++++---------
2 files changed, 48 insertions(+), 34 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
b/docs/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
index 59933d6277e..0b68fdb90ff 100644
---
a/docs/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
+++
b/docs/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
@@ -23,12 +23,9 @@ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
-
## Description
-The SHOW COMPUTE GROUPS command is used to display information about all
configured compute groups in the system. Compute groups are logical units used
to manage and organize computational resources, helping users allocate and
utilize system resources more effectively.
-
-This command assists administrators and users in quickly understanding the
existing compute group configurations in the system, including the name,
attributes, and other relevant information for each compute group. This is
particularly useful for resource management, performance optimization, and
system monitoring.
+In the compute storage separation mode, display a list of compute groups that
the current user has permissions to use.
## Syntax
@@ -36,23 +33,33 @@ This command assists administrators and users in quickly
understanding the exist
SHOW COMPUTE GROUPS
```
+## Return Value
+
+Returns a list of compute groups that the current user has permissions for.
+
+- Name - The name of the compute group
+- IsCurrent - Whether the current user is using this compute group
+- Users - Usernames that have set this compute group as their default compute
group
+- BackendNum - The number of backends this compute group has
-## Return Values
+## Example
-This command returns a result set containing the following columns:
+Specify the use of the compute group named `compute_cluster`.
-- `Name`: The name of the compute group.
-- `IsCurrent`: Indicates whether it is the current working compute group.
-- `Users`: Displays the list of users who have permission to use this compute
group.
-- `BackendNum`: Shows the number of backends (compute nodes) currently
allocated to this compute group.
+```sql
+SHOW COMPUTE GROUPS;
+```
-## Related Commands
+The result is:
-- [ALTER SYSTEM ADD
BACKEND](../Administration-Statements/ALTER-SYSTEM-ADD-BACKEND.md)
-- [GRANT](../../account-management/GRANT-TO)
-- [REVOKE](../../account-management/REVOKE-FROM)
-- [SET DEFAULT COMPUTE
GROUP](../Administration-Statements/SET-DEFAULT-COMPUTE-GROUP.md)
+```sql
++-----------------+-----------+-------+------------+
+| Name | IsCurrent | Users | BackendNum |
++-----------------+-----------+-------+------------+
+| compute_cluster | TRUE | | 3 |
++-----------------+-----------+-------+------------+
+```
-## Keywords
+## Usage Note
-SHOW, COMPUTE GROUPS
+If the current user has no permissions for any compute group, `SHOW COMPUTE
GROUPS` will return an empty list.
\ No newline at end of file
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
index 59933d6277e..0b68fdb90ff 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS.md
@@ -23,12 +23,9 @@ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
-
## Description
-The SHOW COMPUTE GROUPS command is used to display information about all
configured compute groups in the system. Compute groups are logical units used
to manage and organize computational resources, helping users allocate and
utilize system resources more effectively.
-
-This command assists administrators and users in quickly understanding the
existing compute group configurations in the system, including the name,
attributes, and other relevant information for each compute group. This is
particularly useful for resource management, performance optimization, and
system monitoring.
+In the compute storage separation mode, display a list of compute groups that
the current user has permissions to use.
## Syntax
@@ -36,23 +33,33 @@ This command assists administrators and users in quickly
understanding the exist
SHOW COMPUTE GROUPS
```
+## Return Value
+
+Returns a list of compute groups that the current user has permissions for.
+
+- Name - The name of the compute group
+- IsCurrent - Whether the current user is using this compute group
+- Users - Usernames that have set this compute group as their default compute
group
+- BackendNum - The number of backends this compute group has
-## Return Values
+## Example
-This command returns a result set containing the following columns:
+Specify the use of the compute group named `compute_cluster`.
-- `Name`: The name of the compute group.
-- `IsCurrent`: Indicates whether it is the current working compute group.
-- `Users`: Displays the list of users who have permission to use this compute
group.
-- `BackendNum`: Shows the number of backends (compute nodes) currently
allocated to this compute group.
+```sql
+SHOW COMPUTE GROUPS;
+```
-## Related Commands
+The result is:
-- [ALTER SYSTEM ADD
BACKEND](../Administration-Statements/ALTER-SYSTEM-ADD-BACKEND.md)
-- [GRANT](../../account-management/GRANT-TO)
-- [REVOKE](../../account-management/REVOKE-FROM)
-- [SET DEFAULT COMPUTE
GROUP](../Administration-Statements/SET-DEFAULT-COMPUTE-GROUP.md)
+```sql
++-----------------+-----------+-------+------------+
+| Name | IsCurrent | Users | BackendNum |
++-----------------+-----------+-------+------------+
+| compute_cluster | TRUE | | 3 |
++-----------------+-----------+-------+------------+
+```
-## Keywords
+## Usage Note
-SHOW, COMPUTE GROUPS
+If the current user has no permissions for any compute group, `SHOW COMPUTE
GROUPS` will return an empty list.
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
