This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 4c17c37 [Doc]Modify the audit log plugin to record the SQL statement
field type as String (#7798)
4c17c37 is described below
commit 4c17c370e715f07d836504684fe8fc74d7c41d7d
Author: jiafeng.zhang <[email protected]>
AuthorDate: Thu Jan 20 21:36:02 2022 +0800
[Doc]Modify the audit log plugin to record the SQL statement field type as
String (#7798)
Modify the audit log plugin to record the SQL statement field type as String
---
docs/en/extending-doris/audit-plugin.md | 6 +++++-
docs/zh-CN/extending-doris/audit-plugin.md | 6 +++++-
2 files changed, 10 insertions(+), 2 deletions(-)
diff --git a/docs/en/extending-doris/audit-plugin.md
b/docs/en/extending-doris/audit-plugin.md
index 5e5278b..542ddae 100644
--- a/docs/en/extending-doris/audit-plugin.md
+++ b/docs/en/extending-doris/audit-plugin.md
@@ -73,7 +73,7 @@ create table doris_audit_tbl__
cpu_time_ms bigint comment "Total scan cpu time in millisecond of this
query",
sql_hash varchar(50) comment "Hash value for this query",
peak_memory_bytes bigint comment "Peak memory bytes used on all backends
of this query",
- stmt varchar(5000) comment "The original statement, trimed if longer than
5000 bytes"
+ stmt string comment "The original statement, trimed if longer than 2G"
) engine=OLAP
duplicate key(query_id, time, client_ip)
partition by range(time) ()
@@ -89,6 +89,10 @@ properties(
);
```
+>**Notice**
+>
+> In the above table structure: stmt string, this can only be used in 0.15 and
later versions, in previous versions, the field type used varchar
+
The `dynamic_partition` attribute selects the number of days to keep the audit
log based on your needs.
After that, connect to Doris and use the `INSTALL PLUGIN` command to complete
the installation. After successful installation, you can see the installed
plug-ins through `SHOW PLUGINS`, and the status is `INSTALLED`.
diff --git a/docs/zh-CN/extending-doris/audit-plugin.md
b/docs/zh-CN/extending-doris/audit-plugin.md
index 6e92656..fa3fe43 100644
--- a/docs/zh-CN/extending-doris/audit-plugin.md
+++ b/docs/zh-CN/extending-doris/audit-plugin.md
@@ -73,7 +73,7 @@ create table doris_audit_tbl__
cpu_time_ms bigint comment "Total scan cpu time in millisecond of this
query",
sql_hash varchar(48) comment "Hash value for this query",
peak_memory_bytes bigint comment "Peak memory bytes used on all backends
of this query",
- stmt varchar(5000) comment "The original statement, trimed if longer than
5000 bytes"
+ stmt string comment "The original statement, trimed if longer than 2G "
) engine=OLAP
duplicate key(query_id, time, client_ip)
partition by range(time) ()
@@ -89,6 +89,10 @@ properties(
);
```
+>**注意**
+>
+> 上面表结构中：stmt string ，这个只能在0.15及之后版本中使用，之前版本，字段类型使用varchar
+
其中 `dynamic_partition` 属性根据自己的需要，选择审计日志安保留的天数。
之后，连接到 Doris 后使用 `INSTALL PLUGIN` 命令完成安装。安装成功后，可以通过 `SHOW PLUGINS`
看到已经安装的插件，并且状态为 `INSTALLED`。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
