deemoliu commented on PR #11346:
URL: https://github.com/apache/pinot/pull/11346#issuecomment-1716413409
Test Query
```
SELECT
DISTINCTCOUNTHLLPLUS(some_id, 12)
FROM
test_pinot_table
where
time_ms >= 1694380000000
time_ms <= 1694382000000
and filter1 > 0
AND filter2 = 0
AND filter3 > 0
AND filter4 != TRUE
```
Approximation Benchmarking result
<meta charset="utf-8"><b style="font-weight:normal;"
id="docs-internal-guid-23313897-7fff-1c06-89c2-ee4b9b9994a8"><p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;"><span
style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Result</span></p><div
dir="ltr" style="margin-left:0pt;" align="left">
| Query1 | Query2 | Query3
-- | -- | -- | --
Distinct Count | 144730 | 2797 | 204807
HLL (default log2m=8) | 158486 | 3138 | 191046
HLL log2m=9 | 155441 | 2850 | 209481
HLL log2m=10 | 148871 | 2797 | 204871
HLL++ default p=14 | 143821 | 2787 | 204371
hLL++ p=13 | 145069 | 2774 | 206735
HLL++ p=12 | 145329 | 2770 | 209274
HLL++ p=11 | 145251 | 2720 | 210161
HLL++ p=10 | 147969 | 2679 | 214758
HLL++ p=9 | 147234 | 2767 | 201620
HLL++ p=8 | 141377 | 2653 | 184344
</div></b>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
