starrocks
starrocks copied to clipboard
[function] inverse_normal_cdf and normal_cd
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.
can I pick it, @wangsimo0
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
hey @wangsimo0 @kateshaowanjou @241600489 Can I pick this issue please ?
hey @wangsimo0 @kateshaowanjou @241600489 Can I pick this issue please ? Awesome! Thanks for being interested in working on this issue. Since I can't reach @241600489 and it's been a while since we last saw him I assume he's no longer interested. I adjusted the assignee so you can work on it now! Please feel free to let us know if you have any questions you want to discuss. Thanks!