This is an automated email from the ASF dual-hosted git repository.
jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 48b1d6ad00d update DistSQL doc of broadcast table (#26426)
48b1d6ad00d is described below
commit 48b1d6ad00d64f7617b5fb4dfdf25804cf2cc9c0
Author: jiangML <[email protected]>
AuthorDate: Mon Jun 19 12:11:43 2023 +0800
update DistSQL doc of broadcast table (#26426)
---
.../rule-definition/broadcast-table/_index.cn.md | 7 +++++
.../rule-definition/broadcast-table/_index.en.md | 7 +++++
.../create-broadcast-table-rule.cn.md | 2 +-
.../create-broadcast-table-rule.en.md | 2 +-
.../drop-broadcast-table-rule.cn.md | 2 +-
.../drop-broadcast-table-rule.en.md | 2 +-
.../rdl/rule-definition/encrypt/_index.cn.md | 2 +-
.../rdl/rule-definition/encrypt/_index.en.md | 2 +-
.../syntax/rdl/rule-definition/mask/_index.cn.md | 2 +-
.../syntax/rdl/rule-definition/mask/_index.en.md | 2 +-
.../readwrite-splitting/_index.cn.md | 2 +-
.../readwrite-splitting/_index.en.md | 2 +-
.../syntax/rdl/rule-definition/shadow/_index.cn.md | 2 +-
.../syntax/rdl/rule-definition/shadow/_index.en.md | 2 +-
.../rdl/rule-definition/single-table/_index.cn.md | 2 +-
.../rdl/rule-definition/single-table/_index.en.md | 2 +-
.../rql/rule-query/broadcast-table/_index.cn.md | 7 +++++
.../rql/rule-query/broadcast-table/_index.en.md | 7 +++++
.../count-broadcast-rule.cn.md} | 32 ++++++++++------------
.../count-broadcast-rule.en.md} | 32 ++++++++++------------
.../show-broadcast-table-rule.cn.md | 2 +-
.../show-broadcast-table-rule.en.md | 2 +-
.../syntax/rql/rule-query/encrypt/_index.cn.md | 2 +-
.../syntax/rql/rule-query/encrypt/_index.en.md | 2 +-
.../syntax/rql/rule-query/mask/_index.cn.md | 2 +-
.../syntax/rql/rule-query/mask/_index.en.md | 2 +-
.../rule-query/readwrite-splitting/_index.cn.md | 2 +-
.../rule-query/readwrite-splitting/_index.en.md | 2 +-
.../syntax/rql/rule-query/shadow/_index.cn.md | 2 +-
.../syntax/rql/rule-query/shadow/_index.en.md | 2 +-
.../rule-query/sharding/count-sharding-rule.cn.md | 6 ++--
.../rule-query/sharding/count-sharding-rule.en.md | 6 ++--
.../rql/rule-query/single-table/_index.cn.md | 2 +-
.../rql/rule-query/single-table/_index.en.md | 2 +-
.../src/main/resources/conf/config-sharding.yaml | 6 ++--
.../conf/config-sql-hint-data-source.yaml | 7 +++--
36 files changed, 94 insertions(+), 75 deletions(-)
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.cn.md
new file mode 100644
index 00000000000..a14b7854ff2
--- /dev/null
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.cn.md
@@ -0,0 +1,7 @@
++++
+title = "广播表
+weight = 2
+chapter = true
++++
+
+本章节将对广播表特性的语法进行详细说明。
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.en.md
new file mode 100644
index 00000000000..c1cb7a50d18
--- /dev/null
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/_index.en.md
@@ -0,0 +1,7 @@
++++
+title = "Broadcast Table"
+weight = 2
+chapter = true
++++
+
+This chapter describes the syntax of broadcast table.
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.cn.md
similarity index 97%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.cn.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.cn.md
index 88ae19a8700..bc956e117a7 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.cn.md
@@ -1,6 +1,6 @@
+++
title = "CREATE BROADCAST TABLE RULE"
-weight = 15
+weight = 1
+++
## 描述
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.en.md
similarity index 99%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.en.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.en.md
index 2650414dd9e..ced98d1348b 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/create-broadcast-table-rule.en.md
@@ -1,6 +1,6 @@
+++
title = "CREATE BROADCAST TABLE RULE"
-weight = 15
+weight = 1
+++
## Description
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.cn.md
similarity index 97%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.cn.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.cn.md
index 75b74c183a1..62598ed3b9f 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.cn.md
@@ -1,6 +1,6 @@
+++
title = "DROP BROADCAST TABLE RULE"
-weight = 16
+weight = 2
+++
## 描述
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.en.md
similarity index 98%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.en.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.en.md
index a8bb4c62bdb..b882633bb1a 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/broadcast-table/drop-broadcast-table-rule.en.md
@@ -1,6 +1,6 @@
+++
title = "DROP BROADCAST TABLE RULE"
-weight = 16
+weight = 2
+++
## Description
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.cn.md
index 0c504fd6567..139790c1d44 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "数据加密"
-weight = 4
+weight = 5
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.en.md
index 48d9916ca1a..7991ab35611 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Encrypt"
-weight = 4
+weight = 5
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.cn.md
index 209731a260a..a97c2844455 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "数据脱敏"
-weight = 5
+weight = 6
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.en.md
index 96488b5db78..cc60e96f230 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Mask"
-weight = 5
+weight = 6
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.cn.md
index 5c6b4fce2a8..dd75b0864f2 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "读写分离"
-weight = 3
+weight = 4
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.en.md
index f17e2478ac3..afdb368478e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Readwrite-Splitting"
-weight = 3
+weight = 4
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.cn.md
index c4eb8d257cd..c3c95bb051e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "影子库压测"
-weight = 6
+weight = 7
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.en.md
index 3027bbd4337..cfff0f45fc8 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Shadow"
-weight = 6
+weight = 7
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.cn.md
index 02ed66a5e9f..91964483dac 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "单表"
-weight = 2
+weight = 3
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.en.md
index 6710270ac36..8deb51024c9 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Single Table"
-weight = 2
+weight = 3
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.cn.md
new file mode 100644
index 00000000000..e23f1adefae
--- /dev/null
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.cn.md
@@ -0,0 +1,7 @@
++++
+title = "广播表"
+weight = 2
+chapter = true
++++
+
+本章节将对广播表特性的语法进行详细说明。
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.en.md
new file mode 100644
index 00000000000..c1cb7a50d18
--- /dev/null
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/_index.en.md
@@ -0,0 +1,7 @@
++++
+title = "Broadcast Table"
+weight = 2
+chapter = true
++++
+
+This chapter describes the syntax of broadcast table.
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.cn.md
similarity index 64%
copy from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
copy to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.cn.md
index 4383ac9b8cc..c4bebb077fa 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.cn.md
@@ -1,19 +1,19 @@
+++
-title = "COUNT SHARDING RULE"
-weight = 15
+title = "COUNT BROADCAST RULE"
+weight = 2
+++
### 描述
-`COUNT SHARDING RULE` 语法用于查询指定逻辑库中的分片规则数量。
+`COUNT BROADCAST RULE` 语法用于查询指定逻辑库中的广播表规则数量。
### 语法
{{< tabs >}}
{{% tab name="语法" %}}
```sql
-CountShardingRule::=
- 'COUNT' 'SHARDING' 'RULE' ('FROM' databaseName)?
+CountBroadcastRule::=
+ 'COUNT' 'BROADCAST' 'RULE' ('FROM' databaseName)?
databaseName ::=
identifier
@@ -39,45 +39,41 @@ databaseName ::=
### 示例
-- 查询指定逻辑库中的分片规则数量
+- 查询指定逻辑库中的广播表规则数量
```sql
-COUNT SHARDING RULE FROM sharding_db;
+COUNT BROADCAST RULE FROM sharding_db;
```
```sql
-mysql> COUNT SHARDING RULE FROM sharding_db;
+mysql> COUNT BROADCAST RULE FROM sharding_db;
+--------------------------+----------------+-------+
| rule_name | database | count |
+--------------------------+----------------+-------+
-| sharding_table | sharding_db | 2 |
-| sharding_table_reference | sharding_db | 2 |
| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+1 rows in set (0.00 sec)
```
-- 查询当前逻辑库中的分片规则数量
+- 查询当前逻辑库中的广播表规则数量
```sql
-COUNT SHARDING RULE;
+COUNT BROADCAST RULE;
```
```sql
-mysql> COUNT SHARDING RULE;
+mysql> COUNT BROADCAST RULE;
+--------------------------+----------------+-------+
| rule_name | database | count |
+--------------------------+----------------+-------+
-| sharding_table | sharding_db | 2 |
-| sharding_table_reference | sharding_db | 2 |
| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+1 rows in set (0.00 sec)
```
### 保留字
-`COUNT`、`SHARDING`、`RULE`、`FROM`
+`COUNT`、`BROADCAST`、`RULE`、`FROM`
### 相关链接
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.en.md
similarity index 65%
copy from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
copy to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.en.md
index 84fb2f91c66..d1c3ed262f5 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/count-broadcast-rule.en.md
@@ -1,19 +1,19 @@
+++
-title = "COUNT SHARDING RULE"
-weight = 15
+title = "COUNT BROADCAST RULE"
+weight = 2
+++
### Description
-The `COUNT SHARDING RULE` syntax is used to query the number of sharding rules
for specified database.
+The `COUNT BROADCAST RULE` syntax is used to query the number of broadcast
table rules for specified database.
### Syntax
{{< tabs >}}
{{% tab name="Grammar" %}}
```sql
-CountShardingRule::=
- 'COUNT' 'SHARDING' 'RULE' ('FROM' databaseName)?
+CountBroadcastRule::=
+ 'COUNT' 'BROADCAST' 'RULE' ('FROM' databaseName)?
databaseName ::=
identifier
@@ -39,45 +39,41 @@ databaseName ::=
### Example
-- Query the number of sharding rules for specified database.
+- Query the number of broadcast table rules for specified database.
```sql
-COUNT SHARDING RULE FROM sharding_db;
+COUNT BROADCAST RULE FROM sharding_db;
```
```sql
-mysql> COUNT SHARDING RULE FROM sharding_db;
+mysql> COUNT BROADCAST RULE FROM sharding_db;
+--------------------------+----------------+-------+
| rule_name | database | count |
+--------------------------+----------------+-------+
-| sharding_table | sharding_db | 2 |
-| sharding_table_reference | sharding_db | 2 |
| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+1 rows in set (0.00 sec)
```
-- Query the number of sharding rules for current database.
+- Query the number of broadcast table rules for current database.
```sql
-COUNT SHARDING RULE;
+COUNT BROADCAST RULE;
```
```sql
-mysql> COUNT SHARDING RULE;
+mysql> COUNT BROADCAST RULE;
+--------------------------+----------------+-------+
| rule_name | database | count |
+--------------------------+----------------+-------+
-| sharding_table | sharding_db | 2 |
-| sharding_table_reference | sharding_db | 2 |
| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+1 rows in set (0.00 sec)
```
### Reserved word
-`COUNT`, `SHARDING`, `RULE`, `FROM`
+`COUNT`, `BROADCAST`, `RULE`, `FROM`
### Related links
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.cn.md
similarity index 98%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.cn.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.cn.md
index 71f4a55d7de..79fcef904c0 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.cn.md
@@ -1,6 +1,6 @@
+++
title = "SHOW BROADCAST TABLE RULE"
-weight = 14
+weight = 1
+++
## 描述
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.en.md
similarity index 99%
rename from
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.en.md
rename to
docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.en.md
index e496c9f08d9..0b3caa54bd3 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/broadcast-table/show-broadcast-table-rule.en.md
@@ -1,6 +1,6 @@
+++
title = "SHOW BROADCAST TABLE RULE"
-weight = 14
+weight = 1
+++
## Description
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.cn.md
index 0c504fd6567..139790c1d44 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "数据加密"
-weight = 4
+weight = 5
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.en.md
index 48d9916ca1a..7991ab35611 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Encrypt"
-weight = 4
+weight = 5
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.cn.md
index 209731a260a..a97c2844455 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "数据脱敏"
-weight = 5
+weight = 6
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.en.md
index 96488b5db78..cc60e96f230 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Mask"
-weight = 5
+weight = 6
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.cn.md
index 5c6b4fce2a8..dd75b0864f2 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "读写分离"
-weight = 3
+weight = 4
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.en.md
index f17e2478ac3..afdb368478e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Readwrite-Splitting"
-weight = 3
+weight = 4
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.cn.md
index c4eb8d257cd..c3c95bb051e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "影子库压测"
-weight = 6
+weight = 7
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.en.md
index 3027bbd4337..cfff0f45fc8 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Shadow"
-weight = 6
+weight = 7
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
index 4383ac9b8cc..c252a02331d 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.cn.md
@@ -52,9 +52,8 @@ mysql> COUNT SHARDING RULE FROM sharding_db;
+--------------------------+----------------+-------+
| sharding_table | sharding_db | 2 |
| sharding_table_reference | sharding_db | 2 |
-| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+2 rows in set (0.00 sec)
```
- 查询当前逻辑库中的分片规则数量
@@ -70,9 +69,8 @@ mysql> COUNT SHARDING RULE;
+--------------------------+----------------+-------+
| sharding_table | sharding_db | 2 |
| sharding_table_reference | sharding_db | 2 |
-| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+2 rows in set (0.00 sec)
```
### 保留字
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
index 84fb2f91c66..89ebcb939aa 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule.en.md
@@ -52,9 +52,8 @@ mysql> COUNT SHARDING RULE FROM sharding_db;
+--------------------------+----------------+-------+
| sharding_table | sharding_db | 2 |
| sharding_table_reference | sharding_db | 2 |
-| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+2 rows in set (0.00 sec)
```
- Query the number of sharding rules for current database.
@@ -70,9 +69,8 @@ mysql> COUNT SHARDING RULE;
+--------------------------+----------------+-------+
| sharding_table | sharding_db | 2 |
| sharding_table_reference | sharding_db | 2 |
-| broadcast_table | sharding_db | 0 |
+--------------------------+----------------+-------+
-3 rows in set (0.00 sec)
+2 rows in set (0.00 sec)
```
### Reserved word
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.cn.md
index 02ed66a5e9f..91964483dac 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.cn.md
@@ -1,6 +1,6 @@
+++
title = "单表"
-weight = 2
+weight = 3
chapter = true
+++
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.en.md
index 6710270ac36..8deb51024c9 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/_index.en.md
@@ -1,6 +1,6 @@
+++
title = "Single Table"
-weight = 2
+weight = 3
chapter = true
+++
diff --git
a/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf/config-sharding.yaml
b/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf/config-sharding.yaml
index cd07e4f30fc..6eb43063776 100644
---
a/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf/config-sharding.yaml
+++
b/examples/shardingsphere-proxy-example/shardingsphere-proxy-boot-mybatis-example/src/main/resources/conf/config-sharding.yaml
@@ -67,8 +67,6 @@ rules:
keyGeneratorName: snowflake
bindingTables:
- t_order,t_order_item
- broadcastTables:
- - t_address
defaultDatabaseStrategy:
standard:
shardingColumn: user_id
@@ -93,3 +91,7 @@ rules:
keyGenerators:
snowflake:
type: SNOWFLAKE
+
+- !BROADCAST
+ tables:
+ - t_address
diff --git
a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-sql-hint-data-source.yaml
b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-sql-hint-data-source.yaml
index dbeeeb09325..070a9c65e90 100644
---
a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-sql-hint-data-source.yaml
+++
b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-sql-hint-data-source.yaml
@@ -46,10 +46,11 @@ rules:
actualDataNodes: ds_${0..1}.t_order_item
bindingTables:
- t_order,t_order_item
- broadcastTables:
- - t_address
-
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
+
+- !BROADCAST
+ tables:
+ - t_address
