v.19.16New Feature

Introduce Uniqcombined64() to Calculate Cardinality Greater Than Uint_max

Introduce uniqCombined64() to calculate cardinality greater than UINT_MAX. #7213, #7222 (Azat Khuzhin)
Introduces the uniqCombined64() aggregate function to calculate cardinalities exceeding the 32-bit unsigned integer limit (UINT_MAX), enabling accurate counting of very large sets.

Why it matters

The new uniqCombined64() function addresses the limitation of existing cardinality functions that overflow when the unique count exceeds UINT_MAX. This allows users to reliably measure distinct elements in massive datasets without losing accuracy due to integer overflow.

How to use it

Users can use the function by calling uniqCombined64(column_name) in aggregate queries where the cardinality might surpass UINT_MAX. It works similarly to other uniqCombined functions but returns a 64-bit result to handle larger counts.