Overview
Table 1 lists the aggregate functions supported by DLI.
| Function | Syntax | Value Type | Description |
|---|---|---|---|
| avg(col), avg(DISTINCT col) | DOUBLE | Returns the average value. | |
| corr(col1, col2) | DOUBLE | Returns the coefficient of correlation of a pair of numeric columns. | |
| count([distinct|all] <colname>) | BIGINT | Returns the number of records. | |
| covar_pop(col1, col2) | DOUBLE | Returns the covariance of a pair of numeric columns. | |
| covar_samp(col1, col2) | DOUBLE | Returns the sample covariance of a pair of numeric columns. | |
| max(col) | DOUBLE | Returns the maximum value. | |
| min(col) | DOUBLE | Returns the minimum value. | |
| percentile(BIGINT col, p) | DOUBLE | Returns the percentage value point of the value area. The value of p must be between 0 and 1. Otherwise, NULL is returned. The value cannot be a float. | |
| percentile_approx(DOUBLE col, p [, B]) | DOUBLE | Returns the approximate pth percentile of a numerical column within the group, including floating-point numbers. The value of p should be between 0 and 1. The parameter B controls the accuracy of the approximation, with a higher value of B resulting in a higher level of approximation. The default value is 10000. If the number of non-repeating values in the column is less than B, an exact percentile is returned. | |
| stddev_pop(col) | DOUBLE | Returns the deviation of a specified column. | |
| stddev_samp(col) | DOUBLE | Returns the sample deviation of a specified column. | |
| sum(col), sum(DISTINCT col) | DOUBLE | Returns the sum of the values in a column. | |
| variance(col), var_pop(col) | DOUBLE | Returns the variance of a column. | |
| var_samp(col) | DOUBLE | Returns the sample variance of a specified column. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
