# APPROX\_COUNT\_DISTINCT\_ACCUMULATE

For a collection of values, it creates a new [HyperLogLog](http://en.wikipedia.org/wiki/HyperLogLog) state and returns a value representing the new state.

## Syntax

```
APPROX_COUNT_DISTINCT_ACCUMULATE ( expr )

```

## Arguments

**expr**

An expression evaluating to a scalar value.

`expr` is typically the name of a column. In this case, `APPROX_COUNT_DISTINCT_ACCUMULATE` uses values in the column to create a new HyperLogLog state.

## Remarks

This function is used in conjunction with `APPROX_COUNT_DISTINCT_COMBINE` and `APPROX_COUNT_DISTINCT_ESTIMATE`. To best understand its usage, see the topic [Distinct Count Estimation Functions](https://docs.singlestore.com/db/v9.1/reference/sql-reference/distinct-count-estimation-functions.md).

***

Modified at: November 29, 2022

Source: [/db/v9.1/reference/sql-reference/distinct-count-estimation-functions/approx-count-distinct-accumulate/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/distinct-count-estimation-functions/approx-count-distinct-accumulate/)

(An index of the documentation is available at /llms.txt)