This is an automated email from the ASF dual-hosted git repository.
karan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new a929b9f16e4 clafiry DISTINCT is optional for COUNT() (#15394)
a929b9f16e4 is described below
commit a929b9f16e42b88cb1869f2cb9a04814edcefdd5
Author: Charles Smith <[email protected]>
AuthorDate: Tue Nov 28 03:22:16 2023 -0800
clafiry DISTINCT is optional for COUNT() (#15394)
---
docs/querying/sql-aggregations.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/docs/querying/sql-aggregations.md
b/docs/querying/sql-aggregations.md
index b6a6748e624..d005ce1fd11 100644
--- a/docs/querying/sql-aggregations.md
+++ b/docs/querying/sql-aggregations.md
@@ -70,7 +70,7 @@ In the aggregation functions supported by Druid, only
`COUNT`, `ARRAY_AGG`, and
|Function|Notes|Default|
|--------|-----|-------|
|`COUNT(*)`|Counts the number of rows.|`0`|
-|`COUNT(DISTINCT expr)`|Counts distinct values of `expr`.<br /><br />When
`useApproximateCountDistinct` is set to "true" (the default), this is an alias
for `APPROX_COUNT_DISTINCT`. The specific algorithm depends on the value of
[`druid.sql.approxCountDistinct.function`](../configuration/index.md#sql). In
this mode, you can use strings, numbers, or prebuilt sketches. If counting
prebuilt sketches, the prebuilt sketch type must match the selected
algorithm.<br /><br />When `useApproximate [...]
+|`COUNT([DISTINCT] expr)`|Counts the values of `expr`.<br /><br />By default,
using DISTINCT serves as an alias for `APPROX_COUNT_DISTINCT`
(`useApproximateCountDistinct=true`). The specific algorithm depends on the
value of
[`druid.sql.approxCountDistinct.function`](../configuration/index.md#sql). In
this mode, you can use strings, numbers, or prebuilt sketches. If counting
prebuilt sketches, the prebuilt sketch type must match the selected
algorithm.<br /><br />When `useApproximateCoun [...]
|`SUM(expr)`|Sums numbers.|`null` or `0` if
`druid.generic.useDefaultValueForNull=true` (legacy mode)|
|`MIN(expr)`|Takes the minimum of numbers.|`null` or `9223372036854775807`
(maximum LONG value) if `druid.generic.useDefaultValueForNull=true` (legacy
mode)|
|`MAX(expr)`|Takes the maximum of numbers.|`null` or `-9223372036854775808`
(minimum LONG value) if `druid.generic.useDefaultValueForNull=true` (legacy
mode)|
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
