Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198.
Existing Python UDFs will continue to function until June 30, 2026. For more information, see the
blog post
HLLSKETCH type
Use the HLLSKETCH data type for HyperLogLog sketches. Amazon Redshift supports HyperLogLog sketch representations that are either sparse or dense. Sketches begin as sparse and switch to dense when the dense format is more efficient to minimize the memory footprint that is used.
Amazon Redshift automatically transitions a sparse HyperLogLog sketch when importing, exporting, or printing sketches in the following JSON format.
{"logm":15,"sparse":{"indices":[4878,9559,14523],"values":[1,2,1]}}
Amazon Redshift uses a string representation in a Base64 format to represent a dense HyperLogLog sketch.
Amazon Redshift uses the following string representation in a Base64 format to represent a dense HyperLogLog sketch.
"ABAABA..."
The maximum size of a HLLSKETCH object is 24,580 bytes when used in raw compression.
