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 2023/03/19 11:53:59 UTC
[flink] branch master updated (770d361048b -> 9830fd831cf)
This is an automated email from the ASF dual-hosted git repository.
jark pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
from 770d361048b [python][docs] Update PyFlink docker image build documentation
new aec9efb811b [FLINK-30731][docs-zh] Translate "Set Operations" page of "Queries" into Chinese
new 9830fd831cf [FLINK-30731][docs-zh] Improve the translation of "Set Operations" page
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../docs/dev/table/sql/queries/set-ops.md | 23 +++++++++++-----------
1 file changed, 11 insertions(+), 12 deletions(-)
[flink] 02/02: [FLINK-30731][docs-zh] Improve the translation of "Set Operations" page
Posted by ja...@apache.org.
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
commit 9830fd831cfc1ffa1382270a0f329c509d9021f3
Author: Jark Wu <ja...@apache.org>
AuthorDate: Sun Mar 19 19:50:22 2023 +0800
[FLINK-30731][docs-zh] Improve the translation of "Set Operations" page
---
docs/content.zh/docs/dev/table/sql/queries/set-ops.md | 9 ++++-----
1 file changed, 4 insertions(+), 5 deletions(-)
diff --git a/docs/content.zh/docs/dev/table/sql/queries/set-ops.md b/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
index a437719274d..5508f9fc336 100644
--- a/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
+++ b/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
@@ -88,7 +88,7 @@ Flink SQL> (SELECT s FROM t1) INTERSECT ALL (SELECT s FROM t2);
## EXCEPT
-`EXCEPT` 和 `EXCEPT ALL` 返回在一个表中存在，但在其他表中不存在数据。
+`EXCEPT` 和 `EXCEPT ALL` 返回在一个表中存在，但在另一个表中不存在数据。
`EXCEPT` 会去重，`EXCEPT ALL`不会去重。
```sql
@@ -110,8 +110,7 @@ Flink SQL> (SELECT s FROM t1) EXCEPT ALL (SELECT s FROM t2);
## IN
-如果表达式（可以是列，也可以是函数等）存在于子查询的结果中，则返回 true。
-子查询的表结果必须由一列组成。此列必须与表达式具有相同的数据类型。
+如果表达式（可以是列，也可以是函数等）存在于子查询的结果中，则返回 true。子查询的表结果必须由一列组成。此列必须与表达式具有相同的数据类型。
```sql
SELECT user, amount
@@ -121,7 +120,7 @@ WHERE product IN (
)
```
-优化器会把 `IN` 条件重写为 join 和 group 操作。对于流式查询，用于计算查询结果的状态可能无限膨胀。状态的大小取决于分组的数量以及聚合函数的数量和类型。例如：`MIN`/`MAX` 的状态是重量级的，`COUNT` 是轻量级的。可以提供一个合适的状态time-to-live（TTL）置来防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
+优化器会把 `IN` 条件重写为 join 和 group 操作。对于流式查询，计算查询结果所需的状态可能会根据输入行数而无限增长。你可以设置一个合适的状态 time-to-live（TTL）来淘汰过期数据以防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
## EXISTS
@@ -135,6 +134,6 @@ WHERE product EXISTS (
如果子查询返回至少一行，则为 true。只支持能被重写为 join 和 group 的操作。
-优化器会把 `EXIST` 重写为 join 和 group 操作。对于流式查询，用于计算查询结果的状态可能无限膨胀。状态的大小取决于分组的数量以及聚合函数的数量和类型。例如：`MIN`/`MAX` 的状态是重量级的，`COUNT` 是轻量级的。可以提供一个合适的状态time-to-live（TTL）配置来防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
+优化器会把 `EXIST` 重写为 join 和 group 操作.对于流式查询，计算查询结果所需的状态可能会根据输入行数而无限增长。你可以设置一个合适的状态 time-to-live（TTL）来淘汰过期数据以防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
{{< top >}}
[flink] 01/02: [FLINK-30731][docs-zh] Translate "Set Operations" page of "Queries" into Chinese
Posted by ja...@apache.org.
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
commit aec9efb811bb37b28e168435d679416044ac5d8e
Author: HaiYang Chen <69...@qq.com>
AuthorDate: Wed Jan 18 16:09:19 2023 +0800
[FLINK-30731][docs-zh] Translate "Set Operations" page of "Queries" into Chinese
This closes #21713
---
.../docs/dev/table/sql/queries/set-ops.md | 24 +++++++++++-----------
1 file changed, 12 insertions(+), 12 deletions(-)
diff --git a/docs/content.zh/docs/dev/table/sql/queries/set-ops.md b/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
index 3c58da147e9..a437719274d 100644
--- a/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
+++ b/docs/content.zh/docs/dev/table/sql/queries/set-ops.md
@@ -22,13 +22,13 @@ specific language governing permissions and limitations
under the License.
-->
-# Set Operations
+# 集合操作
{{< label Batch >}} {{< label Streaming >}}
## UNION
-`UNION` and `UNION ALL` return the rows that are found in either table.
-`UNION` takes only distinct rows while `UNION ALL` does not remove duplicates from the result rows.
+`UNION` 和 `UNION ALL` 返回两个表中的数据。
+`UNION` 会去重，`UNION ALL` 不会去重。
```sql
Flink SQL> create view t1(s) as values ('c'), ('a'), ('b'), ('b'), ('c');
@@ -64,8 +64,8 @@ Flink SQL> (SELECT s FROM t1) UNION ALL (SELECT s FROM t2);
## INTERSECT
-`INTERSECT` and `INTERSECT ALL` return the rows that are found in both tables.
-`INTERSECT` takes only distinct rows while `INTERSECT ALL` does not remove duplicates from the result rows.
+`INTERSECT` 和 `INTERSECT ALL` 返回两个表中共有的数据。
+`INTERSECT` 会去重，`INTERSECT ALL` 不会去重。
```sql
Flink SQL> (SELECT s FROM t1) INTERSECT (SELECT s FROM t2);
@@ -88,8 +88,8 @@ Flink SQL> (SELECT s FROM t1) INTERSECT ALL (SELECT s FROM t2);
## EXCEPT
-`EXCEPT` and `EXCEPT ALL` return the rows that are found in one table but not the other.
-`EXCEPT` takes only distinct rows while `EXCEPT ALL` does not remove duplicates from the result rows.
+`EXCEPT` 和 `EXCEPT ALL` 返回在一个表中存在，但在其他表中不存在数据。
+`EXCEPT` 会去重，`EXCEPT ALL`不会去重。
```sql
Flink SQL> (SELECT s FROM t1) EXCEPT (SELECT s FROM t2);
@@ -110,8 +110,8 @@ Flink SQL> (SELECT s FROM t1) EXCEPT ALL (SELECT s FROM t2);
## IN
-Returns true if an expression exists in a given table sub-query. The sub-query table must
-consist of one column. This column must have the same data type as the expression.
+如果表达式（可以是列，也可以是函数等）存在于子查询的结果中，则返回 true。
+子查询的表结果必须由一列组成。此列必须与表达式具有相同的数据类型。
```sql
SELECT user, amount
@@ -121,7 +121,7 @@ WHERE product IN (
)
```
-The optimizer rewrites the IN condition into a join and group operation. For streaming queries, the required state for computing the query result might grow infinitely depending on the number of distinct input rows. You can provide a query configuration with an appropriate state time-to-live (TTL) to prevent excessive state size. Note that this might affect the correctness of the query result. See [query configuration]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl) for details.
+优化器会把 `IN` 条件重写为 join 和 group 操作。对于流式查询，用于计算查询结果的状态可能无限膨胀。状态的大小取决于分组的数量以及聚合函数的数量和类型。例如：`MIN`/`MAX` 的状态是重量级的，`COUNT` 是轻量级的。可以提供一个合适的状态time-to-live（TTL）置来防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
## EXISTS
@@ -133,8 +133,8 @@ WHERE product EXISTS (
)
```
-Returns true if the sub-query returns at least one row. Only supported if the operation can be rewritten in a join and group operation.
+如果子查询返回至少一行，则为 true。只支持能被重写为 join 和 group 的操作。
-The optimizer rewrites the `EXISTS` operation into a join and group operation. For streaming queries, the required state for computing the query result might grow infinitely depending on the number of distinct input rows. You can provide a query configuration with an appropriate state time-to-live (TTL) to prevent excessive state size. Note that this might affect the correctness of the query result. See [query configuration]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl) for details.
+优化器会把 `EXIST` 重写为 join 和 group 操作。对于流式查询，用于计算查询结果的状态可能无限膨胀。状态的大小取决于分组的数量以及聚合函数的数量和类型。例如：`MIN`/`MAX` 的状态是重量级的，`COUNT` 是轻量级的。可以提供一个合适的状态time-to-live（TTL）配置来防止状态过大。注意：这可能会影响查询结果的正确性。详情参见：[查询配置]({{< ref "docs/dev/table/config" >}}#table-exec-state-ttl)。
{{< top >}}