HeatWave Release Notes
The following table shows supported aggregate functions. The VARLEN Support column identifies functions that support variable-length encoded string columns. See Section 2.7.1, “Encoding String Columns”.
Table 2.2 Aggregate (GROUP BY) Functions
Name | VARLEN Support | Description |
---|---|---|
AVG() |
Return the average value of the argument | |
COUNT() |
Yes | Return a count of the number of rows returned |
COUNT(DISTINCT) |
Return the count of a number of different values | |
GROUP_CONCAT() |
Return a concatenated string. Supported with variable-length
(VARLEN ) string columns. Limitations
apply. See
Section 2.16.3, “Functions and Operator Limitations”. |
|
MAX() |
Yes | Return the maximum value |
MIN() |
Yes | Return the minimum value |
STD() |
Return the population standard deviation | |
STDDEV() |
Return the population standard deviation | |
STDDEV_POP() |
Return the population standard deviation | |
STDDEV_SAMP() |
Return the sample standard deviation | |
SUM() |
Return the sum | |
VAR_POP() |
Return the population standard variance | |
VAR_SAMP() |
Return the sample variance | |
VARIANCE() |
Return the population standard variance |