This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 2ff4e9d79d [typo](doc)modify some sql syntax description errors
(#22420)
2ff4e9d79d is described below
commit 2ff4e9d79dc8e241f152bdc8034200d950d4fecd
Author: ZhenchaoXu <[email protected]>
AuthorDate: Wed Aug 2 21:28:02 2023 +0800
[typo](doc)modify some sql syntax description errors (#22420)
---
docs/en/docs/query-acceleration/statistics.md | 4 ++--
.../Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md | 2 +-
.../sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md | 2 +-
.../Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md | 2 +-
.../Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md | 4 ++--
docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md | 2 +-
docs/zh-CN/docs/query-acceleration/statistics.md | 4 ++--
.../Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md | 2 +-
.../sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md | 2 +-
.../Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md | 2 +-
.../Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md | 4 ++--
docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md | 2 +-
12 files changed, 16 insertions(+), 16 deletions(-)
diff --git a/docs/en/docs/query-acceleration/statistics.md
b/docs/en/docs/query-acceleration/statistics.md
index 7cbed02b62..275d671a84 100644
--- a/docs/en/docs/query-acceleration/statistics.md
+++ b/docs/en/docs/query-acceleration/statistics.md
@@ -79,7 +79,7 @@ The user triggers a manual collection job through a statement
`ANALYZE` to colle
Column statistics collection syntax:
```SQL
-ANALYZE TABLE | DATABASE table_name | db_name
+ANALYZE < TABLE | DATABASE table_name | db_name >
[ PARTITIONS (partition_name [, ...]) ]
[ (column_name [, ...]) ]
[ [ WITH SYNC ] [ WITH INCREMENTAL ] [ WITH SAMPLE PERCENT | ROWS ] [ WITH
PERIOD ] [WITH HISTOGRAM]]
@@ -463,7 +463,7 @@ Collect information for the job by `SHOW ANALYZE` viewing
the statistics.
The syntax is as follows:
```SQL
-SHOW ANALYZE [ table_name | job_id ]
+SHOW ANALYZE < table_name | job_id >
[ WHERE [ STATE = [ "PENDING" | "RUNNING" | "FINISHED" | "FAILED" ] ] ];
```
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
index eeb02fa580..069e740b66 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
@@ -67,7 +67,7 @@ If `swap` is `false`, do as follows:
### Example
-1. Atomic swap `tbl1` with `tbl2` without dropping any tables
+1. Atomic swap `tbl1` with `tbl2` without dropping any tables(Note: if you
delete it, you actually delete tbl1 and rename tbl2 to tbl1.)
```sql
ALTER TABLE tbl1 REPLACE WITH TABLE tbl2;
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
index 2d62c769fe..b8e79e750e 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
@@ -45,7 +45,7 @@ grammar:
```sql
CREATE FILE "file_name" [IN database]
- [properties]
+PROPERTIES("key"="value", ...)
````
illustrate:
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
index 9caa661d7a..b83632104e 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
@@ -39,7 +39,7 @@ This operation is an asynchronous operation. After the
submission is successful,
grammar:
```sql
-CREATE MATERIALIZED VIEW [MV name] as [query]
+CREATE MATERIALIZED VIEW < MV name > as < query >
[PROPERTIES ("key" = "value")]
````
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
index 6aec41cf26..fa13ab6299 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
@@ -68,14 +68,14 @@ illustrate:
```sql
create table `test`.`select_varchar`
- PROPERTIES(\"replication_num\" = \"1\")
+ PROPERTIES("replication_num" = "1")
as select * from `test`.`varchar_table`
```
2. Custom field names (need to match the number of fields returned)
```sql
create table `test`.`select_name`(user, testname, userstatus)
- PROPERTIES(\"replication_num\" = \"1\")
+ PROPERTIES("replication_num" = "1")
as select vt.userId, vt.username, jt.status
from `test`.`varchar_table` vt join
`test`.`join_table` jt on vt.userId=jt.userId
diff --git a/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
b/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
index d3faa24757..d0999576ff 100644
--- a/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
+++ b/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
@@ -37,7 +37,7 @@ This statement is used to display the amount of data, the
number of replicas, an
grammar:
```sql
-SHOW DATA [FROM db_name[.table_name]] [ORDER BY ...];
+SHOW DATA [FROM [db_name.]table_name] [ORDER BY ...];
````
illustrate:
diff --git a/docs/zh-CN/docs/query-acceleration/statistics.md
b/docs/zh-CN/docs/query-acceleration/statistics.md
index a4db5415a4..a7987c0e33 100644
--- a/docs/zh-CN/docs/query-acceleration/statistics.md
+++ b/docs/zh-CN/docs/query-acceleration/statistics.md
@@ -79,7 +79,7 @@ Doris 查询优化器使用统计信息来确定查询最有效的执行计划
列统计信息收集语法：
```SQL
-ANALYZE TABLE | DATABASE table_name | db_name
+ANALYZE < TABLE | DATABASE table_name | db_name >
[ PARTITIONS (partition_name [, ...]) ]
[ (column_name [, ...]) ]
[ [ WITH SYNC ] [ WITH INCREMENTAL ] [ WITH SAMPLE PERCENT | ROWS ] [ WITH
PERIOD ] [WITH HISTOGRAM]]
@@ -490,7 +490,7 @@ mysql> ANALYZE TABLE stats_test.example_tbl
PROPERTIES("automatic" = "true");
语法如下：
```SQL
-SHOW ANALYZE [ table_name | job_id ]
+SHOW ANALYZE < table_name | job_id >
[ WHERE [ STATE = [ "PENDING" | "RUNNING" | "FINISHED" | "FAILED" ] ] ];
```
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
index 2e4fd4b17b..190331d860 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-REPLACE.md
@@ -67,7 +67,7 @@ ALTER TABLE [db.]tbl1 REPLACE WITH TABLE tbl2
### Example
-1. 将 `tbl1` 与 `tbl2` 进行原子交换，不删除任何表
+1. 将 `tbl1` 与 `tbl2` 进行原子交换，不删除任何表（注：如果删除的话，实际上删除的是tbl1，只是将tbl2重命名为tbl1。）
```sql
ALTER TABLE tbl1 REPLACE WITH TABLE tbl2;
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
index ee20af6e2c..9d7546bff5 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FILE.md
@@ -45,7 +45,7 @@ CREATE FILE
```sql
CREATE FILE "file_name" [IN database]
- [properties]
+PROPERTIES("key"="value", ...)
```
说明：
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
index 8f20884ccd..43cf729659 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
@@ -39,7 +39,7 @@ CREATE MATERIALIZED VIEW
语法：
```sql
-CREATE MATERIALIZED VIEW [MV name] as [query]
+CREATE MATERIALIZED VIEW < MV name > as < query >
[PROPERTIES ("key" = "value")]
```
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
index ec1d09cd4f..ffa76f4611 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-AS-SELECT.md
@@ -68,14 +68,14 @@ CREATE TABLE table_name [( column_name_list )]
```sql
create table `test`.`select_varchar`
- PROPERTIES(\"replication_num\" = \"1\")
+ PROPERTIES("replication_num" = "1")
as select * from `test`.`varchar_table`
```
2. 自定义字段名(需要与返回结果字段数量一致)
```sql
create table `test`.`select_name`(user, testname, userstatus)
- PROPERTIES(\"replication_num\" = \"1\")
+ PROPERTIES("replication_num" = "1")
as select vt.userId, vt.username, jt.status
from `test`.`varchar_table` vt join
`test`.`join_table` jt on vt.userId=jt.userId
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
index 85b4a8f2d6..2acce97877 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-DATA.md
@@ -37,7 +37,7 @@ SHOW DATA
语法：
```sql
-SHOW DATA [FROM db_name[.table_name]] [ORDER BY ...];
+SHOW DATA [FROM [db_name.]table_name] [ORDER BY ...];
```
说明：
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
