Skip to main content

​
Apache DataSketches functions

Apache DataSketches is a robust library that provides a collection of advanced algorithms for data analysis. These algorithms are designed to work efficiently with large datasets and provide accurate results for various data analysis tasks. The following functions are part of the Apache Datasketches library and can be used in SQL queries to perform advanced data analysis tasks.

​
Distinct Counting with HyperLogLog Sketches

HyperLogLog (HLL) Sketches are a highly efficient probabilistic data structure used for cardinality estimation, which means they can quickly and accurately count the number of distinct elements in large datasets. The following functions are used to work with HLL sketches in SQL queries: APACHE_DATASKETCHES_HLL_BUILD, APACHE_DATASKETCHES_HLL_MERGE, APACHE_DATASKETCHES_HLL_ESTIMATE.