跳到主要内容

连续采样

每个采样器返回长度为 k 的 LIST(DOUBLE)。k 是 BIGINT(正的整数量)。随机输出没有固定的 点值,示例只给出一次抽样。参数与对应分布函数签名里除求值点 x 以外的部分一致。

sr_sample_normal(mean, std_dev, k)​

签名:sr_sample_normal(mean DOUBLE, std_dev DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_normal(0.0, 1.0, 10)

sr_sample_log_normal(location, scale, k)​

签名:sr_sample_log_normal(location DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_log_normal(0.0, 1.0, 10)

sr_sample_gamma(shape, rate, k)​

签名:sr_sample_gamma(shape DOUBLE, rate DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_gamma(2.0, 2.0, 10)

sr_sample_inverse_gamma(shape, scale, k)​

签名:sr_sample_inverse_gamma(shape DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_inverse_gamma(2.0, 2.0, 10)

sr_sample_chi_squared(freedom, k)​

签名:sr_sample_chi_squared(freedom DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_chi_squared(2.0, 10)

sr_sample_chi(freedom, k)​

签名:sr_sample_chi(freedom UBIGINT, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_chi(2, 10)

sr_sample_erlang(shape, rate, k)​

签名:sr_sample_erlang(shape UBIGINT, rate DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_erlang(2, 2.0, 10)

sr_sample_exp(rate, k)​

签名:sr_sample_exp(rate DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_exp(2.0, 5)

sr_sample_uniform(min, max, k)​

签名:sr_sample_uniform(min DOUBLE, max DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_uniform(2.0, 3.0, 5)

sr_sample_students_t(location, scale, freedom, k)​

签名:sr_sample_students_t(location DOUBLE, scale DOUBLE, freedom DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_students_t(0.0, 1.0, 2.0, 10)

sr_sample_fisher_snedecor(df_num, df_denom, k)​

签名:sr_sample_fisher_snedecor(df_num DOUBLE, df_denom DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_fisher_snedecor(2.0, 3.0, 10)

sr_sample_cauchy(location, scale, k)​

签名:sr_sample_cauchy(location DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_cauchy(0.0, 1.0, 10)

sr_sample_laplace(location, scale, k)​

签名:sr_sample_laplace(location DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_laplace(0.0, 1.0, 10)

sr_sample_gumbel(location, scale, k)​

签名:sr_sample_gumbel(location DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_gumbel(0.0, 1.0, 10)

sr_sample_levy(mu, c, k)​

签名:sr_sample_levy(mu DOUBLE, c DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_levy(0.0, 1.0, 10)

sr_sample_pareto(scale, shape, k)​

签名:sr_sample_pareto(scale DOUBLE, shape DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_pareto(1.0, 2.0, 10)

sr_sample_triangular(min, max, mode, k)​

签名:sr_sample_triangular(min DOUBLE, max DOUBLE, mode DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_triangular(0.0, 2.0, 1.0, 10)

sr_sample_weibull(shape, scale, k)​

签名:sr_sample_weibull(shape DOUBLE, scale DOUBLE, k BIGINT) -> LIST(DOUBLE)

SELECT sr_sample_weibull(1.0, 1.0, 10)

sr_sample_dirac(v, k)​

签名:sr_sample_dirac(v DOUBLE, k BIGINT) -> LIST(DOUBLE)

所有样本都是 v。

SELECT sr_sample_dirac(3.0, 2)
-- [3.0, 3.0]

错误​

k 必须是正的整数量:

SELECT sr_sample_normal(0.0, 1.0, 0)
-- error: sr_sample_normal: k must be a positive whole number, got 0