Skip to content

functions_aggregate_decimal_output.yaml

This document file is generated for functions_aggregate_decimal_output.yaml

Aggregate Functions

count

Implementations:
count(x, option:overflow): -> return_type
0. count(any, option:overflow): -> decimal<38,0>

Count a set of values. Result is returned as a decimal instead of i64.

Options:
  • overflow ['SILENT', 'SATURATE', 'ERROR']
  • count

    Implementations:

    Count a set of records (not field referenced). Result is returned as a decimal instead of i64.

    approx_count_distinct

    Implementations:
    approx_count_distinct(x): -> return_type
    0. approx_count_distinct(any): -> decimal<38,0>

    Calculates the approximate number of rows that contain distinct values of the expression argument using HyperLogLog. This function provides an alternative to the COUNT (DISTINCT expression) function, which returns the exact number of rows that contain distinct values of an expression. APPROX_COUNT_DISTINCT processes large amounts of data significantly faster than COUNT, with negligible deviation from the exact result. Result is returned as a decimal instead of i64.