This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 2d7d8102c7 [fix](doc) fix mal-format doc #16898
2d7d8102c7 is described below
commit 2d7d8102c749777d012fb6646349cc3cbf0273a4
Author: Mingyu Chen <[email protected]>
AuthorDate: Sat Feb 18 14:30:54 2023 +0800
[fix](doc) fix mal-format doc #16898
We must write sql reference with guidance:
https://doris.apache.org/zh-CN/community/how-to-contribute/contribute-doc/#%E5%A6%82%E4%BD%95%E7%BC%96%E5%86%99%E5%91%BD%E4%BB%A4%E5%B8%AE%E5%8A%A9%E6%89%8B%E5%86%8C
---
.../community/how-to-contribute/contribute-doc.md | 2 +-
.../sql-functions/aggregate-functions/grouping.md | 26 ++++++++++++----------
.../community/how-to-contribute/contribute-doc.md | 2 +-
.../sql-functions/aggregate-functions/grouping.md | 25 +++++++++++----------
4 files changed, 29 insertions(+), 26 deletions(-)
diff --git a/docs/en/community/how-to-contribute/contribute-doc.md
b/docs/en/community/how-to-contribute/contribute-doc.md
index 1fd7f30119..b9bd3a583c 100644
--- a/docs/en/community/how-to-contribute/contribute-doc.md
+++ b/docs/en/community/how-to-contribute/contribute-doc.md
@@ -352,7 +352,7 @@ under the License.
## SHOW-ALTER
-### Nameo
+### Name
SHOW ALTER
diff --git
a/docs/en/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
b/docs/en/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
index e642ebd14e..350085cdaf 100755
--- a/docs/en/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
+++ b/docs/en/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
@@ -26,26 +26,24 @@ under the License.
## GROUPING
+### Name
+
+GROUPING
+
+### Description
+
Indicates whether a specified column expression in a `GROUP BY` list is
aggregated or not. `GROUPING` returns 1 for aggregated or 0 for not aggregated
in the result set. `GROUPING` can be used only in the `SELECT <select> list`,
`HAVING`, and `ORDER BY` clauses when `GROUP BY` is specified.
-### Syntax
+`GROUPING` is used to distinguish the null values that are returned by
`ROLLUP`, `CUBE` or `GROUPING SETS` from standard null values. The `NULL`
returned as the result of a `ROLLUP`, `CUBE` or `GROUPING SETS` operation is a
special use of `NULL`. This acts as a column placeholder in the result set and
means all.
```sql
GROUPING( <column_expression> )
```
-### Arguments
-
`<column_expression>`
Is a column or an expression that contains a column in a `GROUP BY` clause.
-### Return Types
-
-BIGINT
-
-### Remarks
-
-`GROUPING` is used to distinguish the null values that are returned by
`ROLLUP`, `CUBE` or `GROUPING SETS` from standard null values. The `NULL`
returned as the result of a `ROLLUP`, `CUBE` or `GROUPING SETS` operation is a
special use of `NULL`. This acts as a column placeholder in the result set and
means all.
+Return Types: BIGINT
### Example
@@ -101,6 +99,10 @@ Here is the result set.
4 rows in set (0.01 sec)
```
-### See Also
+### Keywords
+
+GROUPING
+
+### Best Practice
-[GROUPING_ID](./grouping_id.md)
+See also [GROUPING_ID](./grouping_id.md)
diff --git a/docs/zh-CN/community/how-to-contribute/contribute-doc.md
b/docs/zh-CN/community/how-to-contribute/contribute-doc.md
index 88718d45d0..a360c3519c 100644
--- a/docs/zh-CN/community/how-to-contribute/contribute-doc.md
+++ b/docs/zh-CN/community/how-to-contribute/contribute-doc.md
@@ -349,7 +349,7 @@ under the License.
## SHOW-ALTER
-### Nameo
+### Name
SHOW ALTER
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
b/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
index 5943205c14..fcd860b063 100755
--- a/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/grouping.md
@@ -26,26 +26,24 @@ under the License.
## GROUPING
+### Name
+
+GROUPING
+
+### Description
+
用在含有 CUBE、ROLLUP 或 GROUPING SETS 的 SQL 语句中，用于表示进行 CUBE、ROLLUP 或 GROUPING SETS
操作的列是否汇总。当结果集中的数据行是 CUBE、ROLLUP 或 GROUPING SETS 操作产生的汇总结果时，该函数返回 1，否则返回
0。GROUPING 函数可以在 `SELECT`、`HAVING` 和 `ORDER BY` 子句当中使用。
-### Syntax
+`ROLLUP`、`CUBE` 或 `GROUPING SETS` 操作返回的汇总结果，会用 NULL 充当被分组的字段的值。因此，`GROUPING`
通常用于区分 `ROLLUP`、`CUBE` 或 `GROUPING SETS` 返回的空值与表中的空值。
```sql
GROUPING( <column_expression> )
```
-### Arguments
-
`<column_expression>`
是在 `GROUP BY` 子句中包含的列或表达式。
-### Return Types
-
-BIGINT
-
-### Remarks
-
-`ROLLUP`、`CUBE` 或 `GROUPING SETS` 操作返回的汇总结果，会用 NULL 充当被分组的字段的值。因此，`GROUPING`
通常用于区分 `ROLLUP`、`CUBE` 或 `GROUPING SETS` 返回的空值与表中的空值。
+返回值：BIGINT
### Example
@@ -100,7 +98,10 @@ GROUP BY
+----------+---------+----------+
4 rows in set (0.01 sec)
```
+### Keywords
+
+GROUPING
-### See Also
+### Best Practice
-[GROUPING_ID](./grouping_id.md)
+还可参阅 [GROUPING_ID](./grouping_id.md)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
