APPROX_COUNT_DISTINCT
Returns an approximate count of distinct values using HyperLogLog.
Analyze Syntax
func.approx_count_distinct(get_column(table, 'user_id'))
Analyze Examples
func.approx_count_distinct(get_column(table, 'user_id'))
┌─────┐
│ 985 │
└─────┘
SQL Syntax
APPROX_COUNT_DISTINCT(<user_id>)
SQL Examples
SELECT APPROX_COUNT_DISTINCT(user_id) FROM page_views;
┌─────┐
│ 985 │
└─────┘