SQL functions for GLM (Poisson) More...
Functions | |
bytea8 | __glm_merge_states (bytea8 state1, bytea8 state2) |
bytea8 | __glm_final (bytea8 state) |
bytea8 | __glm_poisson_log_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_poisson_log_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_poisson_identity_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_poisson_identity_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_poisson_sqrt_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_poisson_sqrt_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gaussian_identity_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gaussian_identity_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gaussian_log_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gaussian_log_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gaussian_inverse_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gaussian_inverse_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gamma_log_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gamma_log_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gamma_inverse_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gamma_inverse_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_gamma_identity_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_gamma_identity_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_binomial_probit_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_binomial_probit_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_inverse_gaussian_identity_transition (bytea8, float8, float8[], bytea8) |
bytea8 | __glm_binomial_logit_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_binomial_logit_agg (float8 y, float8[] x, bytea8 previous_state) |
__glm_result_type | __glm_result_z_stats (bytea8 state) |
aggregate bytea8 | __glm_inverse_gaussian_identity_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_inverse_gaussian_log_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_inverse_gaussian_log_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_inverse_gaussian_inverse_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_inverse_gaussian_inverse_agg (float8 y, float8[] x, bytea8 previous_state) |
bytea8 | __glm_inverse_gaussian_sqr_inverse_transition (bytea8, float8, float8[], bytea8) |
aggregate bytea8 | __glm_inverse_gaussian_sqr_inverse_agg (float8 y, float8[] x, bytea8 previous_state) |
__glm_result_type | __glm_result_t_stats (bytea8 state) |
float8 | __glm_loglik_diff (bytea8 state1, bytea8 state2) |
void | glm (varchar source_table, varchar model_table, varchar dependent_varname, varchar independent_varname, varchar family_params, varchar grouping_col, varchar optim_params, boolean verbose) |
void | glm (varchar source_table, varchar model_table, varchar dependent_varname, varchar independent_varname, varchar family_params, varchar grouping_col, varchar optim_params) |
void | glm (varchar source_table, varchar model_table, varchar dependent_varname, varchar independent_varname, varchar family_params, varchar grouping_col) |
void | glm (varchar source_table, varchar model_table, varchar dependent_varname, varchar independent_varname, varchar family_params) |
text | glm (text message) |
text | glm () |
float8 | glm_predict (float8[] coef, float8[] col_ind_var, text link) |
Predict the estimated mean value for the response variable given a specific predictor variable value in a generalized linear model. More... | |
boolean | glm_predict_binomial (float8[] coef, float8[] col_ind_var, text link) |
Predict the output category for the response variable given a specific predictor variable value in a generalized linear model. More... | |
float8 | glm_predict_poisson (float8[] coef, float8[] col_ind_var, text link) |
Predict the estimated count for the response variable given a specific predictor variable value in a generalized linear model. More... | |
text | glm_predict (text message) |
text | glm_predict () |
text | glm_predict_poisson (text message) |
text | glm_predict_binomial (text message) |
aggregate bytea8 __glm_binomial_logit_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_binomial_logit_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_binomial_probit_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_binomial_probit_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
bytea8 __glm_final | ( | bytea8 | state | ) |
aggregate bytea8 __glm_gamma_identity_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gamma_identity_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_gamma_inverse_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gamma_inverse_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_gamma_log_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gamma_log_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_gaussian_identity_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gaussian_identity_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_gaussian_inverse_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gaussian_inverse_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_gaussian_log_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_gaussian_log_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_inverse_gaussian_identity_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_inverse_gaussian_identity_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_inverse_gaussian_inverse_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_inverse_gaussian_inverse_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_inverse_gaussian_log_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_inverse_gaussian_log_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_inverse_gaussian_sqr_inverse_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_inverse_gaussian_sqr_inverse_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
float8 __glm_loglik_diff | ( | bytea8 | state1, |
bytea8 | state2 | ||
) |
bytea8 __glm_merge_states | ( | bytea8 | state1, |
bytea8 | state2 | ||
) |
aggregate bytea8 __glm_poisson_identity_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_poisson_identity_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_poisson_log_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_poisson_log_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
aggregate bytea8 __glm_poisson_sqrt_agg | ( | float8 | y, |
float8 [] | x, | ||
bytea8 | previous_state | ||
) |
bytea8 __glm_poisson_sqrt_transition | ( | bytea8 | , |
float8 | , | ||
float8 | [], | ||
bytea8 | |||
) |
__glm_result_type __glm_result_t_stats | ( | bytea8 | state | ) |
__glm_result_type __glm_result_z_stats | ( | bytea8 | state | ) |
void glm | ( | varchar | source_table, |
varchar | model_table, | ||
varchar | dependent_varname, | ||
varchar | independent_varname, | ||
varchar | family_params, | ||
varchar | grouping_col, | ||
varchar | optim_params, | ||
boolean | verbose | ||
) |
void glm | ( | varchar | source_table, |
varchar | model_table, | ||
varchar | dependent_varname, | ||
varchar | independent_varname, | ||
varchar | family_params, | ||
varchar | grouping_col, | ||
varchar | optim_params | ||
) |
void glm | ( | varchar | source_table, |
varchar | model_table, | ||
varchar | dependent_varname, | ||
varchar | independent_varname, | ||
varchar | family_params, | ||
varchar | grouping_col | ||
) |
void glm | ( | varchar | source_table, |
varchar | model_table, | ||
varchar | dependent_varname, | ||
varchar | independent_varname, | ||
varchar | family_params | ||
) |
text glm | ( | text | message | ) |
text glm | ( | ) |
float8 glm_predict | ( | float8 [] | coef, |
float8 [] | col_ind_var, | ||
text | link | ||
) |
coef | Coefficients obtained by running generalized linear model. |
col_ind | Predictor variable array |
link | Link function used in training. Can be one of probit/logit |
This function computes the dot product of the independent variables and the coefficients. This requires the length of the two vectors to be the same.
text glm_predict | ( | text | message | ) |
text glm_predict | ( | ) |
boolean glm_predict_binomial | ( | float8 [] | coef, |
float8 [] | col_ind_var, | ||
text | link | ||
) |
coef | Coefficients obtained by running generalized linear model. |
col_ind | Predictor variable array |
link | Link function used in training. Can be one of probit/logit. |
This function computes the dot product of the independent variables and the coefficients. This requires the length of the two vectors to be the same.
text glm_predict_binomial | ( | text | message | ) |
float8 glm_predict_poisson | ( | float8 [] | coef, |
float8 [] | col_ind_var, | ||
text | link | ||
) |
coef | Coefficients obtained by running generalized linear model. |
col_ind | Predictor variable array |
link | Link function used in training |
This function computes the dot product of the independent variables and the coefficients. This requires the length of the two vectors to be the same.
text glm_predict_poisson | ( | text | message | ) |