On this page

    Aggregate

    Function NameDescription
    APPROX_COUNT_DISTINCTReturns the approximate number of rows that contain distinct values in a column. Ignores rows that contain a null value for the column.
    AVGComputes the average of a set of values.
    BIT_ANDReturns the bitwise AND of non-NULL input values.
    BIT_ORReturns the bitwise OR of non-NULL input values.
    CORRCalculates the Pearson correlation coefficient of the values expression1 and expression2. The function name must be enclosed in double quotes (“CORR”).
    COUNTReturns the total number of records for the specified expression.
    COVAR_POPReturns the population covariance for non-NULL pairs across all input values.
    COVAR_SAMPReturns the sample covariance for non-NULL pairs across all input values.
    HLLUses HyperLogLog to return an approximation of the distinct cardinality of the input.
    MAXReturns the maximum value among the non-NULL input expressions.
    MINReturns the minimum value among the non-NULL input expressions.
    NDVReturns an approximate distinct value number, similar to COUNT(DISTINCT col). NDV can return results faster than using the combination of COUNT and DISTINCT while using a constant amount of memory, resulting in less memory usage for columns with high cardinality.
    PIVOTConverts a set of data from rows into columns
    STDDEVReturns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
    STDDEV_POPReturns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
    STDDEV_SAMPReturns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
    SUMReturns the sum of non-NULL input expressions.
    UNPIVOTConverts a set of data from columns into rows
    VAR_POPReturns the population variance of non-NULL records.
    VAR_SAMPReturns the sample variance of non-NULL records.