[doris] branch master updated: [docs] Fixed description about GROUPING_ID in GROUPING SETS DESIGN. (#10805)

[yi...@apache.org]

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 c8e13caf63 [docs] Fixed description about GROUPING_ID in GROUPING SETS DESIGN. (#10805)
c8e13caf63 is described below

commit c8e13caf634b413498089bdc9589e2ce3221ca87
Author: luozenglin <37...@users.noreply.github.com>
AuthorDate: Fri Jul 15 19:59:28 2022 +0800

    [docs] Fixed description about GROUPING_ID in GROUPING SETS DESIGN. (#10805)
---
 docs/en/developer/design/grouping_sets_design.md    | 2 +-
 docs/zh-CN/developer/design/grouping_sets_design.md | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/docs/en/developer/design/grouping_sets_design.md b/docs/en/developer/design/grouping_sets_design.md
index 16acc33997..483f1ee856 100644
--- a/docs/en/developer/design/grouping_sets_design.md
+++ b/docs/en/developer/design/grouping_sets_design.md
@@ -138,7 +138,7 @@ Indicates whether a specified column expression in a `GROUP BY` list is aggregat
 
 `GROUPING_ID` describes which of a list of expressions are grouped in a row produced by a `GROUP BY` query. The `GROUPING_ID` function simply returns the decimal equivalent of the binary value formed as a result of the concatenation of the values returned by the `GROUPING` functions.
 
-Each `GROUPING_ID` argument must be an element of the `GROUP BY` list. `GROUPING_ID ()` returns an **integer** bitmap whose lowest N bits may be lit. A lit **bit** indicates the corresponding argument is not a grouping column for the given output row. The lowest-order **bit** corresponds to argument N, and the N-1th lowest-order **bit** corresponds to argument 1. If the column is a grouping column the bit is 0 else is 1.
+Each `GROUPING_ID` argument must be an element of the `GROUP BY` list. `GROUPING_ID ()` returns an **integer** bitmap whose lowest N bits may be lit. A lit **bit** indicates the corresponding argument is not a grouping column for the given output row. The lowest-order **bit** corresponds to argument N, and the N-1th lowest-order **bit** corresponds to argument 1. If the column is a grouping column the bit is 1 else is 0.
 
 For example:
 
diff --git a/docs/zh-CN/developer/design/grouping_sets_design.md b/docs/zh-CN/developer/design/grouping_sets_design.md
index 0c19094cff..3fb5134b2f 100644
--- a/docs/zh-CN/developer/design/grouping_sets_design.md
+++ b/docs/zh-CN/developer/design/grouping_sets_design.md
@@ -136,7 +136,7 @@ GROUPING SETS (
 当我们没有统计某一列时，它的值显示为 NULL，这也可能是列本身就有 NULL 值，这就需要一种方法区分是没有统计还是值本来就是 NULL。为此引入 GROUPING 和 GROUPING_ID 函数。
 GROUPING(column:Column) 函数用于区分分组后的单个列是普通列和聚合列。如果是聚合列，则返回1，反之，则是0. GROUPING() 只能有一个参数列。
 
-GROUPING_ID(column1, column2) 则根据指定的column 顺序，否则根据聚合的时候给的集合的元素顺序，计算出一个列列表的 bitmap 值，一个列如果是聚合列为0，否则为1. GROUPING_ID()函数返回位向量的十进制值。
+GROUPING_ID(column1, column2) 则根据指定的column 顺序，否则根据聚合的时候给的集合的元素顺序，计算出一个列列表的 bitmap 值，一个列如果是聚合列为1，否则为0. GROUPING_ID()函数返回位向量的十进制值。
 比如 [0 1 0] ->2 从下列第三个查询可以看到这种对应关系
 
 例如，对于下面的表：


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org