> For the complete documentation index, see [llms.txt](https://docs.e6data.com/product-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.e6data.com/product-documentation/sql-command-reference/cardinality-estimation-functions.md).

# Cardinality Estimation Functions

#### <mark style="color:purple;">APPROX\_COUNT\_DISTINCT()</mark>

Uses HyperLogLog to provide estimate of count distinct

```sql
approx_count_distinct(a)
approx_count_distinct(a) over(partition by b)
```

Limitation -&#x20;

* " \* " is not supported