This is an automated email from the ASF dual-hosted git repository.
chengzhang 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 c3d680f1c96 Update sharding limitation document when use view with
sharding, broadcast and single tables (#32703)
c3d680f1c96 is described below
commit c3d680f1c9632e135d309c1927eb7641a0858c20
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Tue Aug 27 18:00:06 2024 +0800
Update sharding limitation document when use view with sharding, broadcast
and single tables (#32703)
* Update sharding limitation document when use view with sharding,
broadcast and single tables
* Update doc
---
docs/document/content/features/sharding/limitation.cn.md | 9 +++++++++
docs/document/content/features/sharding/limitation.en.md | 9 +++++++++
2 files changed, 18 insertions(+)
diff --git a/docs/document/content/features/sharding/limitation.cn.md
b/docs/document/content/features/sharding/limitation.cn.md
index fa2a4215f4f..e69a4b8dcd5 100644
--- a/docs/document/content/features/sharding/limitation.cn.md
+++ b/docs/document/content/features/sharding/limitation.cn.md
@@ -104,6 +104,15 @@ SELECT * FROM t_order WHERE to_date(create_time,
'yyyy-mm-dd') = '2019-01-01';
支持 MySQL `LOAD DATA` 和 `LOAD XML` 语句加载数据到单表和广播表。
+### 视图
+
+1. 支持基于单个单表，或多个相同存储节点的单表创建、修改和删除视图；
+2. 支持基于任意个广播表创建、修改和删除视图；
+3. 支持基于任意个分片表创建、修改和删除视图，视图必须和分片表一样配置分片规则，并且视图和分片表必须为绑定表关系；
+4. 支持基于广播表和分片表创建、修改和删除视图，分片表规则同单独使用分片表创建视图；
+5. 支持基于广播表和单表创建、修改和删除视图；
+6. 支持 MySQL `SHOW CREATE TABLE viewName` 查看视图的创建语句。
+
## 实验性支持
实验性支持特指使用 Federation 执行引擎提供支持。 该引擎处于快速开发中，用户虽基本可用，但仍需大量优化，是实验性产品。
diff --git a/docs/document/content/features/sharding/limitation.en.md
b/docs/document/content/features/sharding/limitation.en.md
index 56535aec0c6..d60bda88476 100644
--- a/docs/document/content/features/sharding/limitation.en.md
+++ b/docs/document/content/features/sharding/limitation.en.md
@@ -99,6 +99,15 @@ SELECT * FROM t_order WHERE to_date(create_time,
'yyyy-mm-dd') = '2019-01-01';
Support MySQL `LOAD DATA` and `LOAD XML` statements to load data to single
table and broadcast table.
+### View
+
+1. Support create, alter and drop view based on a single table or multiple
single tables on the same storage node;
+2. Support create, alter and drop view based on any broadcast table;
+3. Support create, alter and drop view based on any sharding table. The view
must be configured with same sharding rules as sharding table, the view and
sharding table must be in same binding table rule;
+4. Support create, alter and drop view based on broadcast tables and sharding
tables. The sharding table rules are same as create view using sharding tables
alone;
+5. Support create, alter and drop view based on broadcast tables and single
tables;
+6. Support MySQL `SHOW CREATE TABLE viewName` to show create statement of the
view.
+
## Experimental Support
Experimental support refers specifically to support provided by implementing
Federation execution engine, an experimental product that is still under
development. Although largely available to users, it still requires significant
optimization.
