Setdigest Functions

​

hash_counts

Returns a map containing the Murmur3Hash128 hashed values and the count of their occurences within the internal MinHash structure belonging to x.

Supported Signatures

function hash_counts(setdigest) returns map<bigint, smallint>

🔗 Official Documentation

​

intersection_cardinality

Returns the estimation for the cardinality of the intersection of the two set digests.

Supported Signatures

function intersection_cardinality(setdigest, setdigest) returns bigint

🔗 Official Documentation

​

jaccard_index

Returns the estimation of Jaccard index for the two set digests.

Supported Signatures

function jaccard_index(setdigest, setdigest) returns double

🔗 Official Documentation

​

make_set_digest

Composes all input values of x into a setdigest.

Supported Signatures

function make_set_digest($1) returns setdigest

🔗 Official Documentation

​

merge_set_digest

Returns the setdigest of the aggregate union of the individual setdigest Set Digest structures.

Supported Signatures

function merge_set_digest(setdigest) returns setdigest

🔗 Official Documentation