Add comprehensive statistical distribution functions to DuckDB, enabling advanced statistical analysis, probability calculations, and random sampling directly within SQL queries.
Maintainer(s):
rustyconover
Installing and Loading
INSTALL stochastic FROM community;
LOAD stochastic;
About stochastic
For more information regarding usage, see the documentation.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| dist_bernoulli_cdf | scalar | NULL | NULL | NULL |
| dist_bernoulli_cdf_complement | scalar | NULL | NULL | NULL |
| dist_bernoulli_chf | scalar | NULL | NULL | NULL |
| dist_bernoulli_hazard | scalar | NULL | NULL | NULL |
| dist_bernoulli_kurtosis | scalar | NULL | NULL | NULL |
| dist_bernoulli_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_bernoulli_log_cdf | scalar | NULL | NULL | NULL |
| dist_bernoulli_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_bernoulli_log_pdf | scalar | NULL | NULL | NULL |
| dist_bernoulli_mean | scalar | NULL | NULL | NULL |
| dist_bernoulli_median | scalar | NULL | NULL | NULL |
| dist_bernoulli_mode | scalar | NULL | NULL | NULL |
| dist_bernoulli_pdf | scalar | NULL | NULL | NULL |
| dist_bernoulli_quantile | scalar | NULL | NULL | NULL |
| dist_bernoulli_quantile_complement | scalar | NULL | NULL | NULL |
| dist_bernoulli_range | scalar | NULL | NULL | NULL |
| dist_bernoulli_sample | scalar | NULL | NULL | NULL |
| dist_bernoulli_skewness | scalar | NULL | NULL | NULL |
| dist_bernoulli_stddev | scalar | NULL | NULL | NULL |
| dist_bernoulli_support | scalar | NULL | NULL | NULL |
| dist_bernoulli_variance | scalar | NULL | NULL | NULL |
| dist_beta_cdf | scalar | NULL | NULL | NULL |
| dist_beta_cdf_complement | scalar | NULL | NULL | NULL |
| dist_beta_chf | scalar | NULL | NULL | NULL |
| dist_beta_hazard | scalar | NULL | NULL | NULL |
| dist_beta_kurtosis | scalar | NULL | NULL | NULL |
| dist_beta_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_beta_log_cdf | scalar | NULL | NULL | NULL |
| dist_beta_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_beta_log_pdf | scalar | NULL | NULL | NULL |
| dist_beta_mean | scalar | NULL | NULL | NULL |
| dist_beta_median | scalar | NULL | NULL | NULL |
| dist_beta_mode | scalar | NULL | NULL | NULL |
| dist_beta_pdf | scalar | NULL | NULL | NULL |
| dist_beta_quantile | scalar | NULL | NULL | NULL |
| dist_beta_quantile_complement | scalar | NULL | NULL | NULL |
| dist_beta_range | scalar | NULL | NULL | NULL |
| dist_beta_sample | scalar | NULL | NULL | NULL |
| dist_beta_skewness | scalar | NULL | NULL | NULL |
| dist_beta_stddev | scalar | NULL | NULL | NULL |
| dist_beta_support | scalar | NULL | NULL | NULL |
| dist_beta_variance | scalar | NULL | NULL | NULL |
| dist_binomial_cdf | scalar | NULL | NULL | NULL |
| dist_binomial_cdf_complement | scalar | NULL | NULL | NULL |
| dist_binomial_chf | scalar | NULL | NULL | NULL |
| dist_binomial_hazard | scalar | NULL | NULL | NULL |
| dist_binomial_kurtosis | scalar | NULL | NULL | NULL |
| dist_binomial_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_binomial_log_cdf | scalar | NULL | NULL | NULL |
| dist_binomial_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_binomial_log_pdf | scalar | NULL | NULL | NULL |
| dist_binomial_median | scalar | NULL | NULL | NULL |
| dist_binomial_mode | scalar | NULL | NULL | NULL |
| dist_binomial_pdf | scalar | NULL | NULL | NULL |
| dist_binomial_quantile | scalar | NULL | NULL | NULL |
| dist_binomial_quantile_complement | scalar | NULL | NULL | NULL |
| dist_binomial_range | scalar | NULL | NULL | NULL |
| dist_binomial_sample | scalar | NULL | NULL | NULL |
| dist_binomial_skewness | scalar | NULL | NULL | NULL |
| dist_binomial_support | scalar | NULL | NULL | NULL |
| dist_binomial_variance | scalar | NULL | NULL | NULL |
| dist_chi_squared_cdf | scalar | NULL | NULL | NULL |
| dist_chi_squared_cdf_complement | scalar | NULL | NULL | NULL |
| dist_chi_squared_chf | scalar | NULL | NULL | NULL |
| dist_chi_squared_hazard | scalar | NULL | NULL | NULL |
| dist_chi_squared_kurtosis | scalar | NULL | NULL | NULL |
| dist_chi_squared_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_chi_squared_log_cdf | scalar | NULL | NULL | NULL |
| dist_chi_squared_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_chi_squared_log_pdf | scalar | NULL | NULL | NULL |
| dist_chi_squared_mean | scalar | NULL | NULL | NULL |
| dist_chi_squared_median | scalar | NULL | NULL | NULL |
| dist_chi_squared_mode | scalar | NULL | NULL | NULL |
| dist_chi_squared_pdf | scalar | NULL | NULL | NULL |
| dist_chi_squared_quantile | scalar | NULL | NULL | NULL |
| dist_chi_squared_quantile_complement | scalar | NULL | NULL | NULL |
| dist_chi_squared_range | scalar | NULL | NULL | NULL |
| dist_chi_squared_sample | scalar | NULL | NULL | NULL |
| dist_chi_squared_skewness | scalar | NULL | NULL | NULL |
| dist_chi_squared_stddev | scalar | NULL | NULL | NULL |
| dist_chi_squared_support | scalar | NULL | NULL | NULL |
| dist_chi_squared_variance | scalar | NULL | NULL | NULL |
| dist_exponential_cdf | scalar | NULL | NULL | NULL |
| dist_exponential_cdf_complement | scalar | NULL | NULL | NULL |
| dist_exponential_chf | scalar | NULL | NULL | NULL |
| dist_exponential_hazard | scalar | NULL | NULL | NULL |
| dist_exponential_kurtosis | scalar | NULL | NULL | NULL |
| dist_exponential_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_exponential_log_cdf | scalar | NULL | NULL | NULL |
| dist_exponential_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_exponential_log_pdf | scalar | NULL | NULL | NULL |
| dist_exponential_mean | scalar | NULL | NULL | NULL |
| dist_exponential_median | scalar | NULL | NULL | NULL |
| dist_exponential_mode | scalar | NULL | NULL | NULL |
| dist_exponential_pdf | scalar | NULL | NULL | NULL |
| dist_exponential_quantile | scalar | NULL | NULL | NULL |
| dist_exponential_quantile_complement | scalar | NULL | NULL | NULL |
| dist_exponential_range | scalar | NULL | NULL | NULL |
| dist_exponential_sample | scalar | NULL | NULL | NULL |
| dist_exponential_skewness | scalar | NULL | NULL | NULL |
| dist_exponential_stddev | scalar | NULL | NULL | NULL |
| dist_exponential_support | scalar | NULL | NULL | NULL |
| dist_exponential_variance | scalar | NULL | NULL | NULL |
| dist_extreme_value_cdf | scalar | NULL | NULL | NULL |
| dist_extreme_value_cdf_complement | scalar | NULL | NULL | NULL |
| dist_extreme_value_chf | scalar | NULL | NULL | NULL |
| dist_extreme_value_hazard | scalar | NULL | NULL | NULL |
| dist_extreme_value_kurtosis | scalar | NULL | NULL | NULL |
| dist_extreme_value_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_extreme_value_log_cdf | scalar | NULL | NULL | NULL |
| dist_extreme_value_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_extreme_value_log_pdf | scalar | NULL | NULL | NULL |
| dist_extreme_value_median | scalar | NULL | NULL | NULL |
| dist_extreme_value_mode | scalar | NULL | NULL | NULL |
| dist_extreme_value_pdf | scalar | NULL | NULL | NULL |
| dist_extreme_value_quantile | scalar | NULL | NULL | NULL |
| dist_extreme_value_quantile_complement | scalar | NULL | NULL | NULL |
| dist_extreme_value_range | scalar | NULL | NULL | NULL |
| dist_extreme_value_sample | scalar | NULL | NULL | NULL |
| dist_extreme_value_skewness | scalar | NULL | NULL | NULL |
| dist_extreme_value_support | scalar | NULL | NULL | NULL |
| dist_extreme_value_variance | scalar | NULL | NULL | NULL |
| dist_fisher_f_cdf | scalar | NULL | NULL | NULL |
| dist_fisher_f_cdf_complement | scalar | NULL | NULL | NULL |
| dist_fisher_f_chf | scalar | NULL | NULL | NULL |
| dist_fisher_f_hazard | scalar | NULL | NULL | NULL |
| dist_fisher_f_kurtosis | scalar | NULL | NULL | NULL |
| dist_fisher_f_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_fisher_f_log_cdf | scalar | NULL | NULL | NULL |
| dist_fisher_f_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_fisher_f_log_pdf | scalar | NULL | NULL | NULL |
| dist_fisher_f_median | scalar | NULL | NULL | NULL |
| dist_fisher_f_mode | scalar | NULL | NULL | NULL |
| dist_fisher_f_pdf | scalar | NULL | NULL | NULL |
| dist_fisher_f_quantile | scalar | NULL | NULL | NULL |
| dist_fisher_f_quantile_complement | scalar | NULL | NULL | NULL |
| dist_fisher_f_range | scalar | NULL | NULL | NULL |
| dist_fisher_f_sample | scalar | NULL | NULL | NULL |
| dist_fisher_f_skewness | scalar | NULL | NULL | NULL |
| dist_fisher_f_support | scalar | NULL | NULL | NULL |
| dist_fisher_f_variance | scalar | NULL | NULL | NULL |
| dist_gamma_cdf | scalar | NULL | NULL | NULL |
| dist_gamma_cdf_complement | scalar | NULL | NULL | NULL |
| dist_gamma_chf | scalar | NULL | NULL | NULL |
| dist_gamma_hazard | scalar | NULL | NULL | NULL |
| dist_gamma_kurtosis | scalar | NULL | NULL | NULL |
| dist_gamma_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_gamma_log_cdf | scalar | NULL | NULL | NULL |
| dist_gamma_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_gamma_log_pdf | scalar | NULL | NULL | NULL |
| dist_gamma_mean | scalar | NULL | NULL | NULL |
| dist_gamma_median | scalar | NULL | NULL | NULL |
| dist_gamma_mode | scalar | NULL | NULL | NULL |
| dist_gamma_pdf | scalar | NULL | NULL | NULL |
| dist_gamma_quantile | scalar | NULL | NULL | NULL |
| dist_gamma_quantile_complement | scalar | NULL | NULL | NULL |
| dist_gamma_range | scalar | NULL | NULL | NULL |
| dist_gamma_sample | scalar | NULL | NULL | NULL |
| dist_gamma_skewness | scalar | NULL | NULL | NULL |
| dist_gamma_stddev | scalar | NULL | NULL | NULL |
| dist_gamma_support | scalar | NULL | NULL | NULL |
| dist_gamma_variance | scalar | NULL | NULL | NULL |
| dist_geometric_cdf | scalar | NULL | NULL | NULL |
| dist_geometric_cdf_complement | scalar | NULL | NULL | NULL |
| dist_geometric_chf | scalar | NULL | NULL | NULL |
| dist_geometric_hazard | scalar | NULL | NULL | NULL |
| dist_geometric_kurtosis | scalar | NULL | NULL | NULL |
| dist_geometric_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_geometric_log_cdf | scalar | NULL | NULL | NULL |
| dist_geometric_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_geometric_log_pdf | scalar | NULL | NULL | NULL |
| dist_geometric_mean | scalar | NULL | NULL | NULL |
| dist_geometric_median | scalar | NULL | NULL | NULL |
| dist_geometric_mode | scalar | NULL | NULL | NULL |
| dist_geometric_pdf | scalar | NULL | NULL | NULL |
| dist_geometric_quantile | scalar | NULL | NULL | NULL |
| dist_geometric_quantile_complement | scalar | NULL | NULL | NULL |
| dist_geometric_range | scalar | NULL | NULL | NULL |
| dist_geometric_sample | scalar | NULL | NULL | NULL |
| dist_geometric_skewness | scalar | NULL | NULL | NULL |
| dist_geometric_stddev | scalar | NULL | NULL | NULL |
| dist_geometric_support | scalar | NULL | NULL | NULL |
| dist_geometric_variance | scalar | NULL | NULL | NULL |
| dist_laplace_cdf | scalar | NULL | NULL | NULL |
| dist_laplace_cdf_complement | scalar | NULL | NULL | NULL |
| dist_laplace_chf | scalar | NULL | NULL | NULL |
| dist_laplace_hazard | scalar | NULL | NULL | NULL |
| dist_laplace_kurtosis | scalar | NULL | NULL | NULL |
| dist_laplace_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_laplace_log_cdf | scalar | NULL | NULL | NULL |
| dist_laplace_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_laplace_log_pdf | scalar | NULL | NULL | NULL |
| dist_laplace_mean | scalar | NULL | NULL | NULL |
| dist_laplace_median | scalar | NULL | NULL | NULL |
| dist_laplace_mode | scalar | NULL | NULL | NULL |
| dist_laplace_pdf | scalar | NULL | NULL | NULL |
| dist_laplace_quantile | scalar | NULL | NULL | NULL |
| dist_laplace_quantile_complement | scalar | NULL | NULL | NULL |
| dist_laplace_range | scalar | NULL | NULL | NULL |
| dist_laplace_sample | scalar | NULL | NULL | NULL |
| dist_laplace_skewness | scalar | NULL | NULL | NULL |
| dist_laplace_stddev | scalar | NULL | NULL | NULL |
| dist_laplace_support | scalar | NULL | NULL | NULL |
| dist_laplace_variance | scalar | NULL | NULL | NULL |
| dist_logistic_cdf | scalar | NULL | NULL | NULL |
| dist_logistic_cdf_complement | scalar | NULL | NULL | NULL |
| dist_logistic_chf | scalar | NULL | NULL | NULL |
| dist_logistic_hazard | scalar | NULL | NULL | NULL |
| dist_logistic_kurtosis | scalar | NULL | NULL | NULL |
| dist_logistic_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_logistic_log_cdf | scalar | NULL | NULL | NULL |
| dist_logistic_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_logistic_log_pdf | scalar | NULL | NULL | NULL |
| dist_logistic_median | scalar | NULL | NULL | NULL |
| dist_logistic_mode | scalar | NULL | NULL | NULL |
| dist_logistic_pdf | scalar | NULL | NULL | NULL |
| dist_logistic_quantile | scalar | NULL | NULL | NULL |
| dist_logistic_quantile_complement | scalar | NULL | NULL | NULL |
| dist_logistic_range | scalar | NULL | NULL | NULL |
| dist_logistic_skewness | scalar | NULL | NULL | NULL |
| dist_logistic_support | scalar | NULL | NULL | NULL |
| dist_logistic_variance | scalar | NULL | NULL | NULL |
| dist_lognormal_cdf | scalar | NULL | NULL | NULL |
| dist_lognormal_cdf_complement | scalar | NULL | NULL | NULL |
| dist_lognormal_chf | scalar | NULL | NULL | NULL |
| dist_lognormal_hazard | scalar | NULL | NULL | NULL |
| dist_lognormal_kurtosis | scalar | NULL | NULL | NULL |
| dist_lognormal_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_lognormal_log_cdf | scalar | NULL | NULL | NULL |
| dist_lognormal_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_lognormal_log_pdf | scalar | NULL | NULL | NULL |
| dist_lognormal_mean | scalar | NULL | NULL | NULL |
| dist_lognormal_median | scalar | NULL | NULL | NULL |
| dist_lognormal_mode | scalar | NULL | NULL | NULL |
| dist_lognormal_pdf | scalar | NULL | NULL | NULL |
| dist_lognormal_quantile | scalar | NULL | NULL | NULL |
| dist_lognormal_quantile_complement | scalar | NULL | NULL | NULL |
| dist_lognormal_range | scalar | NULL | NULL | NULL |
| dist_lognormal_sample | scalar | NULL | NULL | NULL |
| dist_lognormal_skewness | scalar | NULL | NULL | NULL |
| dist_lognormal_stddev | scalar | NULL | NULL | NULL |
| dist_lognormal_support | scalar | NULL | NULL | NULL |
| dist_lognormal_variance | scalar | NULL | NULL | NULL |
| dist_negative_binomial_cdf | scalar | NULL | NULL | NULL |
| dist_negative_binomial_cdf_complement | scalar | NULL | NULL | NULL |
| dist_negative_binomial_chf | scalar | NULL | NULL | NULL |
| dist_negative_binomial_hazard | scalar | NULL | NULL | NULL |
| dist_negative_binomial_kurtosis | scalar | NULL | NULL | NULL |
| dist_negative_binomial_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_negative_binomial_log_cdf | scalar | NULL | NULL | NULL |
| dist_negative_binomial_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_negative_binomial_log_pdf | scalar | NULL | NULL | NULL |
| dist_negative_binomial_median | scalar | NULL | NULL | NULL |
| dist_negative_binomial_mode | scalar | NULL | NULL | NULL |
| dist_negative_binomial_pdf | scalar | NULL | NULL | NULL |
| dist_negative_binomial_quantile | scalar | NULL | NULL | NULL |
| dist_negative_binomial_quantile_complement | scalar | NULL | NULL | NULL |
| dist_negative_binomial_range | scalar | NULL | NULL | NULL |
| dist_negative_binomial_sample | scalar | NULL | NULL | NULL |
| dist_negative_binomial_skewness | scalar | NULL | NULL | NULL |
| dist_negative_binomial_support | scalar | NULL | NULL | NULL |
| dist_negative_binomial_variance | scalar | NULL | NULL | NULL |
| dist_normal_cdf | scalar | NULL | NULL | NULL |
| dist_normal_cdf_complement | scalar | NULL | NULL | NULL |
| dist_normal_chf | scalar | NULL | NULL | NULL |
| dist_normal_hazard | scalar | NULL | NULL | NULL |
| dist_normal_kurtosis | scalar | NULL | NULL | NULL |
| dist_normal_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_normal_log_cdf | scalar | NULL | NULL | NULL |
| dist_normal_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_normal_log_pdf | scalar | NULL | NULL | NULL |
| dist_normal_mean | scalar | NULL | NULL | NULL |
| dist_normal_median | scalar | NULL | NULL | NULL |
| dist_normal_mode | scalar | NULL | NULL | NULL |
| dist_normal_pdf | scalar | NULL | NULL | NULL |
| dist_normal_quantile | scalar | NULL | NULL | NULL |
| dist_normal_quantile_complement | scalar | NULL | NULL | NULL |
| dist_normal_range | scalar | NULL | NULL | NULL |
| dist_normal_sample | scalar | NULL | NULL | NULL |
| dist_normal_skewness | scalar | NULL | NULL | NULL |
| dist_normal_stddev | scalar | NULL | NULL | NULL |
| dist_normal_support | scalar | NULL | NULL | NULL |
| dist_normal_variance | scalar | NULL | NULL | NULL |
| dist_pareto_cdf | scalar | NULL | NULL | NULL |
| dist_pareto_cdf_complement | scalar | NULL | NULL | NULL |
| dist_pareto_chf | scalar | NULL | NULL | NULL |
| dist_pareto_hazard | scalar | NULL | NULL | NULL |
| dist_pareto_kurtosis | scalar | NULL | NULL | NULL |
| dist_pareto_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_pareto_log_cdf | scalar | NULL | NULL | NULL |
| dist_pareto_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_pareto_log_pdf | scalar | NULL | NULL | NULL |
| dist_pareto_mean | scalar | NULL | NULL | NULL |
| dist_pareto_median | scalar | NULL | NULL | NULL |
| dist_pareto_mode | scalar | NULL | NULL | NULL |
| dist_pareto_pdf | scalar | NULL | NULL | NULL |
| dist_pareto_quantile | scalar | NULL | NULL | NULL |
| dist_pareto_quantile_complement | scalar | NULL | NULL | NULL |
| dist_pareto_range | scalar | NULL | NULL | NULL |
| dist_pareto_skewness | scalar | NULL | NULL | NULL |
| dist_pareto_stddev | scalar | NULL | NULL | NULL |
| dist_pareto_support | scalar | NULL | NULL | NULL |
| dist_pareto_variance | scalar | NULL | NULL | NULL |
| dist_poisson_cdf | scalar | NULL | NULL | NULL |
| dist_poisson_cdf_complement | scalar | NULL | NULL | NULL |
| dist_poisson_chf | scalar | NULL | NULL | NULL |
| dist_poisson_hazard | scalar | NULL | NULL | NULL |
| dist_poisson_kurtosis | scalar | NULL | NULL | NULL |
| dist_poisson_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_poisson_log_cdf | scalar | NULL | NULL | NULL |
| dist_poisson_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_poisson_log_pdf | scalar | NULL | NULL | NULL |
| dist_poisson_mean | scalar | NULL | NULL | NULL |
| dist_poisson_median | scalar | NULL | NULL | NULL |
| dist_poisson_mode | scalar | NULL | NULL | NULL |
| dist_poisson_pdf | scalar | NULL | NULL | NULL |
| dist_poisson_quantile | scalar | NULL | NULL | NULL |
| dist_poisson_quantile_complement | scalar | NULL | NULL | NULL |
| dist_poisson_range | scalar | NULL | NULL | NULL |
| dist_poisson_sample | scalar | NULL | NULL | NULL |
| dist_poisson_skewness | scalar | NULL | NULL | NULL |
| dist_poisson_stddev | scalar | NULL | NULL | NULL |
| dist_poisson_support | scalar | NULL | NULL | NULL |
| dist_poisson_variance | scalar | NULL | NULL | NULL |
| dist_rayleigh_cdf | scalar | NULL | NULL | NULL |
| dist_rayleigh_cdf_complement | scalar | NULL | NULL | NULL |
| dist_rayleigh_chf | scalar | NULL | NULL | NULL |
| dist_rayleigh_hazard | scalar | NULL | NULL | NULL |
| dist_rayleigh_kurtosis | scalar | NULL | NULL | NULL |
| dist_rayleigh_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_rayleigh_log_cdf | scalar | NULL | NULL | NULL |
| dist_rayleigh_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_rayleigh_log_pdf | scalar | NULL | NULL | NULL |
| dist_rayleigh_mean | scalar | NULL | NULL | NULL |
| dist_rayleigh_median | scalar | NULL | NULL | NULL |
| dist_rayleigh_mode | scalar | NULL | NULL | NULL |
| dist_rayleigh_pdf | scalar | NULL | NULL | NULL |
| dist_rayleigh_quantile | scalar | NULL | NULL | NULL |
| dist_rayleigh_quantile_complement | scalar | NULL | NULL | NULL |
| dist_rayleigh_range | scalar | NULL | NULL | NULL |
| dist_rayleigh_skewness | scalar | NULL | NULL | NULL |
| dist_rayleigh_stddev | scalar | NULL | NULL | NULL |
| dist_rayleigh_support | scalar | NULL | NULL | NULL |
| dist_rayleigh_variance | scalar | NULL | NULL | NULL |
| dist_students_t_cdf | scalar | NULL | NULL | NULL |
| dist_students_t_cdf_complement | scalar | NULL | NULL | NULL |
| dist_students_t_chf | scalar | NULL | NULL | NULL |
| dist_students_t_hazard | scalar | NULL | NULL | NULL |
| dist_students_t_kurtosis | scalar | NULL | NULL | NULL |
| dist_students_t_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_students_t_log_cdf | scalar | NULL | NULL | NULL |
| dist_students_t_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_students_t_log_pdf | scalar | NULL | NULL | NULL |
| dist_students_t_mean | scalar | NULL | NULL | NULL |
| dist_students_t_median | scalar | NULL | NULL | NULL |
| dist_students_t_mode | scalar | NULL | NULL | NULL |
| dist_students_t_pdf | scalar | NULL | NULL | NULL |
| dist_students_t_quantile | scalar | NULL | NULL | NULL |
| dist_students_t_quantile_complement | scalar | NULL | NULL | NULL |
| dist_students_t_range | scalar | NULL | NULL | NULL |
| dist_students_t_sample | scalar | NULL | NULL | NULL |
| dist_students_t_skewness | scalar | NULL | NULL | NULL |
| dist_students_t_stddev | scalar | NULL | NULL | NULL |
| dist_students_t_support | scalar | NULL | NULL | NULL |
| dist_students_t_variance | scalar | NULL | NULL | NULL |
| dist_uniform_int_cdf | scalar | NULL | NULL | NULL |
| dist_uniform_int_cdf_complement | scalar | NULL | NULL | NULL |
| dist_uniform_int_chf | scalar | NULL | NULL | NULL |
| dist_uniform_int_hazard | scalar | NULL | NULL | NULL |
| dist_uniform_int_kurtosis | scalar | NULL | NULL | NULL |
| dist_uniform_int_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_uniform_int_log_cdf | scalar | NULL | NULL | NULL |
| dist_uniform_int_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_uniform_int_log_pdf | scalar | NULL | NULL | NULL |
| dist_uniform_int_mean | scalar | NULL | NULL | NULL |
| dist_uniform_int_median | scalar | NULL | NULL | NULL |
| dist_uniform_int_mode | scalar | NULL | NULL | NULL |
| dist_uniform_int_pdf | scalar | NULL | NULL | NULL |
| dist_uniform_int_quantile | scalar | NULL | NULL | NULL |
| dist_uniform_int_quantile_complement | scalar | NULL | NULL | NULL |
| dist_uniform_int_range | scalar | NULL | NULL | NULL |
| dist_uniform_int_sample | scalar | NULL | NULL | NULL |
| dist_uniform_int_skewness | scalar | NULL | NULL | NULL |
| dist_uniform_int_stddev | scalar | NULL | NULL | NULL |
| dist_uniform_int_support | scalar | NULL | NULL | NULL |
| dist_uniform_int_variance | scalar | NULL | NULL | NULL |
| dist_uniform_real_cdf | scalar | NULL | NULL | NULL |
| dist_uniform_real_cdf_complement | scalar | NULL | NULL | NULL |
| dist_uniform_real_chf | scalar | NULL | NULL | NULL |
| dist_uniform_real_hazard | scalar | NULL | NULL | NULL |
| dist_uniform_real_kurtosis | scalar | NULL | NULL | NULL |
| dist_uniform_real_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_uniform_real_log_cdf | scalar | NULL | NULL | NULL |
| dist_uniform_real_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_uniform_real_log_pdf | scalar | NULL | NULL | NULL |
| dist_uniform_real_mean | scalar | NULL | NULL | NULL |
| dist_uniform_real_median | scalar | NULL | NULL | NULL |
| dist_uniform_real_mode | scalar | NULL | NULL | NULL |
| dist_uniform_real_pdf | scalar | NULL | NULL | NULL |
| dist_uniform_real_quantile | scalar | NULL | NULL | NULL |
| dist_uniform_real_quantile_complement | scalar | NULL | NULL | NULL |
| dist_uniform_real_range | scalar | NULL | NULL | NULL |
| dist_uniform_real_sample | scalar | NULL | NULL | NULL |
| dist_uniform_real_skewness | scalar | NULL | NULL | NULL |
| dist_uniform_real_stddev | scalar | NULL | NULL | NULL |
| dist_uniform_real_support | scalar | NULL | NULL | NULL |
| dist_uniform_real_variance | scalar | NULL | NULL | NULL |
| dist_weibull_cdf | scalar | NULL | NULL | NULL |
| dist_weibull_cdf_complement | scalar | NULL | NULL | NULL |
| dist_weibull_chf | scalar | NULL | NULL | NULL |
| dist_weibull_hazard | scalar | NULL | NULL | NULL |
| dist_weibull_kurtosis | scalar | NULL | NULL | NULL |
| dist_weibull_kurtosis_excess | scalar | NULL | NULL | NULL |
| dist_weibull_log_cdf | scalar | NULL | NULL | NULL |
| dist_weibull_log_cdf_complement | scalar | NULL | NULL | NULL |
| dist_weibull_log_pdf | scalar | NULL | NULL | NULL |
| dist_weibull_median | scalar | NULL | NULL | NULL |
| dist_weibull_mode | scalar | NULL | NULL | NULL |
| dist_weibull_pdf | scalar | NULL | NULL | NULL |
| dist_weibull_quantile | scalar | NULL | NULL | NULL |
| dist_weibull_quantile_complement | scalar | NULL | NULL | NULL |
| dist_weibull_range | scalar | NULL | NULL | NULL |
| dist_weibull_sample | scalar | NULL | NULL | NULL |
| dist_weibull_skewness | scalar | NULL | NULL | NULL |
| dist_weibull_support | scalar | NULL | NULL | NULL |
| dist_weibull_variance | scalar | NULL | NULL | NULL |
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| auto_fallback_to_full_download | Allows automatically falling back to full file downloads when possible. | BOOLEAN | GLOBAL | [] |
| ca_cert_file | Path to a custom certificate file for self-signed certificates. | VARCHAR | GLOBAL | [] |
| enable_curl_server_cert_verification | Enable server side certificate verification for CURL backend. | BOOLEAN | GLOBAL | [] |
| enable_server_cert_verification | Enable server side certificate verification. | BOOLEAN | GLOBAL | [] |
| force_download | Forces upfront download of file | BOOLEAN | GLOBAL | [] |
| hf_max_per_page | Debug option to limit number of items returned in list requests | UBIGINT | GLOBAL | [] |
| http_keep_alive | Keep alive connections. Setting this to false can help when running into connection failures | BOOLEAN | GLOBAL | [] |
| http_retries | HTTP retries on I/O error | UBIGINT | GLOBAL | [] |
| http_retry_backoff | Backoff factor for exponentially increasing retry wait time | FLOAT | GLOBAL | [] |
| http_retry_wait_ms | Time between retries | UBIGINT | GLOBAL | [] |
| http_timeout | HTTP timeout read/write/connection/retry (in seconds) | UBIGINT | GLOBAL | [] |
| httpfs_client_implementation | Select which is the HTTPUtil implementation to be used | VARCHAR | GLOBAL | [] |
| s3_access_key_id | S3 Access Key ID | VARCHAR | GLOBAL | [] |
| s3_endpoint | S3 Endpoint | VARCHAR | GLOBAL | [] |
| s3_kms_key_id | S3 KMS Key ID | VARCHAR | GLOBAL | [] |
| s3_region | S3 Region | VARCHAR | GLOBAL | [] |
| s3_requester_pays | S3 use requester pays mode | BOOLEAN | GLOBAL | [] |
| s3_secret_access_key | S3 Access Key | VARCHAR | GLOBAL | [] |
| s3_session_token | S3 Session Token | VARCHAR | GLOBAL | [] |
| s3_uploader_max_filesize | S3 Uploader max filesize (between 50GB and 5TB) | VARCHAR | GLOBAL | [] |
| s3_uploader_max_parts_per_file | S3 Uploader max parts per file (between 1 and 10000) | UBIGINT | GLOBAL | [] |
| s3_uploader_thread_limit | S3 Uploader global thread limit | UBIGINT | GLOBAL | [] |
| s3_url_compatibility_mode | Disable Globs and Query Parameters on S3 URLs | BOOLEAN | GLOBAL | [] |
| s3_url_style | S3 URL style | VARCHAR | GLOBAL | [] |
| s3_use_ssl | S3 use SSL | BOOLEAN | GLOBAL | [] |
| unsafe_disable_etag_checks | Disable checks on ETag consistency | BOOLEAN | GLOBAL | [] |