You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by ja...@apache.org on 2022/02/22 05:30:59 UTC
[flink] branch master updated: [FLINK-26152] [docs] Translate the page of SQL/queries/WITH clause (#18828)
This is an automated email from the ASF dual-hosted git repository.
jark pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
The following commit(s) were added to refs/heads/master by this push:
new 84530f4 [FLINK-26152] [docs] Translate the page of SQL/queries/WITH clause (#18828)
84530f4 is described below
commit 84530f4d2af96641dc891b7fedefed8c6b1b5c4f
Author: Yibo Wen <88...@users.noreply.github.com>
AuthorDate: Tue Feb 22 13:30:21 2022 +0800
[FLINK-26152] [docs] Translate the page of SQL/queries/WITH clause (#18828)
---
docs/content.zh/docs/dev/table/sql/queries/with.md | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/docs/content.zh/docs/dev/table/sql/queries/with.md b/docs/content.zh/docs/dev/table/sql/queries/with.md
index 5e3a6a3..d90a95a 100644
--- a/docs/content.zh/docs/dev/table/sql/queries/with.md
+++ b/docs/content.zh/docs/dev/table/sql/queries/with.md
@@ -1,5 +1,5 @@
---
-title: "WITH 语句"
+title: "WITH 子句"
weight: 3
type: docs
---
@@ -22,12 +22,12 @@ specific language governing permissions and limitations
under the License.
-->
-# WITH 语句
+# WITH 子句
{{< label Batch >}} {{< label Streaming >}}
-`WITH` provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as Common Table Expression (CTE), can be thought of as defining temporary views that exist just for one query.
+`WITH` 子句提供了一种用于更大查询而编写辅助语句的方法。这些编写的语句通常被称为公用表表达式,表达式可以理解为仅针对某个查询而存在的临时视图。
-The syntax of `WITH` statement is:
+`WITH` 子句的语法
```sql
WITH <with_item_definition> [ , ... ]
@@ -37,7 +37,7 @@ SELECT ... FROM ...;
with_item_name (column_name[, ...n]) AS ( <select_query> )
```
-The following example defines a common table expression `orders_with_total` and use it in a `GROUP BY` query.
+下面的示例中定义了一个公用表表达式 `orders_with_total` ,并在一个 `GROUP BY` 查询中使用它。
```sql
WITH orders_with_total AS (