You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2022/12/05 16:20:17 UTC
[doris] branch master updated: [Enhancement](docs) Added grouping sets syntax for group by. (#14805)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 32a33c5119 [Enhancement](docs) Added grouping sets syntax for group by. (#14805)
32a33c5119 is described below
commit 32a33c51193420aeb702e9d32ba4f9990a3c194e
Author: luozenglin <37...@users.noreply.github.com>
AuthorDate: Tue Dec 6 00:20:08 2022 +0800
[Enhancement](docs) Added grouping sets syntax for group by. (#14805)
---
.../Data-Manipulation-Statements/Manipulation/SELECT.md | 5 ++---
.../Data-Manipulation-Statements/Manipulation/SELECT.md | 5 ++---
2 files changed, 4 insertions(+), 6 deletions(-)
diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
index fe56e3f303..a8aa259e8e 100644
--- a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
+++ b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
@@ -47,8 +47,7 @@ SELECT
[TABLESAMPLE sample_value [ROWS | PERCENT]
[REPEATABLE pos_seek]]
[WHERE where_condition]
- [GROUP BY {col_name | expr | position}
- [ASC | DESC], ... [WITH ROLLUP]]
+ [GROUP BY [GROUPING SETS | ROLLUP | CUBE] {col_name | expr | position}]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
@@ -70,7 +69,7 @@ SELECT
6. `INTO OUTFILE 'file_name' ` : save the result to a new file (which did not exist before), the difference lies in the save format.
- 7. `Group [asc/desc]by having`: Group the result set, and brush the result of group by when having appears.
+ 7. `Group by having`: Group the result set, and brush the result of group by when having appears. `Grouping Sets`, `Rollup`, `Cube` are extensions of group by, please refer to [GROUPING SETS DESIGN](../../../../../community/design/grouping_sets_design.md) for details.
8. `Order by`: Sort the final result, Order by sorts the result set by comparing the size of one or more columns.
diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
index bfb8dd464a..eed87118d5 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
@@ -47,8 +47,7 @@ SELECT
[TABLESAMPLE sample_value [ROWS | PERCENT]
[REPEATABLE pos_seek]]
[WHERE where_condition]
- [GROUP BY {col_name | expr | position}
- [ASC | DESC], ... [WITH ROLLUP]]
+ [GROUP BY [GROUPING SETS | ROLLUP | CUBE] {col_name | expr | position}]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
@@ -70,7 +69,7 @@ SELECT
6. `INTO OUTFILE 'file_name' ` ：保存结果至新文件（之前不存在）中，区别在于保存的格式。
-7. `Group [asc/desc]by having`：对结果集进行分组，having 出现则对 group by 的结果进行刷选，
+7. `Group by having`：对结果集进行分组，having 出现则对 group by 的结果进行刷选。`Grouping Sets`、`Rollup`、`Cube` 为group by的扩展，详细可参考[GROUPING SETS 设计文档](../../../../../community/design/grouping_sets_design.md)。
8. `Order by `: 对最后的结果进行排序，Order by 通过比较一列或者多列的大小来对结果集进行排序。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org