Skip to content

Dirichlet functions in the Stochastic DuckDB extension

Function category

Dirichlet

5 functions

dist_dirichlet_log_pdf

Scalar function Dirichlet
Signature
dist_dirichlet_log_pdf(alpha: DOUBLE[], x: DOUBLE[]) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE[] Mode Positional Description
Argument x Type DOUBLE[] Mode Positional Description
Description
1 Example 1
SELECT dist_dirichlet_log_pdf([2.0, 3.0, 5.0], [0.2, 0.3, 0.5]);

Output

dist_dirichlet_log_pdf(list_value(2.0, 3.0, 5.0), list_value(0.2, 0.3, 0.5))
2.1406542258478236

dist_dirichlet_mean

Scalar function Dirichlet
Signature
dist_dirichlet_mean(alpha: DOUBLE[]) → DOUBLE[]
Arguments (Positional)
Argument alpha Type DOUBLE[] Mode Positional Description
Description
1 Component means of a Dirichlet
SELECT dist_dirichlet_mean([2.0, 3.0, 5.0]) AS mean;

Output

mean
[0.2, 0.3, 0.5]

dist_dirichlet_pdf

Scalar function Dirichlet
Signature
dist_dirichlet_pdf(alpha: DOUBLE[], x: DOUBLE[]) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE[] Mode Positional Description
Argument x Type DOUBLE[] Mode Positional Description
Description
1 Density at a point on the simplex
SELECT round(dist_dirichlet_pdf([2.0, 3.0, 5.0], [0.2, 0.3, 0.5]), 6) AS density;

Output

density
8.505

dist_dirichlet_sample

Scalar function Dirichlet
Signature
dist_dirichlet_sample(alpha: DOUBLE[]) → DOUBLE[]
Arguments (Positional)
Argument alpha Type DOUBLE[] Mode Positional Description
Description
1 A Dirichlet sample is a probability vector
SELECT len(s) AS components, round(list_sum(s), 12) AS total
FROM (SELECT dist_dirichlet_sample([2.0, 3.0, 5.0]) AS s);

Output

components total
3 1.0

dist_dirichlet_variance

Scalar function Dirichlet
Signature
dist_dirichlet_variance(alpha: DOUBLE[]) → DOUBLE[]
Arguments (Positional)
Argument alpha Type DOUBLE[] Mode Positional Description
Description
1 Example 1
SELECT dist_dirichlet_variance([2.0, 3.0, 5.0]);

Output

dist_dirichlet_variance(list_value(2.0, 3.0, 5.0))
[0.014545454545454549, 0.01909090909090909, 0.022727272727272728]