Sketches

Amazon Redshift Approximate Query API

Amazon Redshift supports approximate query processing using HyperLogLog sketch functions (HLL_CREATE_SKETCH, HLL_COMBINE, HLL_CARDINALITY) for fast cardinality estimation on large datasets. These native SQL functions enable analytics teams to run near-instantaneous approximate COUNT DISTINCT queries on billions of rows with controlled error bounds.

GitHub

Documentation

📖
Documentation
https://docs.aws.amazon.com/redshift/latest/dg/r_HLL_function.html

API entry from apis.yml

apis.yml Raw ↑ 
aid: sketches:amazon-redshift-sketches-api
name: Amazon Redshift Approximate Query API
description: Amazon Redshift supports approximate query processing using HyperLogLog sketch functions
  (HLL_CREATE_SKETCH, HLL_COMBINE, HLL_CARDINALITY) for fast cardinality estimation on large datasets.
  These native SQL functions enable analytics teams to run near-instantaneous approximate COUNT DISTINCT
  queries on billions of rows with controlled error bounds.
humanURL: https://docs.aws.amazon.com/redshift/latest/dg/r_HLL_function.html
baseURL: https://aws.amazon.com
tags:
- AWS
- Redshift
- Analytics
- HyperLogLog
- SQL
properties:
- url: https://docs.aws.amazon.com/redshift/latest/dg/r_HLL_function.html
  type: Documentation