StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.3k stars 1.68k forks source link

[function] inverse_normal_cdf and normal_cd #38989

Open wangsimo0 opened 5 months ago

wangsimo0 commented 5 months ago

in trino's compatibility issues, we need the following functions.

https://trino.io/docs/current/functions/math.html?highlight=normal_cdf#normal_cdf

inverse_normal_cdf(mean, sd, p) → double# Compute the inverse of the Normal cdf with given mean and standard deviation (sd) for the cumulative probability (p): P(N < n). The mean must be a real value and the standard deviation must be a real and positive value. The probability p must lie on the interval (0, 1).

normal_cdf(mean, sd, v) → double# Compute the Normal cdf with given mean and standard deviation (sd): P(N < v; mean, sd). The mean and value v must be real values and the standard deviation must be a real and positive value.

241600489 commented 4 months ago

can I pick it, @wangsimo0

kateshaowanjou commented 4 months ago

can I pick it, @wangsimo0 @241600489 You can join this wechat group if you need any help: https://wx.focussend.com/weComLink/mobileQrCodeLink/33412/de60d