approx_count_distinct

Estimates the number of distinct non-NULL input values.

Syntax

approx_count_distinct( <expr> )

Returns

Returns int.

Examples

VALUES ('a'), ('b'), ('a'), ('c')
AGGREGATE approx_count_distinct($0);