You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by lu...@apache.org on 2024/04/20 22:55:16 UTC
(doris-website) branch master updated: [fix]delete error docs (#570)
This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 444db7ee07 [fix]delete error docs (#570)
444db7ee07 is described below
commit 444db7ee07c78d055ba220960de878357cdf781e
Author: ZhenchaoXu <49...@users.noreply.github.com>
AuthorDate: Sun Apr 21 06:55:10 2024 +0800
[fix]delete error docs (#570)
---
.../query/query-data/common-table-expression.md | 43 ---------------------
.../query/query-data/common-table-expression.md | 45 ----------------------
versioned_sidebars/version-2.0-sidebars.json | 1 -
3 files changed, 89 deletions(-)
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/common-table-expression.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/common-table-expression.md
deleted file mode 100644
index 984229ec54..0000000000
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/common-table-expression.md
+++ /dev/null
@@ -1,43 +0,0 @@
----
-{
- "title": "公用表表达式（CTE）",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-公用表表达式（common table expression）定义一个临时结果集，您可以在 SQL 语句的范围内多次引用。CTE 主要用于 SELECT 语句中。
-
-要指定公用表表达式，请使用 `WITH` 具有一个或多个逗号分隔子句的子句。每个子条款都提供一个子查询，用于生成结果集，并将名称与子查询相关联。下面的示例定义名为的 CTE `cte1` 和 `cte2` 中 `WITH` 子句，并且是指在它们的顶层 `SELECT` 下面的 `WITH` 子句：
-
-```sql
-WITH
- cte1 AS（SELECT a，b FROM table1），
- cte2 AS（SELECT c，d FROM table2）
-SELECT b，d FROM cte1 JOIN cte2
-WHERE cte1.a = cte2.c;
-```
-
-在包含该 `WITH`子句 的语句中，可以引用每个 CTE 名称以访问相应的 CTE 结果集。
-
-CTE 名称可以在其他 CTE 中引用，从而可以基于其他 CTE 定义 CTE。
-
-CTE 可以引用自身来定义递归 CTE。递归 CTE 的常见应用包括分层或树状结构数据的序列生成和遍历。
\ No newline at end of file
diff --git a/versioned_docs/version-2.0/query/query-data/common-table-expression.md b/versioned_docs/version-2.0/query/query-data/common-table-expression.md
deleted file mode 100644
index f51b304b05..0000000000
--- a/versioned_docs/version-2.0/query/query-data/common-table-expression.md
+++ /dev/null
@@ -1,45 +0,0 @@
----
-{
- "title": "Common Table Expression",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-
-Common Table Expressions (CTEs) define a temporary result set that can be referenced multiple times within the scope of an SQL statement. CTEs are primarily used in SELECT statements.
-
-To specify a CTE, use the WITH clause with one or more comma-separated clauses. Each clause provides a subquery that generates a result set and associates a name with the subquery.
-
-The following example defines CTEs named `cte1` and `cte2` within the `WITH` clause and refers to them in the top-level `SELECT` below the `WITH` clause:
-
-```sql
-WITH
- cte1 AS (SELECT a, b FROM table1),
- cte2 AS (SELECT c, d FROM table2)
-SELECT b, d FROM cte1 JOIN cte2
-WHERE cte1.a = cte2.c;
-```
-
-
-Within the statement that contains the `WITH` clause, you can reference each CTE name to access the corresponding CTE result set. CTE names can be referenced in other CTEs, allowing you to define CTEs based on other CTEs.
-
-CTEs can also refer to themselves to define recursive CTEs. Recursive CTEs are commonly used for generating and traversing hierarchical or tree-like structured data.
\ No newline at end of file
diff --git a/versioned_sidebars/version-2.0-sidebars.json b/versioned_sidebars/version-2.0-sidebars.json
index 8757c00412..d968210c14 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -160,7 +160,6 @@
"query/query-data/select",
"query/query-data/complex-type",
"query/query-data/subquery",
- "query/query-data/common-table-expression",
"query/query-data/lateral-view",
"query/query-data/window-function",
"query/query-data/encryption-function"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org