abhishekagarwal87 commented on a change in pull request #10518:
URL: https://github.com/apache/druid/pull/10518#discussion_r538645430
##########
File path: docs/querying/sql.md
##########
@@ -99,7 +99,8 @@ total. Finally, GROUP BY CUBE computes a grouping set for
each combination of gr
`GROUP BY CUBE (country, city)` is equivalent to `GROUP BY GROUPING SETS (
(country, city), (country), (city), () )`.
Grouping columns that do not apply to a particular row will contain `NULL`.
For example, when computing
`GROUP BY GROUPING SETS ( (country, city), () )`, the grand total row
corresponding to `()` will have `NULL` for the
-"country" and "city" columns.
+"country" and "city" columns. Column may also be `NULL` if it was `NULL` in
the data itself. To differentiate such rows
+, you can use `GROUPING` aggregation.
Review comment:
Re-worked this a bit in https://github.com/apache/druid/pull/10654
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
