This message was deleted.

Hi @Hogan Chu please have a look at the relative error rate for theta sketches here: https://datasketches.apache.org/docs/Theta/ThetaErrorTable.html. As you can see, depending on the specified k value, the error rate varies. This link also has more information on accuracy: https://datasketches.apache.org/docs/Theta/ThetaAccuracy.html.

okay i would try and post here result

Great thank you 🙂

Ahh want to try decrease error rate but 1% ~2% is maximum... Result range can be 1million ~ 2million so this percent is not affordable

@추호관 The default size for theta sketch is

16384

that has a relative error rate of

2.344%

for

99.73%

data. As can be seen in this document: https://datasketches.apache.org/docs/Theta/ThetaErrorTable.html if you increase the size to for example

1048576

the relative error rate of

99.73%

will go down to

0.293%

solved the issue thanks @Saydul Bashar

You are welcome @Hogan Chu :)