Skip to main content

​
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