Hyperloglog Functions

`approx_set`

Returns the HyperLogLog sketch of the input data set of x. This data sketch underlies approx_distinct() and can be stored and used later by calling cardinality(). Supported Signatures

function approx_set(bigint) returns hyperloglog
function approx_set(double) returns hyperloglog
function approx_set(varchar) returns hyperloglog

🔗 Official Documentation

`empty_approx_set`

Returns an empty HyperLogLog. Supported Signatures

function empty_approx_set() returns hyperloglog

🔗 Official Documentation

`merge`

Returns the HyperLogLog of the aggregate union of the individual hll HyperLogLog structures. Supported Signatures

function merge(hyperloglog) returns hyperloglog
function merge(qdigest) returns qdigest
function merge(tdigest) returns tdigest

🔗 Official Documentation

Geospatial Functions Json Functions

Reference

SQL Functions

Hyperloglog Functions

`approx_set`

`empty_approx_set`

`merge`

​approx_set

​empty_approx_set

​merge

`approx_set`

`empty_approx_set`

`merge`