3 ms·
SELECT COUNT(DISTINCT) has entered the challenge.
by hbarka 1y ago
SELECT COUNT(DISTINCT) has entered the challenge.
- philbe77 1y agogood point :) - we can re-aggregate HyperLogLog (HLL) sketches to get a pretty accurate NDV (Count Distinct) - see Query.farm's DataSketches DuckDB extension here: https://github.com/Query-farm/datasketches https://github.com/Query-farm/datasketches We also have Bitmap aggregation capabilities for exact count distinct - something I worked with Oracle, Snowflake, Databricks, and DuckDB labs on implementing. It isn't as fast as HLL - but it is 100% accurate...
- fifilura 1y agoI remember BigQuery had Distinct with HLL accuracy 10 years ago but rather quickly replaced it with actual accuracy. How would you compare this solution to BigQuery?
- deleted 1y ago[deleted]