[incubator-doris] branch master updated: [Doc]Modify the audit log plugin to record the SQL statement field type as String (#7798)

[jiafengzheng]

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 <zhang...@gmail.com>
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org