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 2025/12/15 07:35:23 UTC
(doris-website) branch master updated: GROUPING_ID not supported with ORDER BY in Nereids planner (#3163)
This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 3b4876f149a GROUPING_ID not supported with ORDER BY in Nereids planner (#3163)
3b4876f149a is described below
commit 3b4876f149a18f9d8aadc892582f07738b70ea12
Author: İsmail Tosun <is...@gmail.com>
AuthorDate: Mon Dec 15 10:35:18 2025 +0300
GROUPING_ID not supported with ORDER BY in Nereids planner (#3163)
GROUPING_ID is not supported with ORDER BY in the Nereids planner. Since
Nereids is used mostly in 3.x and fully in 4.x, the documentation should
be updated. The error message is: LOGICAL_SORT cannot contain
GroupingScalarFunction expression: Grouping_Id(department, level).
---
.../sql-functions/aggregate-functions/grouping-id.md | 14 +++++++-------
.../scalar-functions/other-functions/grouping-id.md | 14 +++++++-------
2 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/grouping-id.md b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/grouping-id.md
index 623f71503f1..309912911b5 100644
--- a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/grouping-id.md
+++ b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/grouping-id.md
@@ -41,7 +41,7 @@ SELECT
COUNT(uid) AS `Employee Count`
FROM employee
GROUP BY ROLLUP(department, level)
-ORDER BY GROUPING_ID(department, level) ASC;
+ORDER BY department desc;
```
*Expected Output:*
@@ -50,18 +50,18 @@ ORDER BY GROUPING_ID(department, level) ASC;
+--------------------+---------------------------+----------------+
| department | Job Title | Employee Count |
+--------------------+---------------------------+----------------+
-| Board of Directors | Senior | 2 |
| Technology | Senior | 3 |
-| Sales | Senior | 1 |
+| Technology | Total: Technology | 3 |
| Sales | Assistant | 2 |
+| Sales | Total: Sales | 4 |
| Sales | Trainee | 1 |
+| Sales | Senior | 1 |
| Marketing | Senior | 1 |
-| Marketing | Trainee | 2 |
| Marketing | Assistant | 1 |
-| Board of Directors | Total: Board of Directors | 2 |
-| Technology | Total: Technology | 3 |
-| Sales | Total: Sales | 4 |
| Marketing | Total: Marketing | 4 |
+| Marketing | Trainee | 2 |
+| Board of Directors | Senior | 2 |
+| Board of Directors | Total: Board of Directors | 2 |
| NULL | Total: Company | 13 |
+--------------------+---------------------------+----------------+
```
diff --git a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
index 623f71503f1..309912911b5 100644
--- a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
+++ b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
@@ -41,7 +41,7 @@ SELECT
COUNT(uid) AS `Employee Count`
FROM employee
GROUP BY ROLLUP(department, level)
-ORDER BY GROUPING_ID(department, level) ASC;
+ORDER BY department desc;
```
*Expected Output:*
@@ -50,18 +50,18 @@ ORDER BY GROUPING_ID(department, level) ASC;
+--------------------+---------------------------+----------------+
| department | Job Title | Employee Count |
+--------------------+---------------------------+----------------+
-| Board of Directors | Senior | 2 |
| Technology | Senior | 3 |
-| Sales | Senior | 1 |
+| Technology | Total: Technology | 3 |
| Sales | Assistant | 2 |
+| Sales | Total: Sales | 4 |
| Sales | Trainee | 1 |
+| Sales | Senior | 1 |
| Marketing | Senior | 1 |
-| Marketing | Trainee | 2 |
| Marketing | Assistant | 1 |
-| Board of Directors | Total: Board of Directors | 2 |
-| Technology | Total: Technology | 3 |
-| Sales | Total: Sales | 4 |
| Marketing | Total: Marketing | 4 |
+| Marketing | Trainee | 2 |
+| Board of Directors | Senior | 2 |
+| Board of Directors | Total: Board of Directors | 2 |
| NULL | Total: Company | 13 |
+--------------------+---------------------------+----------------+
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org