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 69af40ce266 [Doc] Fix plugin related documentation (#1911)
69af40ce266 is described below
commit 69af40ce266f207cf06f040390ddd335d7669c95
Author: xyf <[email protected]>
AuthorDate: Thu Feb 6 10:34:52 2025 +0800
[Doc] Fix plugin related documentation (#1911)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../sql-statements/plugin/INSTALL-PLUGIN.md | 52 +++++++++++---------
.../sql-statements/plugin/SHOW-PLUGINS.md | 44 ++++++++++++-----
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 30 +++++++-----
.../sql-statements/plugin/INSTALL-PLUGIN.md | 52 +++++++++++---------
.../sql-statements/plugin/SHOW-PLUGINS.md | 45 +++++++++++++-----
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 32 +++++++------
.../sql-statements/plugin/INSTALL-PLUGIN.md | 51 +++++++++++---------
.../sql-statements/plugin/SHOW-PLUGINS.md | 42 +++++++++++++----
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 31 +++++++-----
.../sql-statements/plugin/INSTALL-PLUGIN.md | 52 +++++++++++---------
.../sql-statements/plugin/SHOW-PLUGINS.md | 45 +++++++++++++-----
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 32 +++++++------
.../sql-statements/plugin/INSTALL-PLUGIN.md | 55 ++++++++++++----------
.../sql-statements/plugin/SHOW-PLUGINS.md | 48 +++++++++++++------
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 32 +++++++------
.../sql-statements/plugin/INSTALL-PLUGIN.md | 52 +++++++++++---------
.../sql-statements/plugin/SHOW-PLUGINS.md | 44 ++++++++++++-----
.../sql-statements/plugin/UNINSTALL-PLUGIN.md | 30 +++++++-----
18 files changed, 485 insertions(+), 284 deletions(-)
diff --git a/docs/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/docs/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index ff48135b1ac..658ec519b23 100644
--- a/docs/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++ b/docs/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,55 +25,63 @@ under the License.
-->
-
## Description
-This statement is used to install a plugin.
+This statement is used to install a plug-in
-grammar:
+## Syntax
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source supports three types:
+## Required parameters
+
+** 1. `<source>`**
+> The plugin path to be installed, supports three types:
+> 1. An absolute path to a zip file
+> 2. An absolute path to a plugin directory
+> 3. Points to a zip file download path with http or https protocol
+
+## Optional parameters
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> Used to specify properties or parameters when installing a plug-in
+
+## Permission Control
+
+The user executing this SQL command must have at least the following
permissions:
+
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-1. An absolute path to a zip file.
-2. An absolute path to a plugin directory.
-3. Point to a zip file download path with http or https protocol
+## Precautions
+
+Note that you need to place an md5 file with the same name as the .zip file,
such as http://mywebsite.com/plugin.zip.md5 . The content is the MD5 value of
the .zip file.
## Example
-1. Install a local zip file plugin:
+- Install a local zip file plugin:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. Install the plugin in a local directory:
+- Install the plugin in a local directory:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. Download and install a plugin:
+- Download and install a plugin:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
- Note than an md5 file with the same name as the `.zip` file needs to be
placed, such as `http://mywebsite.com/plugin.zip.md5` .
- The content is the MD5 value of the .zip file.
-
-4. Download and install a plugin, and set the md5sum value of the zip file at
the same time:
+- Download and install a plugin, and set the md5sum value of the zip file:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## Keywords
-
- INSTALL, PLUGIN
-
-## Best Practice
-
diff --git a/docs/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/docs/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index cc681cb3032..a38fad73c94 100644
--- a/docs/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++ b/docs/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -27,27 +27,49 @@ under the License.
## Description
-This statement is used to display installed plugins
+This statement is used to display installed plug-ins
-grammar:
+## Syntax
-```SQL
+```sql
SHOW PLUGINS
```
-This command will display all user-installed and system built-in plugins
+## Return Value
+
+| Column | Description |
+| ------ | ----------- |
+| Description | Corresponding plug-in description |
+| Version | Plug-in corresponding version number |
+| JavaVersion | Corresponding Java version number |
+| ClassName | Program class name |
+| SoName | Program shared object name |
+| Sources | Plugin Source |
+| Status | Installation Status |
+| Properties | Plugin Properties |
+
+## Permission Control
+
+The user executing this SQL command must have at least the following
permissions:
+
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
## Example
-1. Show installed plugins:
+- Show installed plugins:
```SQL
SHOW PLUGINS;
```
-## Keywords
-
- SHOW, PLUGINS
-
-## Best Practice
-
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git a/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index c353f03b995..df355585c28 100644
--- a/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++ b/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -29,27 +29,33 @@ under the License.
This statement is used to uninstall a plugin.
-grammar:
+## Syntax:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name can be viewed with the `SHOW PLUGINS;` command.
+## Required parameters
-Only non-builtin plugins can be uninstalled.
+** 1. `<plugin_name>`**
+> The name of the uninstalled plugin
-## Example
+## Permission Control
-1. Uninstall a plugin:
+The user executing this SQL command must have at least the following
permissions:
- ```sql
- UNINSTALL PLUGIN auditdemo;
- ```
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-## Keywords
+## Precautions
- UNINSTALL, PLUGIN
+Only non-builtin plugins can be uninstalled
-## Best Practice
+## Example
+- To uninstall a plugin:
+
+ ```sql
+ UNINSTALL PLUGIN auditdemo;
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index 823aa7b3c13..6609d8c1a78 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,55 +25,63 @@ under the License.
-->
-
-
## 描述
-该语句用于安装一个插件。
+该语句用于安装一个插件
-语法:
+## 语法
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source 支持三种类型:
+## 必选参数
+
+** 1. `<source>`**
+> 待安装插件路径,支持三种类型:
+> 1. 指向一个 zip 文件的绝对路径。
+> 2. 指向一个插件目录的绝对路径。
+> 3. 指向一个 http 或 https 协议的 zip 文件下载路径
+
+## 可选参数
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> 用于指定安装插件时的属性或参数
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
-1. 指向一个 zip 文件的绝对路径。
-2. 指向一个插件目录的绝对路径。
-3. 指向一个 http 或 https 协议的 zip 文件下载路径
+## 注意事项
+
+注意需要放置一个和 .zip 文件同名的 md5 文件,如 http://mywebsite.com/plugin.zip.md5 。其中内容为 .zip
文件的 MD5 值。
## 示例
-1. 安装一个本地 zip 文件插件:
+- 安装一个本地 zip 文件插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. 安装一个本地目录中的插件:
+- 安装一个本地目录中的插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. 下载并安装一个插件:
+- 下载并安装一个插件:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
- 注意需要放置一个和 `.zip` 文件同名的 md5 文件,如 `http://mywebsite.com/plugin.zip.md5`
。其中内容为 .zip 文件的 MD5 值。
-
-4. 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
+- 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## 关键词
-
- INSTALL, PLUGIN
-
-### 最佳实践
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index 056172f715c..e70e8fe48dc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -25,32 +25,51 @@ under the License.
-->
-
-
-
## 描述
该语句用于展示已安装的插件
-语法:
+## 语法
-```SQL
+```sql
SHOW PLUGINS
```
-该命令会展示所有用户安装的和系统内置的插件
+## 返回值
+
+| 列 | 描述 |
+| ------ |----|
+| Description | 对应插件描述 |
+| Version | 插件对应版本号 |
+| JavaVersion | 对应 Java 版本号 |
+| ClassName | 程序类名 |
+| SoName | 程序共享对象名称 |
+| Sources | 插件来源 |
+| Status | 安装状态 |
+| Properties | 插件属性 |
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
## 示例
-1. 展示已安装的插件:
+- 展示已安装的插件:
```SQL
SHOW PLUGINS;
```
-## 关键词
-
- SHOW, PLUGINS
-
-### 最佳实践
-
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index 9ddc26d552c..648f5f4bdd7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -25,33 +25,37 @@ under the License.
-->
-
-
## 描述
-该语句用于卸载一个插件。
+该语句用于卸载一个插件
-语法:
+## 语法:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name 可以通过 `SHOW PLUGINS;` 命令查看。
+## 必选参数
+
+** 1. `<plugin_name>`**
+> 卸载插件的名称
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
+
+## 注意事项
只能卸载非 builtin 的插件。
## 示例
-1. 卸载一个插件:
+- 卸载一个插件:
```sql
UNINSTALL PLUGIN auditdemo;
```
-
-## 关键词
-
- UNINSTALL, PLUGIN
-
-### 最佳实践
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index 0b22f52b531..a2f551fd1f4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,54 +25,63 @@ under the License.
-->
-
## 描述
-该语句用于安装一个插件。
+该语句用于安装一个插件
-语法:
+## 语法
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source 支持三种类型:
+## 必选参数
+
+** 1. `<source>`**
+> 待安装插件路径,支持三种类型:
+> 1. 指向一个 zip 文件的绝对路径。
+> 2. 指向一个插件目录的绝对路径。
+> 3. 指向一个 http 或 https 协议的 zip 文件下载路径
+
+## 可选参数
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> 用于指定安装插件时的属性或参数
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
-1. 指向一个 zip 文件的绝对路径。
-2. 指向一个插件目录的绝对路径。
-3. 指向一个 http 或 https 协议的 zip 文件下载路径
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
+
+## 注意事项
+
+注意需要放置一个和 .zip 文件同名的 md5 文件,如 http://mywebsite.com/plugin.zip.md5 。其中内容为 .zip
文件的 MD5 值。
## 示例
-1. 安装一个本地 zip 文件插件:
+- 安装一个本地 zip 文件插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. 安装一个本地目录中的插件:
+- 安装一个本地目录中的插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. 下载并安装一个插件:
+- 下载并安装一个插件:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
-
- 注意需要放置一个和 `.zip` 文件同名的 md5 文件,如 `http://mywebsite.com/plugin.zip.md5`
。其中内容为 .zip 文件的 MD5 值。
-4. 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
+- 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## 关键词
-
- INSTALL, PLUGIN
-
-## 最佳实践
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index a6b5cd12517..e70e8fe48dc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -29,25 +29,47 @@ under the License.
该语句用于展示已安装的插件
-语法:
+## 语法
-```SQL
+```sql
SHOW PLUGINS
```
-该命令会展示所有用户安装的和系统内置的插件
+## 返回值
+
+| 列 | 描述 |
+| ------ |----|
+| Description | 对应插件描述 |
+| Version | 插件对应版本号 |
+| JavaVersion | 对应 Java 版本号 |
+| ClassName | 程序类名 |
+| SoName | 程序共享对象名称 |
+| Sources | 插件来源 |
+| Status | 安装状态 |
+| Properties | 插件属性 |
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
## 示例
-1. 展示已安装的插件:
+- 展示已安装的插件:
```SQL
SHOW PLUGINS;
```
-## 关键词
-
- SHOW, PLUGINS
-
-## 最佳实践
-
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index 4039afd1f89..648f5f4bdd7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -25,32 +25,37 @@ under the License.
-->
-
## 描述
-该语句用于卸载一个插件。
+该语句用于卸载一个插件
-语法:
+## 语法:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name 可以通过 `SHOW PLUGINS;` 命令查看。
+## 必选参数
+
+** 1. `<plugin_name>`**
+> 卸载插件的名称
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
+
+## 注意事项
只能卸载非 builtin 的插件。
## 示例
-1. 卸载一个插件:
+- 卸载一个插件:
```sql
UNINSTALL PLUGIN auditdemo;
```
-
-## 关键词
-
- UNINSTALL, PLUGIN
-
-## 最佳实践
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index 823aa7b3c13..a2f551fd1f4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,55 +25,63 @@ under the License.
-->
-
-
## 描述
-该语句用于安装一个插件。
+该语句用于安装一个插件
-语法:
+## 语法
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source 支持三种类型:
+## 必选参数
+
+** 1. `<source>`**
+> 待安装插件路径,支持三种类型:
+> 1. 指向一个 zip 文件的绝对路径。
+> 2. 指向一个插件目录的绝对路径。
+> 3. 指向一个 http 或 https 协议的 zip 文件下载路径
+
+## 可选参数
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> 用于指定安装插件时的属性或参数
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
-1. 指向一个 zip 文件的绝对路径。
-2. 指向一个插件目录的绝对路径。
-3. 指向一个 http 或 https 协议的 zip 文件下载路径
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
+
+## 注意事项
+
+注意需要放置一个和 .zip 文件同名的 md5 文件,如 http://mywebsite.com/plugin.zip.md5 。其中内容为 .zip
文件的 MD5 值。
## 示例
-1. 安装一个本地 zip 文件插件:
+- 安装一个本地 zip 文件插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. 安装一个本地目录中的插件:
+- 安装一个本地目录中的插件:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. 下载并安装一个插件:
+- 下载并安装一个插件:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
- 注意需要放置一个和 `.zip` 文件同名的 md5 文件,如 `http://mywebsite.com/plugin.zip.md5`
。其中内容为 .zip 文件的 MD5 值。
-
-4. 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
+- 下载并安装一个插件,同时设置了 zip 文件的 md5sum 的值:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## 关键词
-
- INSTALL, PLUGIN
-
-### 最佳实践
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index 056172f715c..e70e8fe48dc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -25,32 +25,51 @@ under the License.
-->
-
-
-
## 描述
该语句用于展示已安装的插件
-语法:
+## 语法
-```SQL
+```sql
SHOW PLUGINS
```
-该命令会展示所有用户安装的和系统内置的插件
+## 返回值
+
+| 列 | 描述 |
+| ------ |----|
+| Description | 对应插件描述 |
+| Version | 插件对应版本号 |
+| JavaVersion | 对应 Java 版本号 |
+| ClassName | 程序类名 |
+| SoName | 程序共享对象名称 |
+| Sources | 插件来源 |
+| Status | 安装状态 |
+| Properties | 插件属性 |
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
## 示例
-1. 展示已安装的插件:
+- 展示已安装的插件:
```SQL
SHOW PLUGINS;
```
-## 关键词
-
- SHOW, PLUGINS
-
-### 最佳实践
-
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index 9ddc26d552c..648f5f4bdd7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -25,33 +25,37 @@ under the License.
-->
-
-
## 描述
-该语句用于卸载一个插件。
+该语句用于卸载一个插件
-语法:
+## 语法:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name 可以通过 `SHOW PLUGINS;` 命令查看。
+## 必选参数
+
+** 1. `<plugin_name>`**
+> 卸载插件的名称
+
+## 权限控制
+
+执行此 SQL 命令的用户必须至少具有以下权限:
+
+| 权限 | 对象 | 说明 |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | 整个集群 | 需要对整个集群具有管理权限 |
+
+## 注意事项
只能卸载非 builtin 的插件。
## 示例
-1. 卸载一个插件:
+- 卸载一个插件:
```sql
UNINSTALL PLUGIN auditdemo;
```
-
-## 关键词
-
- UNINSTALL, PLUGIN
-
-### 最佳实践
-
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index 18c6a7e7081..658ec519b23 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,56 +25,63 @@ under the License.
-->
-
-
## Description
-This statement is used to install a plugin.
+This statement is used to install a plug-in
-grammar:
+## Syntax
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source supports three types:
+## Required parameters
+
+** 1. `<source>`**
+> The plugin path to be installed, supports three types:
+> 1. An absolute path to a zip file
+> 2. An absolute path to a plugin directory
+> 3. Points to a zip file download path with http or https protocol
+
+## Optional parameters
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> Used to specify properties or parameters when installing a plug-in
+
+## Permission Control
+
+The user executing this SQL command must have at least the following
permissions:
-1. An absolute path to a zip file.
-2. An absolute path to a plugin directory.
-3. Point to a zip file download path with http or https protocol
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-## Examples
+## Precautions
-1. Install a local zip file plugin:
+Note that you need to place an md5 file with the same name as the .zip file,
such as http://mywebsite.com/plugin.zip.md5 . The content is the MD5 value of
the .zip file.
+
+## Example
+
+- Install a local zip file plugin:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. Install the plugin in a local directory:
+- Install the plugin in a local directory:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. Download and install a plugin:
+- Download and install a plugin:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
- Note than an md5 file with the same name as the `.zip` file needs to be
placed, such as `http://mywebsite.com/plugin.zip.md5` .
- The content is the MD5 value of the .zip file.
-
-4. Download and install a plugin, and set the md5sum value of the zip file at
the same time:
+- Download and install a plugin, and set the md5sum value of the zip file:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## Keywords
-
- INSTALL, PLUGIN
-
-## Best Practice
-
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index b4268d82ab2..a38fad73c94 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -25,31 +25,51 @@ under the License.
-->
-
-
## Description
-This statement is used to display installed plugins
+This statement is used to display installed plug-ins
-grammar:
+## Syntax
-```SQL
+```sql
SHOW PLUGINS
```
-This command will display all user-installed and system built-in plugins
+## Return Value
-## Examples
+| Column | Description |
+| ------ | ----------- |
+| Description | Corresponding plug-in description |
+| Version | Plug-in corresponding version number |
+| JavaVersion | Corresponding Java version number |
+| ClassName | Program class name |
+| SoName | Program shared object name |
+| Sources | Plugin Source |
+| Status | Installation Status |
+| Properties | Plugin Properties |
-1. Show installed plugins:
+## Permission Control
- ```SQL
- SHOW PLUGINS;
- ```
+The user executing this SQL command must have at least the following
permissions:
-## Keywords
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
- SHOW, PLUGINS
+## Example
-## Best Practice
+- Show installed plugins:
+ ```SQL
+ SHOW PLUGINS;
+ ```
+
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index 85dbfc81f71..df355585c28 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -25,33 +25,37 @@ under the License.
-->
-
-
## Description
This statement is used to uninstall a plugin.
-grammar:
+## Syntax:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name can be viewed with the `SHOW PLUGINS;` command.
+## Required parameters
-Only non-builtin plugins can be uninstalled.
+** 1. `<plugin_name>`**
+> The name of the uninstalled plugin
-## Examples
+## Permission Control
-1. Uninstall a plugin:
+The user executing this SQL command must have at least the following
permissions:
- ```sql
- UNINSTALL PLUGIN auditdemo;
- ```
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-## Keywords
+## Precautions
- UNINSTALL, PLUGIN
+Only non-builtin plugins can be uninstalled
-## Best Practice
+## Example
+- To uninstall a plugin:
+
+ ```sql
+ UNINSTALL PLUGIN auditdemo;
+ ```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
index ff48135b1ac..658ec519b23 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/INSTALL-PLUGIN.md
@@ -25,55 +25,63 @@ under the License.
-->
-
## Description
-This statement is used to install a plugin.
+This statement is used to install a plug-in
-grammar:
+## Syntax
```sql
-INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+INSTALL PLUGIN FROM <source> [PROPERTIES ("<key>"="<value>", ...)]
```
-source supports three types:
+## Required parameters
+
+** 1. `<source>`**
+> The plugin path to be installed, supports three types:
+> 1. An absolute path to a zip file
+> 2. An absolute path to a plugin directory
+> 3. Points to a zip file download path with http or https protocol
+
+## Optional parameters
+
+** 1. `[PROPERTIES ("<key>"="<value>", ...)]`**
+> Used to specify properties or parameters when installing a plug-in
+
+## Permission Control
+
+The user executing this SQL command must have at least the following
permissions:
+
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-1. An absolute path to a zip file.
-2. An absolute path to a plugin directory.
-3. Point to a zip file download path with http or https protocol
+## Precautions
+
+Note that you need to place an md5 file with the same name as the .zip file,
such as http://mywebsite.com/plugin.zip.md5 . The content is the MD5 value of
the .zip file.
## Example
-1. Install a local zip file plugin:
+- Install a local zip file plugin:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
```
-2. Install the plugin in a local directory:
+- Install the plugin in a local directory:
```sql
INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
```
-3. Download and install a plugin:
+- Download and install a plugin:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
```
- Note than an md5 file with the same name as the `.zip` file needs to be
placed, such as `http://mywebsite.com/plugin.zip.md5` .
- The content is the MD5 value of the .zip file.
-
-4. Download and install a plugin, and set the md5sum value of the zip file at
the same time:
+- Download and install a plugin, and set the md5sum value of the zip file:
```sql
INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum"
= "73877f6029216f4314d712086a146570");
```
-
-## Keywords
-
- INSTALL, PLUGIN
-
-## Best Practice
-
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
index cc681cb3032..a38fad73c94 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/SHOW-PLUGINS.md
@@ -27,27 +27,49 @@ under the License.
## Description
-This statement is used to display installed plugins
+This statement is used to display installed plug-ins
-grammar:
+## Syntax
-```SQL
+```sql
SHOW PLUGINS
```
-This command will display all user-installed and system built-in plugins
+## Return Value
+
+| Column | Description |
+| ------ | ----------- |
+| Description | Corresponding plug-in description |
+| Version | Plug-in corresponding version number |
+| JavaVersion | Corresponding Java version number |
+| ClassName | Program class name |
+| SoName | Program shared object name |
+| Sources | Plugin Source |
+| Status | Installation Status |
+| Properties | Plugin Properties |
+
+## Permission Control
+
+The user executing this SQL command must have at least the following
permissions:
+
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
## Example
-1. Show installed plugins:
+- Show installed plugins:
```SQL
SHOW PLUGINS;
```
-## Keywords
-
- SHOW, PLUGINS
-
-## Best Practice
-
+ ```text
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | Name | Type | Description
| Version | JavaVersion | ClassName
| SoName | Sources | Status | Properties |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ | __builtin_AuditLoader | AUDIT | builtin audit loader, to load
audit log to internal table | 2.1.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLoader | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_AuditLogBuilder | AUDIT | builtin audit logger
| 0.12.0 | 1.8.31 |
org.apache.doris.plugin.audit.AuditLogBuilder | NULL | Builtin |
INSTALLED | {} |
+ | __builtin_SqlDialectConverter | DIALECT | builtin sql dialect converter
| 2.1.0 | 1.8.31 |
org.apache.doris.plugin.dialect.HttpDialectConverterPlugin | NULL | Builtin |
INSTALLED | {} |
+
+-------------------------------+---------+-----------------------------------------------------------+---------+-------------+------------------------------------------------------------+--------+---------+-----------+------------+
+ ```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index c353f03b995..df355585c28 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -29,27 +29,33 @@ under the License.
This statement is used to uninstall a plugin.
-grammar:
+## Syntax:
```sql
-UNINSTALL PLUGIN plugin_name;
+UNINSTALL PLUGIN <plugin_name>;
```
- plugin_name can be viewed with the `SHOW PLUGINS;` command.
+## Required parameters
-Only non-builtin plugins can be uninstalled.
+** 1. `<plugin_name>`**
+> The name of the uninstalled plugin
-## Example
+## Permission Control
-1. Uninstall a plugin:
+The user executing this SQL command must have at least the following
permissions:
- ```sql
- UNINSTALL PLUGIN auditdemo;
- ```
+| Permissions | Object | Notes |
+|:-----------|:-----|:--------------|
+| ADMIN_PRIV | The entire cluster | Requires administrative privileges for the
entire cluster |
-## Keywords
+## Precautions
- UNINSTALL, PLUGIN
+Only non-builtin plugins can be uninstalled
-## Best Practice
+## Example
+- To uninstall a plugin:
+
+ ```sql
+ UNINSTALL PLUGIN auditdemo;
+ ```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]