AppliedAIPrep logoAppliedAI/Prep
← SQL & Data Engineering / 28
mediumSnowflakeGoogleMeta

How do you count distinct values at scale (HyperLogLog and approximate aggregation)?

Exact COUNT(DISTINCT) over billions of rows tracks every unique value, so it gets slow and expensive. The signal is knowing when a sketch like HyperLogLog buys huge memory and speed wins for a sub-percent error budget.

Updated Aug 2026 · Grounded in real Applied AI Engineer interview loops and written to a senior-engineer editorial bar.

Exact COUNT(DISTINCT) over billions of rows tracks every unique value, so it gets slow and expensive. The signal is knowing when a sketch like HyperLogLog buys huge memory and speed wins for a sub-percent error budget.

Unlock the other 750 answers · ₹2,000 / $25Your progress and mastery stay saved · 6 months · one payment · no auto-renew
UP NEXT ON YOUR JOURNEY
Next in this trackWhat is a LATERAL join (CROSS APPLY), and when do you need it?Next in this trackHow do you query semi-structured data (JSON) in SQL, and when should you flatten vs keep it nested?Next in this trackWhat is the QUALIFY clause, and how does it simplify filtering on window functions?
DISCUSSION · 0

No comments yet — be the first to share your approach.