Cardinality Estimation Functions

APPROX_COUNT_DISTINCT()

Uses HyperLogLog to provide estimate of count distinct

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

Limitation -

  • " * " is not supported

Last updated

#930: Cross account hive GCP

Change request updated