goldmedal commented on code in PR #12273: URL: https://github.com/apache/datafusion/pull/12273#discussion_r1739725326
########## datafusion/sqllogictest/test_files/aggregate.slt: ########## @@ -5863,3 +5863,47 @@ ORDER BY k; ---- 1 1.8125 6.8007813 Float16 Float16 2 8.5 8.5 Float16 Float16 + +# The result is 0.19432323191699075 actually +query R +SELECT kurtosis_pop(col) FROM VALUES (1), (10), (100), (10), (1) as tab(col); +---- +0.194323231917 + +# The result is -1.153061224489787 actually +query R +SELECT kurtosis_pop(col) FROM VALUES (1), (2), (3), (2), (1) as tab(col); +---- +-1.15306122449 Review Comment: This result is different from DuckDB but I'm not sure why. ``` D SELECT kurtosis_pop(col) FROM VALUES (1), (2), (3), (2), (1) as tab(col); ┌────────────────────┐ │ kurtosis_pop(col) │ │ double │ ├────────────────────┤ │ -1.153061224489769 │ └────────────────────┘ ``` -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
