This is an automated email from the ASF dual-hosted git repository.
morningman 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 6a8486472ad [fix] correct security, session, statistics,
table-and-view, transaction, and types statement doc errors (#3717)
6a8486472ad is described below
commit 6a8486472ad8b107058309f08e42d8a4b7e4b874
Author: boluor <[email protected]>
AuthorDate: Wed May 20 22:03:49 2026 -0700
[fix] correct security, session, statistics, table-and-view, transaction,
and types statement doc errors (#3717)
## Summary
Fixes 28 small documentation issues across security, session,
statistics, table-and-view, transaction, and types SQL-statement docs.
Each item below is independent.
### security
- **CREATE-ENCRYPTKEY.md** — AES_DECRYPT example result-table had a
stray space inside the border row breaking alignment; corrected to a
continuous border.
- **CREATE-ENCRYPTKEY.md** — access-control Notes column was copy-pasted
from a user/role grant statement; rewritten to describe ADMIN_PRIV at
Global scope (this statement is global, not per-user-or-role).
- **CREATE-FILE.md** — an orphan `**<file_name>**` heading appeared
above the canonical `**1. \`<file_name>\`**`; removed the duplicate.
- **DROP-FILE.md** — informal heading `## grammar:` → `## Syntax`.
- **SHOW-FILE.md** — Return Value docs the column as `FileId`, but the
example output (and the engine) emit `Id`; Return Value aligned to
actual output.
### session
- **CLEAN-ALL-PROFILE.md** — access-control table said `GRANT_PRIV` on
DATABASE; this is a global admin statement → `ADMIN_PRIV` / Global.
- **KILL-QUERY.md** — same kind of wrong access-control privilege;
corrected to `ADMIN_PRIV` / Global with the usual note (killing one's
own queries requires no privilege).
- **PLAN-REPLAYER-DUMP.md** — result-table had a duplicated header row;
removed. Also an orphan ``` fence at end of file; removed.
- **PLAN-REPLAYER-PLAY.md** — full-width semicolons `;` in syntax /
example replaced with ASCII.
- **SET-VARIABLE.md** — the user-variable description and example used
`@@your_variable_name` (which is system-variable syntax); corrected to
`@your_variable_name`.
- **SHOW-VARIABLES.md** — privilege column listed `Any_PRIV`, which is
not a real Doris privilege; replaced with "N/A — no specific privilege
required".
### statistics
- **ANALYZE.md** — last code fence at EOF was unclosed; added closing
fence.
- **DROP-STATS.md** — heading `## ## Required Parameters` had a doubled
`##`; corrected.
### table-and-view
- **DIAGNOSE-TABLET.md** — one sentence said "not supported in the
compute-storage coupled mode" while the surrounding lines correctly say
the statement is for the coupled mode; corrected to "not supported in
the storage-computing separation mode".
- **SHOW-DATA.md** — result-table rows were corrupted with stray `=`
after the pipes; cleaned up so the table renders.
- **SHOW-REPLICA-DISTRIBUTION.md** — two Chinese section headings
(`查看表的副本分布`, `查看表的分区的副本分布`) inside the English doc translated to
English.
- **SHOW-TABLET-STORAGE-FORMAT.md** — the single Return Value table
merged two non-co-occurring output shapes (default vs `VERBOSE`); split
into two tables that match the actual two example outputs.
- **CANCEL-BUILD-INDEX.md** — Chinese `其中:` in English doc → `Where:`.
- **ALTER-TABLE-COLUMN.md** — a tip said "see example 8" but no example
8 exists; pointed at the correct earlier example.
- **ALTER-TABLE-COMMENT.md** — three `grammar:` markers (with full-width
colon) replaced with proper headings.
- **ALTER-TABLE-ROLLUP.md** — orphan empty `### ` heading and dangling
"4. Keywords" line replaced with a proper `## Keywords` section.
- **CANCEL-ALTER-TABLE.md** — removed a placeholder "4. Cancel ALTER
CLUSTER operation" with `(To be implemented...)` body (ALTER CLUSTER is
not a documented statement).
- **CREATE-TABLE.md** — a Plain code fence contained both range output
AND a full CREATE TABLE statement; split into a Plain block (range
output) and a sql block (CREATE TABLE).
- **DESC-TABLE.md** — last code fence at EOF was unclosed in current /
3.x / 4.x; added a closing fence. (v2.1 was already correct and was left
alone.)
- **SHOW-PARTITION.md** — result block was opened with ```sql; changed
to ```text.
- **SHOW-DYNAMIC-PARTITION-TABLES.md** — heading `## Syntax:`
(full-width colon) corrected; truncated `pecify` → `Specify`; in the
`StartOf` description, `1rd to 28rd` → `1st to 28th`.
- **SHOW-TABLE-ID.md** — `### Description` (h3) → `## Description` (h2).
### transaction
- **ROLLBACK.md** — heading `## Syntax(Syntax)` corrected to `##
Syntax`.
### types
- **SHOW-TYPECAST.md** — frontmatter `"language": "zh-CN"` in English
doc → `"en"`. Truncated frontmatter description completed.
## Test plan
- [ ] CI doc build passes
- [ ] Spot-check the affected pages render correctly (closed code
fences, table-border alignment, proper headings, no Chinese
punctuation/headings in English docs, corrected access-control notes)
---
.../cluster-management/instance-management/SHOW-BROKER.md | 2 +-
docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md | 2 +-
docs/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md | 8 ++++----
docs/sql-manual/sql-statements/security/CREATE-FILE.md | 2 --
docs/sql-manual/sql-statements/security/DROP-FILE.md | 2 +-
docs/sql-manual/sql-statements/security/SHOW-FILE.md | 2 +-
.../sql-statements/session/queries/CLEAN-ALL-PROFILE.md | 2 +-
docs/sql-manual/sql-statements/session/queries/KILL-QUERY.md | 2 +-
.../sql-statements/session/queries/PLAN-REPLAYER-DUMP.md | 1 -
.../sql-statements/session/queries/PLAN-REPLAYER-PLAY.md | 4 ++--
.../sql-statements/session/variable/SET-VARIABLE.md | 4 ++--
.../sql-statements/session/variable/SHOW-VARIABLES.md | 2 +-
docs/sql-manual/sql-statements/statistics/DROP-STATS.md | 2 +-
.../data-and-status-management/DIAGNOSE-TABLET.md | 2 +-
.../table-and-view/data-and-status-management/SHOW-DATA.md | 12 ++++++------
.../data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md | 4 ++--
.../data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md | 12 ++++++++++--
.../table-and-view/index/CANCEL-BUILD-INDEX.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COLUMN.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COMMENT.md | 6 +++---
.../table-and-view/table/ALTER-TABLE-ROLLUP.md | 4 +---
.../table-and-view/table/CANCEL-ALTER-TABLE.md | 6 ------
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 3 +++
.../sql-statements/table-and-view/table/DESC-TABLE.md | 1 +
.../table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md | 6 +++---
.../sql-statements/table-and-view/table/SHOW-PARTITION.md | 2 +-
.../sql-statements/table-and-view/table/SHOW-TABLE-ID.md | 2 +-
docs/sql-manual/sql-statements/transaction/ROLLBACK.md | 2 +-
docs/sql-manual/sql-statements/types/SHOW-TYPECAST.md | 4 ++--
.../cluster-management/instance-management/SHOW-BROKER.md | 2 +-
.../sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md | 2 +-
.../sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md | 8 ++++----
.../sql-manual/sql-statements/security/CREATE-FILE.md | 2 --
.../sql-manual/sql-statements/security/DROP-FILE.md | 2 +-
.../sql-manual/sql-statements/security/SHOW-FILE.md | 2 +-
.../sql-statements/session/variable/SET-VARIABLE.md | 4 ++--
.../sql-statements/session/variable/SHOW-VARIABLES.md | 2 +-
.../sql-manual/sql-statements/statistics/DROP-STATS.md | 2 +-
.../data-and-status-management/DIAGNOSE-TABLET.md | 2 +-
.../table-and-view/data-and-status-management/SHOW-DATA.md | 12 ++++++------
.../data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md | 4 ++--
.../data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md | 12 ++++++++++--
.../table-and-view/index/CANCEL-BUILD-INDEX.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COLUMN.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COMMENT.md | 6 +++---
.../table-and-view/table/ALTER-TABLE-ROLLUP.md | 4 +---
.../table-and-view/table/CANCEL-ALTER-TABLE.md | 6 ------
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 3 +++
.../table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md | 6 +++---
.../sql-statements/table-and-view/table/SHOW-PARTITION.md | 2 +-
.../sql-statements/table-and-view/table/SHOW-TABLE-ID.md | 2 +-
.../sql-manual/sql-statements/transaction/ROLLBACK.md | 2 +-
.../sql-manual/sql-statements/types/SHOW-TYPECAST.md | 4 ++--
.../cluster-management/instance-management/SHOW-BROKER.md | 2 +-
.../sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md | 2 +-
.../sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md | 8 ++++----
.../sql-manual/sql-statements/security/CREATE-FILE.md | 2 --
.../sql-manual/sql-statements/security/DROP-FILE.md | 2 +-
.../sql-manual/sql-statements/security/SHOW-FILE.md | 2 +-
.../sql-statements/session/queries/CLEAN-ALL-PROFILE.md | 2 +-
.../sql-manual/sql-statements/session/queries/KILL-QUERY.md | 2 +-
.../sql-statements/session/queries/PLAN-REPLAYER-DUMP.md | 1 -
.../sql-statements/session/queries/PLAN-REPLAYER-PLAY.md | 4 ++--
.../sql-statements/session/variable/SET-VARIABLE.md | 4 ++--
.../sql-statements/session/variable/SHOW-VARIABLES.md | 2 +-
.../sql-manual/sql-statements/statistics/DROP-STATS.md | 2 +-
.../data-and-status-management/DIAGNOSE-TABLET.md | 2 +-
.../table-and-view/data-and-status-management/SHOW-DATA.md | 12 ++++++------
.../data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md | 4 ++--
.../data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md | 12 ++++++++++--
.../table-and-view/index/CANCEL-BUILD-INDEX.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COLUMN.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COMMENT.md | 6 +++---
.../table-and-view/table/ALTER-TABLE-ROLLUP.md | 4 +---
.../table-and-view/table/CANCEL-ALTER-TABLE.md | 6 ------
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 3 +++
.../sql-statements/table-and-view/table/DESC-TABLE.md | 1 +
.../table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md | 6 +++---
.../sql-statements/table-and-view/table/SHOW-PARTITION.md | 2 +-
.../sql-statements/table-and-view/table/SHOW-TABLE-ID.md | 2 +-
.../sql-manual/sql-statements/transaction/ROLLBACK.md | 2 +-
.../sql-manual/sql-statements/types/SHOW-TYPECAST.md | 4 ++--
.../cluster-management/instance-management/SHOW-BROKER.md | 2 +-
.../sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md | 2 +-
.../sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md | 8 ++++----
.../sql-manual/sql-statements/security/CREATE-FILE.md | 2 --
.../sql-manual/sql-statements/security/DROP-FILE.md | 2 +-
.../sql-manual/sql-statements/security/SHOW-FILE.md | 2 +-
.../sql-statements/session/queries/CLEAN-ALL-PROFILE.md | 2 +-
.../sql-manual/sql-statements/session/queries/KILL-QUERY.md | 2 +-
.../sql-statements/session/queries/PLAN-REPLAYER-DUMP.md | 1 -
.../sql-statements/session/queries/PLAN-REPLAYER-PLAY.md | 4 ++--
.../sql-statements/session/variable/SET-VARIABLE.md | 4 ++--
.../sql-statements/session/variable/SHOW-VARIABLES.md | 2 +-
.../sql-manual/sql-statements/statistics/DROP-STATS.md | 2 +-
.../data-and-status-management/DIAGNOSE-TABLET.md | 2 +-
.../table-and-view/data-and-status-management/SHOW-DATA.md | 12 ++++++------
.../data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md | 4 ++--
.../data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md | 12 ++++++++++--
.../table-and-view/index/CANCEL-BUILD-INDEX.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COLUMN.md | 2 +-
.../table-and-view/table/ALTER-TABLE-COMMENT.md | 6 +++---
.../table-and-view/table/ALTER-TABLE-ROLLUP.md | 4 +---
.../table-and-view/table/CANCEL-ALTER-TABLE.md | 6 ------
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 3 +++
.../sql-statements/table-and-view/table/DESC-TABLE.md | 1 +
.../table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md | 6 +++---
.../sql-statements/table-and-view/table/SHOW-PARTITION.md | 2 +-
.../sql-statements/table-and-view/table/SHOW-TABLE-ID.md | 2 +-
.../sql-manual/sql-statements/transaction/ROLLBACK.md | 2 +-
.../sql-manual/sql-statements/types/SHOW-TYPECAST.md | 4 ++--
111 files changed, 207 insertions(+), 203 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
b/docs/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
index 1ed0c9b2227..5ff089a6854 100644
---
a/docs/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
+++
b/docs/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
@@ -10,7 +10,7 @@
This statement is used to view the status of the currently existing broker
processes.
-## Syntax:
+## Syntax
```sql
SHOW BROKER;
diff --git a/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index a03409f28ec..7b2b0279287 100644
--- a/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++ b/docs/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -10,7 +10,7 @@
This statement is used to uninstall a plugin.
-## Syntax:
+## Syntax
```sql
UNINSTALL PLUGIN <plugin_name>;
diff --git a/docs/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
b/docs/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
index 22022546335..b89c8383692 100644
--- a/docs/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
+++ b/docs/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
@@ -38,7 +38,7 @@ The user executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes
|
|:-------------|:------------|:--------------------------------------------------------------------------------------|
-| `ADMIN_PRIV` | User / Role | Must hold the `ADMIN_PRIV` privilege on the
target user or role to create custom keys |
+| `ADMIN_PRIV` | Global | The user must have the `ADMIN_PRIV` privilege to
create encryption keys |
## Example
@@ -77,9 +77,9 @@ The user executing this SQL command must have at least the
following privileges:
SELECT AES_DECRYPT(UNHEX('D26DB38579D6A343350EDDC6F2AD47C6'), KEY my_key);
```
```text
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| aes_decrypt(unhex('D26DB38579D6A343350EDDC6F2AD47C6'), key my_key) |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| Doris is Great |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
```
diff --git a/docs/sql-manual/sql-statements/security/CREATE-FILE.md
b/docs/sql-manual/sql-statements/security/CREATE-FILE.md
index e6da9d95edb..4d35f22b95e 100644
--- a/docs/sql-manual/sql-statements/security/CREATE-FILE.md
+++ b/docs/sql-manual/sql-statements/security/CREATE-FILE.md
@@ -21,8 +21,6 @@ CREATE FILE <file_name>
## Required Parameters
-**<file_name>**
-
**1. `<file_name>`**
> Custom file name.
diff --git a/docs/sql-manual/sql-statements/security/DROP-FILE.md
b/docs/sql-manual/sql-statements/security/DROP-FILE.md
index 06b0491e604..fc44e5b5694 100644
--- a/docs/sql-manual/sql-statements/security/DROP-FILE.md
+++ b/docs/sql-manual/sql-statements/security/DROP-FILE.md
@@ -10,7 +10,7 @@
This statement is used to delete an uploaded file.
-## grammar:
+## Syntax
```sql
DROP FILE "<file_name>" [ { FROM | IN } <database>] PROPERTIES
("<key>"="<value>" [ , ... ])
diff --git a/docs/sql-manual/sql-statements/security/SHOW-FILE.md
b/docs/sql-manual/sql-statements/security/SHOW-FILE.md
index 6dbf34d52a9..7a3f588fa04 100644
--- a/docs/sql-manual/sql-statements/security/SHOW-FILE.md
+++ b/docs/sql-manual/sql-statements/security/SHOW-FILE.md
@@ -26,7 +26,7 @@ SHOW FILE { [ FROM | IN ] <database_name>}
| Column | Description |
|:------------|:--------------------------------|
-| `FileId` | Globally unique file identifier |
+| `Id` | Globally unique file identifier |
| `DbName` | Name of the owning database |
| `Catalog` | User-defined classification |
| `FileName` | Name of the file |
diff --git
a/docs/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
b/docs/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
index a03108425c6..77e7b54c5e1 100644
--- a/docs/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
+++ b/docs/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
@@ -22,7 +22,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes
|
|:--------------|:-----------|:-----------------------------------------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the CLEAN
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to clear all profiles
|
## Examples
diff --git a/docs/sql-manual/sql-statements/session/queries/KILL-QUERY.md
b/docs/sql-manual/sql-statements/session/queries/KILL-QUERY.md
index d7d895d0feb..c732b00ed5c 100644
--- a/docs/sql-manual/sql-statements/session/queries/KILL-QUERY.md
+++ b/docs/sql-manual/sql-statements/session/queries/KILL-QUERY.md
@@ -44,7 +44,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes |
|:--------------|:-----------|:-----------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the KILL
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to kill
queries/connections of other users; killing one's own queries requires no
privilege |
## Usage Notes
diff --git
a/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
b/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
index 1ddb628217b..b06b9b2b404 100644
--- a/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
+++ b/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
@@ -57,7 +57,6 @@ Execution result example:
```sql
+-------------------------------------------------------------------------------+
| Plan Replayer dump url
|
-| Plan Replayer dump url |
+-------------------------------------------------------------------------------+
|
http://127.0.0.1:8030/api/minidump?query_id=6e7441f741e94afd-ad3ba69429ad18ec |
+-------------------------------------------------------------------------------+
diff --git
a/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
b/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
index 2eb16fef06c..8db50bdd7e8 100644
--- a/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
+++ b/docs/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
@@ -13,7 +13,7 @@ PLAN REPLAYER PLAY is a tool used by Doris developers to
analyze optimizer issue
## Syntax
```sql
-PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
+PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
```
## Required Parameters
@@ -29,5 +29,5 @@ PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
When we have a `dumpfile: /home/wangwu/dumpfile.json`, we can use the
following SQL to reproduce the scenario:
```sql
-PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
+PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
```
\ No newline at end of file
diff --git a/docs/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
b/docs/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
index 331551a2992..865217a740a 100644
--- a/docs/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
+++ b/docs/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
@@ -25,7 +25,7 @@ variable_assignment
## Required Parameters
**1. `<user_var_name>`**
-> Specifies the variable of user level, for example : @@your_variable_name,
variable name starts with `@@`
+> Specifies the variable of user level, for example : @your_variable_name,
variable name starts with `@`
**2. `<system_var_name>`**
> Specifies the variable of system level, for example : exec_mem_limit and so
> on
@@ -65,7 +65,7 @@ Users executing this SQL command must have at least the
following privileges:
- Set a user variable
```
- SET @@your_variable_name = your_variable_value;
+ SET @your_variable_name = your_variable_value;
```
diff --git a/docs/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
b/docs/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
index db285f43c6c..c88bac1cbbc 100644
--- a/docs/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
+++ b/docs/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
@@ -31,7 +31,7 @@ Users executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes |
| :--------- | :----- | :------------------------------------------- |
-| Any_PRIV | Session | Any privilege can show variables |
+| N/A | Session | No specific privilege is required to show variables |
## Return Value
diff --git a/docs/sql-manual/sql-statements/statistics/DROP-STATS.md
b/docs/sql-manual/sql-statements/statistics/DROP-STATS.md
index 04f34fb2096..f93f6ad2935 100644
--- a/docs/sql-manual/sql-statements/statistics/DROP-STATS.md
+++ b/docs/sql-manual/sql-statements/statistics/DROP-STATS.md
@@ -24,7 +24,7 @@ column_names
(<column_name>, [ <column_name>... ])
```
-## ## Required Parameters
+## Required Parameters
**<table_name>**
diff --git
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
index 59d314111c7..05b0acf887e 100644
---
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
+++
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
@@ -10,7 +10,7 @@
In the compute-storage coupled mode, this statement is used to diagnose a
specified tablet. The result will display information about the tablet and some
potential issues.
-This command is not supported in the compute-storage coupled mode.
+This command is not supported in the storage-computing separation mode.
## Syntax
diff --git
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
index ab9f22fb1b6..0fb32522ae9 100644
---
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
+++
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
@@ -153,10 +153,10 @@ Users executing this SQL command must have at least the
following permissions:
+-----------+-------------+--------------+
| table_c | 3.102 KB | 40 |
| table_d | .000 | 20 |
- | table_b |=324.000 B |=20 |
- |=table_a |=1.266 KB |=10 |
- |=Total |=4.684 KB |=90 |
- |=Quota |=1024.000 GB |=1073741824 |
- |=Left |=1024.000 GB |=1073741734 |
- +-----------+-------------+--------------+
+ | table_b | 324.000 B | 20 |
+ | table_a | 1.266 KB | 10 |
+ | Total | 4.684 KB | 90 |
+ | Quota | 1024.000 GB | 1073741824 |
+ | Left | 1024.000 GB | 1073741734 |
+ +-----------+-------------+--------------+
```
diff --git
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
index 62c1a7f9d3d..94d8519aa24 100644
---
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
+++
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
@@ -89,7 +89,7 @@ The user executing this SQL command must have at least the
following privileges:
## Examples
-- 查看表的副本分布
+- View the replica distribution of a table
```sql
SHOW REPLICA DISTRIBUTION FROM sell_user;
@@ -106,7 +106,7 @@ The user executing this SQL command must have at least the
following privileges:
SizePercent: 100.00%
```
-- 查看表的分区的副本分布
+- View the replica distribution of a table's partitions
```sql
SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
diff --git
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
index e505dc031e1..d82469265e1 100644
---
a/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
+++
b/docs/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
@@ -25,11 +25,19 @@ SHOW TABLET STORAGE FORMAT [VERBOSE]
## Return Value
+**Default output** (without `VERBOSE`):
+
+| Column | DataType | Note
|
+|-----------|----------|----------------------------------------------------------------------|
+| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
+| V1Count | Int | Number of V1 version tablets.
|
+| V2Count | Int | Number of V2 version tablets.
|
+
+**With `VERBOSE`**:
+
| Column | DataType | Note
|
|---------------|----------|----------------------------------------------------------------------|
| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
-| V1Count | Int | Number of V1 version tablets.
|
-| V2Count | Int | Number of V2 version tablets.
|
| TabletId | Int | The unique identifier of the tablet.
|
| StorageFormat | String | The version of the tablet, either V1 or V2.
|
diff --git
a/docs/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
b/docs/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
index 92572508687..1f082b3cef6 100644
--- a/docs/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
+++ b/docs/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
@@ -17,7 +17,7 @@ Cancel background tasks for index building.
CANCEL BUILD INDEX ON <table_name> [ job_list ]
```
-其中:
+Where:
```sql
job_list
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
index 2572030e2f5..e1e06008743 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
@@ -180,7 +180,7 @@ ALTER TABLE [database.]table table_name MODIFY COLUMN
column_name column_type [K
:::tip
- If you modify the value column in the aggregation model, you need to
specify agg_type
- If you modify the key column for non-aggregate types, you need to specify
the KEY keyword
- - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 8)
+ - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 2
above)
- Partitioning and bucketing columns cannot be modified in any way
- The following types of conversions are currently supported (loss of
precision is guaranteed by the user)
- Conversion of TINYINT/SMALLINT/INT/BIGINT/LARGEINT/FLOAT/DOUBLE types to
larger numeric types
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
index bc555b431f5..c7131061ccf 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
@@ -10,7 +10,7 @@
This statement is used to modify the comment of an existing table. The
operation is synchronous, and the command returns to indicate completion.
-grammar:
+## Syntax
```sql
ALTER TABLE [database.]table alter_clause;
@@ -18,7 +18,7 @@ ALTER TABLE [database.]table alter_clause;
1. Modify table comment
-grammar:
+## Syntax
```sql
MODIFY COMMENT "new table comment";
@@ -26,7 +26,7 @@ MODIFY COMMENT "new table comment";
2. Modify column comment
-grammar:
+## Syntax
```sql
MODIFY COLUMN col1 COMMENT "new column comment";
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
index d1496e201ac..1b2590a65fe 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
@@ -105,9 +105,7 @@ ALTER TABLE example_db.my_table
DROP ROLLUP example_rollup_index2,example_rollup_index3;
```
-###
-
-4. Keywords
+## Keywords
```text
ALTER, TABLE, ROLLUP, ALTER TABLE
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
b/docs/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
index d7465c5ff6e..8c4616297a3 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
@@ -89,9 +89,3 @@ CANCEL ALTER TABLE ROLLUP
FROM db_name.table_name (jobid,...)
```
-
-4. Cancel ALTER CLUSTER operation
-
-```sql
-(To be implemented...)
-```
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index 56b5ca19dc4..ae8b5fe450c 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -682,6 +682,9 @@ This table creates partitions 3 days in advance and deletes
partitions from 3 da
[types: [DATE]; keys: [2020-01-09]; ‥types: [DATE]; keys: [2020-01-10]; )
[types: [DATE]; keys: [2020-01-10]; ‥types: [DATE]; keys: [2020-01-11]; )
[types: [DATE]; keys: [2020-01-11]; ‥types: [DATE]; keys: [2020-01-12]; )
+```
+
+```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
diff --git a/docs/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
b/docs/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
index f08c2b29031..deb9ce920d2 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
@@ -98,3 +98,4 @@ DESC test_table;
| name | varchar(20) | Yes | false | NULL | NONE |
| age | int | Yes | false | NULL | NONE |
+---------+-------------+------+-------+---------+-------+
+```
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
index 176d74f9eb8..47e99fc7e31 100644
---
a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
+++
b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
@@ -10,7 +10,7 @@
This statement is used to display the status of all dynamic partition tables
in the current database.
-## Syntax:
+## Syntax
```sql
SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
@@ -19,7 +19,7 @@ SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
## Required Parameters
**1. `<db_name>`**
-pecify the `DB` name to display the status of dynamic partition tables. If not
specified, the status of all dynamic partition tables in the current `DB` will
be displayed by default.
+Specify the `DB` name to display the status of dynamic partition tables. If
not specified, the status of all dynamic partition tables in the current `DB`
will be displayed by default.
## Return Value
| Column | DataType | Note
|
@@ -33,7 +33,7 @@ pecify the `DB` name to display the status of dynamic
partition tables. If not s
| Buckets | varchar | The number of buckets corresponding to
the dynamically created partition.
|
| ReplicationNum | varchar | The number of replicas corresponding to
the dynamically created partition. If not specified, it defaults to the number
of replicas specified when the table was created.
|
| ReplicaAllocation | varchar | The replica distribution strategy
corresponding to the dynamically created partition. If not specified, it
defaults to the replica distribution strategy specified when the table was
created.
|
-| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1rd to 28rd. When time_unit is MONTH, this value
defaults to NULL. |
+| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1st to 28th. When time_unit is MONTH, this value
defaults to NULL. |
| LastUpdateTime | datetime | The last update time of the dynamic
partition, which defaults to NULL.
|
| LastSchedulerTime | datetime | The last scheduling time of the dynamic
partition.
|
| State | varchar | The state of the dynamic partition.
|
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
index 154b04f23de..9550cce54cd 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
@@ -36,7 +36,7 @@ SHOW PARTITION 13004;
Results:
-```sql
+```text
+--------+-----------+---------------+-------+---------+
| DbName | TableName | PartitionName | DbId | TableId |
+--------+-----------+---------------+-------+---------+
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
index 56920fb0ac7..346b9e39c01 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
@@ -6,7 +6,7 @@
}
---
-### Description
+## Description
This statement is used to find the corresponding database name, table name
according to table id.
diff --git a/docs/sql-manual/sql-statements/transaction/ROLLBACK.md
b/docs/sql-manual/sql-statements/transaction/ROLLBACK.md
index ad87a40ae83..768040e9829 100644
--- a/docs/sql-manual/sql-statements/transaction/ROLLBACK.md
+++ b/docs/sql-manual/sql-statements/transaction/ROLLBACK.md
@@ -10,7 +10,7 @@
Rollback an explicit transaction. It is used in pairs with [BEGIN](./BEGIN).
-## Syntax(Syntax)
+## Syntax
```sql
ROLLBACK
diff --git a/docs/sql-manual/sql-statements/types/SHOW-TYPECAST.md
b/docs/sql-manual/sql-statements/types/SHOW-TYPECAST.md
index 9599c2f0b72..ee5d1ca87f6 100644
--- a/docs/sql-manual/sql-statements/types/SHOW-TYPECAST.md
+++ b/docs/sql-manual/sql-statements/types/SHOW-TYPECAST.md
@@ -1,8 +1,8 @@
---
{
"title": "SHOW TYPECAST",
- "language": "zh-CN",
- "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database,"
+ "language": "en",
+ "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located."
}
---
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
index 1ed0c9b2227..5ff089a6854 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
@@ -10,7 +10,7 @@
This statement is used to view the status of the currently existing broker
processes.
-## Syntax:
+## Syntax
```sql
SHOW BROKER;
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 a03409f28ec..7b2b0279287 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
@@ -10,7 +10,7 @@
This statement is used to uninstall a plugin.
-## Syntax:
+## Syntax
```sql
UNINSTALL PLUGIN <plugin_name>;
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
index 22022546335..b89c8383692 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
@@ -38,7 +38,7 @@ The user executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes
|
|:-------------|:------------|:--------------------------------------------------------------------------------------|
-| `ADMIN_PRIV` | User / Role | Must hold the `ADMIN_PRIV` privilege on the
target user or role to create custom keys |
+| `ADMIN_PRIV` | Global | The user must have the `ADMIN_PRIV` privilege to
create encryption keys |
## Example
@@ -77,9 +77,9 @@ The user executing this SQL command must have at least the
following privileges:
SELECT AES_DECRYPT(UNHEX('D26DB38579D6A343350EDDC6F2AD47C6'), KEY my_key);
```
```text
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| aes_decrypt(unhex('D26DB38579D6A343350EDDC6F2AD47C6'), key my_key) |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| Doris is Great |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-FILE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-FILE.md
index a8763ae2418..8965b3c8648 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-FILE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/CREATE-FILE.md
@@ -21,8 +21,6 @@ CREATE FILE <file_name>
## Required Parameters
-**<file_name>**
-
**1. `<file_name>`**
> Custom file name.
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/DROP-FILE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/DROP-FILE.md
index 06b0491e604..fc44e5b5694 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-statements/security/DROP-FILE.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-statements/security/DROP-FILE.md
@@ -10,7 +10,7 @@
This statement is used to delete an uploaded file.
-## grammar:
+## Syntax
```sql
DROP FILE "<file_name>" [ { FROM | IN } <database>] PROPERTIES
("<key>"="<value>" [ , ... ])
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/security/SHOW-FILE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/security/SHOW-FILE.md
index 6dbf34d52a9..7a3f588fa04 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-statements/security/SHOW-FILE.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-statements/security/SHOW-FILE.md
@@ -26,7 +26,7 @@ SHOW FILE { [ FROM | IN ] <database_name>}
| Column | Description |
|:------------|:--------------------------------|
-| `FileId` | Globally unique file identifier |
+| `Id` | Globally unique file identifier |
| `DbName` | Name of the owning database |
| `Catalog` | User-defined classification |
| `FileName` | Name of the file |
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
index b7855d51f16..6bc346dcf6b 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
@@ -25,7 +25,7 @@ variable_assignment
## Required Parameters
**1. `<user_var_name>`**
-> Specifies the variable of user level, for example : @@your_variable_name,
variable name starts with `@@`
+> Specifies the variable of user level, for example : @your_variable_name,
variable name starts with `@`
**2. `<system_var_name>`**
> Specifies the variable of system level, for example : exec_mem_limit and so
> on
@@ -65,6 +65,6 @@ Users executing this SQL command must have at least the
following privileges:
- Set a user variable
```
- SET @@your_variable_name = your_variable_value;
+ SET @your_variable_name = your_variable_value;
```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
index 897d0d84df6..2e02702eaf6 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
@@ -31,7 +31,7 @@ Users executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes |
| :--------- | :----- | :------------------------------------------- |
-| Any_PRIV | Session | Any privilege can show variables |
+| N/A | Session | No specific privilege is required to show variables |
## Return Value
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/statistics/DROP-STATS.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/statistics/DROP-STATS.md
index 04f34fb2096..f93f6ad2935 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/statistics/DROP-STATS.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/statistics/DROP-STATS.md
@@ -24,7 +24,7 @@ column_names
(<column_name>, [ <column_name>... ])
```
-## ## Required Parameters
+## Required Parameters
**<table_name>**
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
index f593c9a676e..3abd2b9653e 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
@@ -10,7 +10,7 @@
In the compute-storage coupled mode, this statement is used to diagnose a
specified tablet. The result will display information about the tablet and some
potential issues.
-This command is not supported in the compute-storage coupled mode.
+This command is not supported in the storage-computing separation mode.
## Syntax
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
index ab9f22fb1b6..0fb32522ae9 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
@@ -153,10 +153,10 @@ Users executing this SQL command must have at least the
following permissions:
+-----------+-------------+--------------+
| table_c | 3.102 KB | 40 |
| table_d | .000 | 20 |
- | table_b |=324.000 B |=20 |
- |=table_a |=1.266 KB |=10 |
- |=Total |=4.684 KB |=90 |
- |=Quota |=1024.000 GB |=1073741824 |
- |=Left |=1024.000 GB |=1073741734 |
- +-----------+-------------+--------------+
+ | table_b | 324.000 B | 20 |
+ | table_a | 1.266 KB | 10 |
+ | Total | 4.684 KB | 90 |
+ | Quota | 1024.000 GB | 1073741824 |
+ | Left | 1024.000 GB | 1073741734 |
+ +-----------+-------------+--------------+
```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
index 62c1a7f9d3d..94d8519aa24 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
@@ -89,7 +89,7 @@ The user executing this SQL command must have at least the
following privileges:
## Examples
-- 查看表的副本分布
+- View the replica distribution of a table
```sql
SHOW REPLICA DISTRIBUTION FROM sell_user;
@@ -106,7 +106,7 @@ The user executing this SQL command must have at least the
following privileges:
SizePercent: 100.00%
```
-- 查看表的分区的副本分布
+- View the replica distribution of a table's partitions
```sql
SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
index e505dc031e1..d82469265e1 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
@@ -25,11 +25,19 @@ SHOW TABLET STORAGE FORMAT [VERBOSE]
## Return Value
+**Default output** (without `VERBOSE`):
+
+| Column | DataType | Note
|
+|-----------|----------|----------------------------------------------------------------------|
+| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
+| V1Count | Int | Number of V1 version tablets.
|
+| V2Count | Int | Number of V2 version tablets.
|
+
+**With `VERBOSE`**:
+
| Column | DataType | Note
|
|---------------|----------|----------------------------------------------------------------------|
| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
-| V1Count | Int | Number of V1 version tablets.
|
-| V2Count | Int | Number of V2 version tablets.
|
| TabletId | Int | The unique identifier of the tablet.
|
| StorageFormat | String | The version of the tablet, either V1 or V2.
|
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
index 92572508687..1f082b3cef6 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
@@ -17,7 +17,7 @@ Cancel background tasks for index building.
CANCEL BUILD INDEX ON <table_name> [ job_list ]
```
-其中:
+Where:
```sql
job_list
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
index 2572030e2f5..e1e06008743 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
@@ -180,7 +180,7 @@ ALTER TABLE [database.]table table_name MODIFY COLUMN
column_name column_type [K
:::tip
- If you modify the value column in the aggregation model, you need to
specify agg_type
- If you modify the key column for non-aggregate types, you need to specify
the KEY keyword
- - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 8)
+ - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 2
above)
- Partitioning and bucketing columns cannot be modified in any way
- The following types of conversions are currently supported (loss of
precision is guaranteed by the user)
- Conversion of TINYINT/SMALLINT/INT/BIGINT/LARGEINT/FLOAT/DOUBLE types to
larger numeric types
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
index 53f5433f765..510777ef4a8 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
@@ -10,7 +10,7 @@
This statement is used to modify the comment of an existing table. The
operation is synchronous, and the command returns to indicate completion.
-grammar:
+## Syntax
```sql
ALTER TABLE [database.]table alter_clause;
@@ -18,7 +18,7 @@ ALTER TABLE [database.]table alter_clause;
1. Modify table comment
-grammar:
+## Syntax
```sql
MODIFY COMMENT "new table comment";
@@ -26,7 +26,7 @@ MODIFY COMMENT "new table comment";
2. Modify column comment
-grammar:
+## Syntax
```sql
MODIFY COLUMN col1 COMMENT "new column comment";
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
index 66457f32236..56d3d5e5762 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
@@ -105,9 +105,7 @@ ALTER TABLE example_db.my_table
DROP ROLLUP example_rollup_index2,example_rollup_index3;
```
-###
-
-4. Keywords
+## Keywords
```text
ALTER, TABLE, ROLLUP, ALTER TABLE
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
index 2b4a7b918a5..8481c92302d 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
@@ -89,9 +89,3 @@ CANCEL ALTER TABLE ROLLUP
FROM db_name.table_name (jobid,...)
```
-
-4. Cancel ALTER CLUSTER operation
-
-```sql
-(To be implemented...)
-```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index b480719c1fa..8ea5f289778 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -659,6 +659,9 @@ This table creates partitions 3 days in advance and deletes
partitions from 3 da
[types: [DATE]; keys: [2020-01-09]; ‥types: [DATE]; keys: [2020-01-10]; )
[types: [DATE]; keys: [2020-01-10]; ‥types: [DATE]; keys: [2020-01-11]; )
[types: [DATE]; keys: [2020-01-11]; ‥types: [DATE]; keys: [2020-01-12]; )
+```
+
+```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
index 2ac058bf316..956b9ef3d8c 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
@@ -10,7 +10,7 @@
This statement is used to display the status of all dynamic partition tables
in the current database.
-## Syntax:
+## Syntax
```sql
SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
@@ -19,7 +19,7 @@ SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
## Required Parameters
**1. `<db_name>`**
-pecify the `DB` name to display the status of dynamic partition tables. If not
specified, the status of all dynamic partition tables in the current `DB` will
be displayed by default.
+Specify the `DB` name to display the status of dynamic partition tables. If
not specified, the status of all dynamic partition tables in the current `DB`
will be displayed by default.
## Return Value
| Column | DataType | Note
|
@@ -33,7 +33,7 @@ pecify the `DB` name to display the status of dynamic
partition tables. If not s
| Buckets | varchar | The number of buckets corresponding to
the dynamically created partition.
|
| ReplicationNum | varchar | The number of replicas corresponding to
the dynamically created partition. If not specified, it defaults to the number
of replicas specified when the table was created.
|
| ReplicaAllocation | varchar | The replica distribution strategy
corresponding to the dynamically created partition. If not specified, it
defaults to the replica distribution strategy specified when the table was
created.
|
-| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1rd to 28rd. When time_unit is MONTH, this value
defaults to NULL. |
+| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1st to 28th. When time_unit is MONTH, this value
defaults to NULL. |
| LastUpdateTime | datetime | The last update time of the dynamic
partition, which defaults to NULL.
|
| LastSchedulerTime | datetime | The last scheduling time of the dynamic
partition.
|
| State | varchar | The state of the dynamic partition.
|
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
index 154b04f23de..9550cce54cd 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
@@ -36,7 +36,7 @@ SHOW PARTITION 13004;
Results:
-```sql
+```text
+--------+-----------+---------------+-------+---------+
| DbName | TableName | PartitionName | DbId | TableId |
+--------+-----------+---------------+-------+---------+
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
index 56920fb0ac7..346b9e39c01 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
@@ -6,7 +6,7 @@
}
---
-### Description
+## Description
This statement is used to find the corresponding database name, table name
according to table id.
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/transaction/ROLLBACK.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/transaction/ROLLBACK.md
index ad87a40ae83..768040e9829 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/transaction/ROLLBACK.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/transaction/ROLLBACK.md
@@ -10,7 +10,7 @@
Rollback an explicit transaction. It is used in pairs with [BEGIN](./BEGIN).
-## Syntax(Syntax)
+## Syntax
```sql
ROLLBACK
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/types/SHOW-TYPECAST.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/types/SHOW-TYPECAST.md
index 9599c2f0b72..ee5d1ca87f6 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/types/SHOW-TYPECAST.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/types/SHOW-TYPECAST.md
@@ -1,8 +1,8 @@
---
{
"title": "SHOW TYPECAST",
- "language": "zh-CN",
- "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database,"
+ "language": "en",
+ "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located."
}
---
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
index 1ed0c9b2227..5ff089a6854 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
@@ -10,7 +10,7 @@
This statement is used to view the status of the currently existing broker
processes.
-## Syntax:
+## Syntax
```sql
SHOW BROKER;
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index a03409f28ec..7b2b0279287 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -10,7 +10,7 @@
This statement is used to uninstall a plugin.
-## Syntax:
+## Syntax
```sql
UNINSTALL PLUGIN <plugin_name>;
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
index 22022546335..b89c8383692 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
@@ -38,7 +38,7 @@ The user executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes
|
|:-------------|:------------|:--------------------------------------------------------------------------------------|
-| `ADMIN_PRIV` | User / Role | Must hold the `ADMIN_PRIV` privilege on the
target user or role to create custom keys |
+| `ADMIN_PRIV` | Global | The user must have the `ADMIN_PRIV` privilege to
create encryption keys |
## Example
@@ -77,9 +77,9 @@ The user executing this SQL command must have at least the
following privileges:
SELECT AES_DECRYPT(UNHEX('D26DB38579D6A343350EDDC6F2AD47C6'), KEY my_key);
```
```text
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| aes_decrypt(unhex('D26DB38579D6A343350EDDC6F2AD47C6'), key my_key) |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| Doris is Great |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-FILE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-FILE.md
index a8763ae2418..8965b3c8648 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-FILE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/CREATE-FILE.md
@@ -21,8 +21,6 @@ CREATE FILE <file_name>
## Required Parameters
-**<file_name>**
-
**1. `<file_name>`**
> Custom file name.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/DROP-FILE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/DROP-FILE.md
index 06b0491e604..fc44e5b5694 100644
--- a/versioned_docs/version-3.x/sql-manual/sql-statements/security/DROP-FILE.md
+++ b/versioned_docs/version-3.x/sql-manual/sql-statements/security/DROP-FILE.md
@@ -10,7 +10,7 @@
This statement is used to delete an uploaded file.
-## grammar:
+## Syntax
```sql
DROP FILE "<file_name>" [ { FROM | IN } <database>] PROPERTIES
("<key>"="<value>" [ , ... ])
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/security/SHOW-FILE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/security/SHOW-FILE.md
index 6dbf34d52a9..7a3f588fa04 100644
--- a/versioned_docs/version-3.x/sql-manual/sql-statements/security/SHOW-FILE.md
+++ b/versioned_docs/version-3.x/sql-manual/sql-statements/security/SHOW-FILE.md
@@ -26,7 +26,7 @@ SHOW FILE { [ FROM | IN ] <database_name>}
| Column | Description |
|:------------|:--------------------------------|
-| `FileId` | Globally unique file identifier |
+| `Id` | Globally unique file identifier |
| `DbName` | Name of the owning database |
| `Catalog` | User-defined classification |
| `FileName` | Name of the file |
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
index 946c676951e..d979b2044cf 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
@@ -22,7 +22,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes
|
|:--------------|:-----------|:-----------------------------------------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the CLEAN
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to clear all profiles
|
## Examples
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
index df4d5e1e56d..fd5263389cf 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
@@ -50,7 +50,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes |
|:--------------|:-----------|:-----------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the KILL
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to kill
queries/connections of other users; killing one's own queries requires no
privilege |
## Examples
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
index 1ddb628217b..b06b9b2b404 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
@@ -57,7 +57,6 @@ Execution result example:
```sql
+-------------------------------------------------------------------------------+
| Plan Replayer dump url
|
-| Plan Replayer dump url |
+-------------------------------------------------------------------------------+
|
http://127.0.0.1:8030/api/minidump?query_id=6e7441f741e94afd-ad3ba69429ad18ec |
+-------------------------------------------------------------------------------+
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
index 2eb16fef06c..8db50bdd7e8 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
@@ -13,7 +13,7 @@ PLAN REPLAYER PLAY is a tool used by Doris developers to
analyze optimizer issue
## Syntax
```sql
-PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
+PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
```
## Required Parameters
@@ -29,5 +29,5 @@ PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
When we have a `dumpfile: /home/wangwu/dumpfile.json`, we can use the
following SQL to reproduce the scenario:
```sql
-PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
+PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
index b7855d51f16..6bc346dcf6b 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
@@ -25,7 +25,7 @@ variable_assignment
## Required Parameters
**1. `<user_var_name>`**
-> Specifies the variable of user level, for example : @@your_variable_name,
variable name starts with `@@`
+> Specifies the variable of user level, for example : @your_variable_name,
variable name starts with `@`
**2. `<system_var_name>`**
> Specifies the variable of system level, for example : exec_mem_limit and so
> on
@@ -65,6 +65,6 @@ Users executing this SQL command must have at least the
following privileges:
- Set a user variable
```
- SET @@your_variable_name = your_variable_value;
+ SET @your_variable_name = your_variable_value;
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
index 897d0d84df6..2e02702eaf6 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
@@ -31,7 +31,7 @@ Users executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes |
| :--------- | :----- | :------------------------------------------- |
-| Any_PRIV | Session | Any privilege can show variables |
+| N/A | Session | No specific privilege is required to show variables |
## Return Value
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/statistics/DROP-STATS.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/statistics/DROP-STATS.md
index 04f34fb2096..f93f6ad2935 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/statistics/DROP-STATS.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/statistics/DROP-STATS.md
@@ -24,7 +24,7 @@ column_names
(<column_name>, [ <column_name>... ])
```
-## ## Required Parameters
+## Required Parameters
**<table_name>**
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
index 59d314111c7..05b0acf887e 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
@@ -10,7 +10,7 @@
In the compute-storage coupled mode, this statement is used to diagnose a
specified tablet. The result will display information about the tablet and some
potential issues.
-This command is not supported in the compute-storage coupled mode.
+This command is not supported in the storage-computing separation mode.
## Syntax
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
index ab9f22fb1b6..0fb32522ae9 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
@@ -153,10 +153,10 @@ Users executing this SQL command must have at least the
following permissions:
+-----------+-------------+--------------+
| table_c | 3.102 KB | 40 |
| table_d | .000 | 20 |
- | table_b |=324.000 B |=20 |
- |=table_a |=1.266 KB |=10 |
- |=Total |=4.684 KB |=90 |
- |=Quota |=1024.000 GB |=1073741824 |
- |=Left |=1024.000 GB |=1073741734 |
- +-----------+-------------+--------------+
+ | table_b | 324.000 B | 20 |
+ | table_a | 1.266 KB | 10 |
+ | Total | 4.684 KB | 90 |
+ | Quota | 1024.000 GB | 1073741824 |
+ | Left | 1024.000 GB | 1073741734 |
+ +-----------+-------------+--------------+
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
index 62c1a7f9d3d..94d8519aa24 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
@@ -89,7 +89,7 @@ The user executing this SQL command must have at least the
following privileges:
## Examples
-- 查看表的副本分布
+- View the replica distribution of a table
```sql
SHOW REPLICA DISTRIBUTION FROM sell_user;
@@ -106,7 +106,7 @@ The user executing this SQL command must have at least the
following privileges:
SizePercent: 100.00%
```
-- 查看表的分区的副本分布
+- View the replica distribution of a table's partitions
```sql
SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
index e505dc031e1..d82469265e1 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
@@ -25,11 +25,19 @@ SHOW TABLET STORAGE FORMAT [VERBOSE]
## Return Value
+**Default output** (without `VERBOSE`):
+
+| Column | DataType | Note
|
+|-----------|----------|----------------------------------------------------------------------|
+| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
+| V1Count | Int | Number of V1 version tablets.
|
+| V2Count | Int | Number of V2 version tablets.
|
+
+**With `VERBOSE`**:
+
| Column | DataType | Note
|
|---------------|----------|----------------------------------------------------------------------|
| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
-| V1Count | Int | Number of V1 version tablets.
|
-| V2Count | Int | Number of V2 version tablets.
|
| TabletId | Int | The unique identifier of the tablet.
|
| StorageFormat | String | The version of the tablet, either V1 or V2.
|
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
index 92572508687..1f082b3cef6 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
@@ -17,7 +17,7 @@ Cancel background tasks for index building.
CANCEL BUILD INDEX ON <table_name> [ job_list ]
```
-其中:
+Where:
```sql
job_list
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
index 2572030e2f5..e1e06008743 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
@@ -180,7 +180,7 @@ ALTER TABLE [database.]table table_name MODIFY COLUMN
column_name column_type [K
:::tip
- If you modify the value column in the aggregation model, you need to
specify agg_type
- If you modify the key column for non-aggregate types, you need to specify
the KEY keyword
- - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 8)
+ - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 2
above)
- Partitioning and bucketing columns cannot be modified in any way
- The following types of conversions are currently supported (loss of
precision is guaranteed by the user)
- Conversion of TINYINT/SMALLINT/INT/BIGINT/LARGEINT/FLOAT/DOUBLE types to
larger numeric types
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
index bc555b431f5..c7131061ccf 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
@@ -10,7 +10,7 @@
This statement is used to modify the comment of an existing table. The
operation is synchronous, and the command returns to indicate completion.
-grammar:
+## Syntax
```sql
ALTER TABLE [database.]table alter_clause;
@@ -18,7 +18,7 @@ ALTER TABLE [database.]table alter_clause;
1. Modify table comment
-grammar:
+## Syntax
```sql
MODIFY COMMENT "new table comment";
@@ -26,7 +26,7 @@ MODIFY COMMENT "new table comment";
2. Modify column comment
-grammar:
+## Syntax
```sql
MODIFY COLUMN col1 COMMENT "new column comment";
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
index d1496e201ac..1b2590a65fe 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
@@ -105,9 +105,7 @@ ALTER TABLE example_db.my_table
DROP ROLLUP example_rollup_index2,example_rollup_index3;
```
-###
-
-4. Keywords
+## Keywords
```text
ALTER, TABLE, ROLLUP, ALTER TABLE
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
index 2b4a7b918a5..8481c92302d 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
@@ -89,9 +89,3 @@ CANCEL ALTER TABLE ROLLUP
FROM db_name.table_name (jobid,...)
```
-
-4. Cancel ALTER CLUSTER operation
-
-```sql
-(To be implemented...)
-```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index f6479a3602f..449b4b56e3a 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -679,6 +679,9 @@ This table creates partitions 3 days in advance and deletes
partitions from 3 da
[types: [DATE]; keys: [2020-01-09]; ‥types: [DATE]; keys: [2020-01-10]; )
[types: [DATE]; keys: [2020-01-10]; ‥types: [DATE]; keys: [2020-01-11]; )
[types: [DATE]; keys: [2020-01-11]; ‥types: [DATE]; keys: [2020-01-12]; )
+```
+
+```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
index f08c2b29031..deb9ce920d2 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
@@ -98,3 +98,4 @@ DESC test_table;
| name | varchar(20) | Yes | false | NULL | NONE |
| age | int | Yes | false | NULL | NONE |
+---------+-------------+------+-------+---------+-------+
+```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
index 176d74f9eb8..47e99fc7e31 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
@@ -10,7 +10,7 @@
This statement is used to display the status of all dynamic partition tables
in the current database.
-## Syntax:
+## Syntax
```sql
SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
@@ -19,7 +19,7 @@ SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
## Required Parameters
**1. `<db_name>`**
-pecify the `DB` name to display the status of dynamic partition tables. If not
specified, the status of all dynamic partition tables in the current `DB` will
be displayed by default.
+Specify the `DB` name to display the status of dynamic partition tables. If
not specified, the status of all dynamic partition tables in the current `DB`
will be displayed by default.
## Return Value
| Column | DataType | Note
|
@@ -33,7 +33,7 @@ pecify the `DB` name to display the status of dynamic
partition tables. If not s
| Buckets | varchar | The number of buckets corresponding to
the dynamically created partition.
|
| ReplicationNum | varchar | The number of replicas corresponding to
the dynamically created partition. If not specified, it defaults to the number
of replicas specified when the table was created.
|
| ReplicaAllocation | varchar | The replica distribution strategy
corresponding to the dynamically created partition. If not specified, it
defaults to the replica distribution strategy specified when the table was
created.
|
-| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1rd to 28rd. When time_unit is MONTH, this value
defaults to NULL. |
+| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1st to 28th. When time_unit is MONTH, this value
defaults to NULL. |
| LastUpdateTime | datetime | The last update time of the dynamic
partition, which defaults to NULL.
|
| LastSchedulerTime | datetime | The last scheduling time of the dynamic
partition.
|
| State | varchar | The state of the dynamic partition.
|
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
index 154b04f23de..9550cce54cd 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
@@ -36,7 +36,7 @@ SHOW PARTITION 13004;
Results:
-```sql
+```text
+--------+-----------+---------------+-------+---------+
| DbName | TableName | PartitionName | DbId | TableId |
+--------+-----------+---------------+-------+---------+
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
index 56920fb0ac7..346b9e39c01 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
@@ -6,7 +6,7 @@
}
---
-### Description
+## Description
This statement is used to find the corresponding database name, table name
according to table id.
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/transaction/ROLLBACK.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/transaction/ROLLBACK.md
index ad87a40ae83..768040e9829 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/transaction/ROLLBACK.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/transaction/ROLLBACK.md
@@ -10,7 +10,7 @@
Rollback an explicit transaction. It is used in pairs with [BEGIN](./BEGIN).
-## Syntax(Syntax)
+## Syntax
```sql
ROLLBACK
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
b/versioned_docs/version-3.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
index 9599c2f0b72..ee5d1ca87f6 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
@@ -1,8 +1,8 @@
---
{
"title": "SHOW TYPECAST",
- "language": "zh-CN",
- "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database,"
+ "language": "en",
+ "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
index 1ed0c9b2227..5ff089a6854 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER.md
@@ -10,7 +10,7 @@
This statement is used to view the status of the currently existing broker
processes.
-## Syntax:
+## Syntax
```sql
SHOW BROKER;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
index a03409f28ec..7b2b0279287 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN.md
@@ -10,7 +10,7 @@
This statement is used to uninstall a plugin.
-## Syntax:
+## Syntax
```sql
UNINSTALL PLUGIN <plugin_name>;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
index 22022546335..b89c8383692 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-ENCRYPTKEY.md
@@ -38,7 +38,7 @@ The user executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes
|
|:-------------|:------------|:--------------------------------------------------------------------------------------|
-| `ADMIN_PRIV` | User / Role | Must hold the `ADMIN_PRIV` privilege on the
target user or role to create custom keys |
+| `ADMIN_PRIV` | Global | The user must have the `ADMIN_PRIV` privilege to
create encryption keys |
## Example
@@ -77,9 +77,9 @@ The user executing this SQL command must have at least the
following privileges:
SELECT AES_DECRYPT(UNHEX('D26DB38579D6A343350EDDC6F2AD47C6'), KEY my_key);
```
```text
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| aes_decrypt(unhex('D26DB38579D6A343350EDDC6F2AD47C6'), key my_key) |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
| Doris is Great |
- +------------------------------------------------- -------------------+
+ +---------------------------------------------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-FILE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-FILE.md
index e6da9d95edb..4d35f22b95e 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-FILE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/CREATE-FILE.md
@@ -21,8 +21,6 @@ CREATE FILE <file_name>
## Required Parameters
-**<file_name>**
-
**1. `<file_name>`**
> Custom file name.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/DROP-FILE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/DROP-FILE.md
index 06b0491e604..fc44e5b5694 100644
--- a/versioned_docs/version-4.x/sql-manual/sql-statements/security/DROP-FILE.md
+++ b/versioned_docs/version-4.x/sql-manual/sql-statements/security/DROP-FILE.md
@@ -10,7 +10,7 @@
This statement is used to delete an uploaded file.
-## grammar:
+## Syntax
```sql
DROP FILE "<file_name>" [ { FROM | IN } <database>] PROPERTIES
("<key>"="<value>" [ , ... ])
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/security/SHOW-FILE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/security/SHOW-FILE.md
index 6dbf34d52a9..7a3f588fa04 100644
--- a/versioned_docs/version-4.x/sql-manual/sql-statements/security/SHOW-FILE.md
+++ b/versioned_docs/version-4.x/sql-manual/sql-statements/security/SHOW-FILE.md
@@ -26,7 +26,7 @@ SHOW FILE { [ FROM | IN ] <database_name>}
| Column | Description |
|:------------|:--------------------------------|
-| `FileId` | Globally unique file identifier |
+| `Id` | Globally unique file identifier |
| `DbName` | Name of the owning database |
| `Catalog` | User-defined classification |
| `FileName` | Name of the file |
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
index a03108425c6..77e7b54c5e1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE.md
@@ -22,7 +22,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes
|
|:--------------|:-----------|:-----------------------------------------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the CLEAN
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to clear all profiles
|
## Examples
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
index d7d895d0feb..c732b00ed5c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/KILL-QUERY.md
@@ -44,7 +44,7 @@ The user who executes this SQL command must have at least the
following permissi
| Privilege | Object | Notes |
|:--------------|:-----------|:-----------------------|
-| GRANT_PRIV | DATABASE | GRANT permission is required for the KILL
statement |
+| ADMIN_PRIV | Global | ADMIN privilege is required to kill
queries/connections of other users; killing one's own queries requires no
privilege |
## Usage Notes
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
index 1ddb628217b..b06b9b2b404 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP.md
@@ -57,7 +57,6 @@ Execution result example:
```sql
+-------------------------------------------------------------------------------+
| Plan Replayer dump url
|
-| Plan Replayer dump url |
+-------------------------------------------------------------------------------+
|
http://127.0.0.1:8030/api/minidump?query_id=6e7441f741e94afd-ad3ba69429ad18ec |
+-------------------------------------------------------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
index 2eb16fef06c..8db50bdd7e8 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY.md
@@ -13,7 +13,7 @@ PLAN REPLAYER PLAY is a tool used by Doris developers to
analyze optimizer issue
## Syntax
```sql
-PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
+PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
```
## Required Parameters
@@ -29,5 +29,5 @@ PLAN REPLAYER PLAY <absolute-directory-of-dumpfile>;
When we have a `dumpfile: /home/wangwu/dumpfile.json`, we can use the
following SQL to reproduce the scenario:
```sql
-PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
+PLAN REPLAYER PLAY "/home/wangwu/dumpfile.json";
```
\ No newline at end of file
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
index 331551a2992..865217a740a 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SET-VARIABLE.md
@@ -25,7 +25,7 @@ variable_assignment
## Required Parameters
**1. `<user_var_name>`**
-> Specifies the variable of user level, for example : @@your_variable_name,
variable name starts with `@@`
+> Specifies the variable of user level, for example : @your_variable_name,
variable name starts with `@`
**2. `<system_var_name>`**
> Specifies the variable of system level, for example : exec_mem_limit and so
> on
@@ -65,7 +65,7 @@ Users executing this SQL command must have at least the
following privileges:
- Set a user variable
```
- SET @@your_variable_name = your_variable_value;
+ SET @your_variable_name = your_variable_value;
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
index db285f43c6c..c88bac1cbbc 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/session/variable/SHOW-VARIABLES.md
@@ -31,7 +31,7 @@ Users executing this SQL command must have at least the
following privileges:
| Privilege | Object | Notes |
| :--------- | :----- | :------------------------------------------- |
-| Any_PRIV | Session | Any privilege can show variables |
+| N/A | Session | No specific privilege is required to show variables |
## Return Value
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/statistics/DROP-STATS.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/statistics/DROP-STATS.md
index 04f34fb2096..f93f6ad2935 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/statistics/DROP-STATS.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/statistics/DROP-STATS.md
@@ -24,7 +24,7 @@ column_names
(<column_name>, [ <column_name>... ])
```
-## ## Required Parameters
+## Required Parameters
**<table_name>**
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
index 59d314111c7..05b0acf887e 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET.md
@@ -10,7 +10,7 @@
In the compute-storage coupled mode, this statement is used to diagnose a
specified tablet. The result will display information about the tablet and some
potential issues.
-This command is not supported in the compute-storage coupled mode.
+This command is not supported in the storage-computing separation mode.
## Syntax
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
index ab9f22fb1b6..0fb32522ae9 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA.md
@@ -153,10 +153,10 @@ Users executing this SQL command must have at least the
following permissions:
+-----------+-------------+--------------+
| table_c | 3.102 KB | 40 |
| table_d | .000 | 20 |
- | table_b |=324.000 B |=20 |
- |=table_a |=1.266 KB |=10 |
- |=Total |=4.684 KB |=90 |
- |=Quota |=1024.000 GB |=1073741824 |
- |=Left |=1024.000 GB |=1073741734 |
- +-----------+-------------+--------------+
+ | table_b | 324.000 B | 20 |
+ | table_a | 1.266 KB | 10 |
+ | Total | 4.684 KB | 90 |
+ | Quota | 1024.000 GB | 1073741824 |
+ | Left | 1024.000 GB | 1073741734 |
+ +-----------+-------------+--------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
index 62c1a7f9d3d..94d8519aa24 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION.md
@@ -89,7 +89,7 @@ The user executing this SQL command must have at least the
following privileges:
## Examples
-- 查看表的副本分布
+- View the replica distribution of a table
```sql
SHOW REPLICA DISTRIBUTION FROM sell_user;
@@ -106,7 +106,7 @@ The user executing this SQL command must have at least the
following privileges:
SizePercent: 100.00%
```
-- 查看表的分区的副本分布
+- View the replica distribution of a table's partitions
```sql
SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
index e505dc031e1..d82469265e1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT.md
@@ -25,11 +25,19 @@ SHOW TABLET STORAGE FORMAT [VERBOSE]
## Return Value
+**Default output** (without `VERBOSE`):
+
+| Column | DataType | Note
|
+|-----------|----------|----------------------------------------------------------------------|
+| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
+| V1Count | Int | Number of V1 version tablets.
|
+| V2Count | Int | Number of V2 version tablets.
|
+
+**With `VERBOSE`**:
+
| Column | DataType | Note
|
|---------------|----------|----------------------------------------------------------------------|
| BackendId | Int | The ID of the BE (Backend) node where the tablet
replica is located. |
-| V1Count | Int | Number of V1 version tablets.
|
-| V2Count | Int | Number of V2 version tablets.
|
| TabletId | Int | The unique identifier of the tablet.
|
| StorageFormat | String | The version of the tablet, either V1 or V2.
|
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
index 92572508687..1f082b3cef6 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX.md
@@ -17,7 +17,7 @@ Cancel background tasks for index building.
CANCEL BUILD INDEX ON <table_name> [ job_list ]
```
-其中:
+Where:
```sql
job_list
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
index 2572030e2f5..e1e06008743 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN.md
@@ -180,7 +180,7 @@ ALTER TABLE [database.]table table_name MODIFY COLUMN
column_name column_type [K
:::tip
- If you modify the value column in the aggregation model, you need to
specify agg_type
- If you modify the key column for non-aggregate types, you need to specify
the KEY keyword
- - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 8)
+ - Only the type of the column can be modified, and other attributes of the
column remain as they are (that is, other attributes need to be explicitly
written in the statement according to the original attributes, see example 2
above)
- Partitioning and bucketing columns cannot be modified in any way
- The following types of conversions are currently supported (loss of
precision is guaranteed by the user)
- Conversion of TINYINT/SMALLINT/INT/BIGINT/LARGEINT/FLOAT/DOUBLE types to
larger numeric types
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
index bc555b431f5..c7131061ccf 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT.md
@@ -10,7 +10,7 @@
This statement is used to modify the comment of an existing table. The
operation is synchronous, and the command returns to indicate completion.
-grammar:
+## Syntax
```sql
ALTER TABLE [database.]table alter_clause;
@@ -18,7 +18,7 @@ ALTER TABLE [database.]table alter_clause;
1. Modify table comment
-grammar:
+## Syntax
```sql
MODIFY COMMENT "new table comment";
@@ -26,7 +26,7 @@ MODIFY COMMENT "new table comment";
2. Modify column comment
-grammar:
+## Syntax
```sql
MODIFY COLUMN col1 COMMENT "new column comment";
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
index d1496e201ac..1b2590a65fe 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP.md
@@ -105,9 +105,7 @@ ALTER TABLE example_db.my_table
DROP ROLLUP example_rollup_index2,example_rollup_index3;
```
-###
-
-4. Keywords
+## Keywords
```text
ALTER, TABLE, ROLLUP, ALTER TABLE
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
index d7465c5ff6e..8c4616297a3 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE.md
@@ -89,9 +89,3 @@ CANCEL ALTER TABLE ROLLUP
FROM db_name.table_name (jobid,...)
```
-
-4. Cancel ALTER CLUSTER operation
-
-```sql
-(To be implemented...)
-```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index 56b5ca19dc4..ae8b5fe450c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -682,6 +682,9 @@ This table creates partitions 3 days in advance and deletes
partitions from 3 da
[types: [DATE]; keys: [2020-01-09]; ‥types: [DATE]; keys: [2020-01-10]; )
[types: [DATE]; keys: [2020-01-10]; ‥types: [DATE]; keys: [2020-01-11]; )
[types: [DATE]; keys: [2020-01-11]; ‥types: [DATE]; keys: [2020-01-12]; )
+```
+
+```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
index f08c2b29031..deb9ce920d2 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/DESC-TABLE.md
@@ -98,3 +98,4 @@ DESC test_table;
| name | varchar(20) | Yes | false | NULL | NONE |
| age | int | Yes | false | NULL | NONE |
+---------+-------------+------+-------+---------+-------+
+```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
index 176d74f9eb8..47e99fc7e31 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES.md
@@ -10,7 +10,7 @@
This statement is used to display the status of all dynamic partition tables
in the current database.
-## Syntax:
+## Syntax
```sql
SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
@@ -19,7 +19,7 @@ SHOW DYNAMIC PARTITION TABLES [FROM <db_name>];
## Required Parameters
**1. `<db_name>`**
-pecify the `DB` name to display the status of dynamic partition tables. If not
specified, the status of all dynamic partition tables in the current `DB` will
be displayed by default.
+Specify the `DB` name to display the status of dynamic partition tables. If
not specified, the status of all dynamic partition tables in the current `DB`
will be displayed by default.
## Return Value
| Column | DataType | Note
|
@@ -33,7 +33,7 @@ pecify the `DB` name to display the status of dynamic
partition tables. If not s
| Buckets | varchar | The number of buckets corresponding to
the dynamically created partition.
|
| ReplicationNum | varchar | The number of replicas corresponding to
the dynamically created partition. If not specified, it defaults to the number
of replicas specified when the table was created.
|
| ReplicaAllocation | varchar | The replica distribution strategy
corresponding to the dynamically created partition. If not specified, it
defaults to the replica distribution strategy specified when the table was
created.
|
-| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1rd to 28rd. When time_unit is MONTH, this value
defaults to NULL. |
+| StartOf | varchar | The starting point of each partition
granularity for dynamic partitioning. When time_unit is WEEK, this field
represents the starting point of each week, with values ranging from MONDAY to
SUNDAY. When time_unit is MONTH, it represents the starting date of each month,
with values ranging from 1st to 28th. When time_unit is MONTH, this value
defaults to NULL. |
| LastUpdateTime | datetime | The last update time of the dynamic
partition, which defaults to NULL.
|
| LastSchedulerTime | datetime | The last scheduling time of the dynamic
partition.
|
| State | varchar | The state of the dynamic partition.
|
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
index 154b04f23de..9550cce54cd 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION.md
@@ -36,7 +36,7 @@ SHOW PARTITION 13004;
Results:
-```sql
+```text
+--------+-----------+---------------+-------+---------+
| DbName | TableName | PartitionName | DbId | TableId |
+--------+-----------+---------------+-------+---------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
index 56920fb0ac7..346b9e39c01 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md
@@ -6,7 +6,7 @@
}
---
-### Description
+## Description
This statement is used to find the corresponding database name, table name
according to table id.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/transaction/ROLLBACK.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/transaction/ROLLBACK.md
index ad87a40ae83..768040e9829 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/transaction/ROLLBACK.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/transaction/ROLLBACK.md
@@ -10,7 +10,7 @@
Rollback an explicit transaction. It is used in pairs with [BEGIN](./BEGIN).
-## Syntax(Syntax)
+## Syntax
```sql
ROLLBACK
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
index 9599c2f0b72..ee5d1ca87f6 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/types/SHOW-TYPECAST.md
@@ -1,8 +1,8 @@
---
{
"title": "SHOW TYPECAST",
- "language": "zh-CN",
- "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database,"
+ "language": "en",
+ "description": "View all type cast under the database. If the user
specifies a database, then view the corresponding database, otherwise directly
query the database where the current session is located."
}
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]