1.20.0
User Documentation for Apache MADlib
clustered_variance.sql_in File Reference

Functions

void clustered_variance_linregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col)
 Compute the clustered errors. More...
 
void clustered_variance_linregr (text source_table, text out_table, text depvar, text indvar, text clustervar)
 
text clustered_variance_linregr ()
 
text clustered_variance_linregr (text msg)
 
bytea8 __clustered_err_lin_transition (bytea8 state, float8 y, float8[] x, float8[] coef)
 
bytea8 __clustered_err_lin_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_lin_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_lin_step (float8, float8[], float8[])
 
__clustered_lin_result __clustered_lin_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 
float8 [] __array_add (float8[] x, float8[] y)
 
aggregate float8 [] __array_sum (float8[])
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer, float8 tolerance, boolean verbose_mode)
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar)
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col)
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter)
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer)
 
void clustered_variance_logregr (text source_table, text out_table, text depvar, text indvar, text clustervar, text grouping_col, integer max_iter, text optimizer, float8 tolerance)
 
text clustered_variance_logregr ()
 
text clustered_variance_logregr (text msg)
 
bytea8 __clustered_err_log_transition (bytea8 state, boolean y, float8[] x, float8[] coef)
 
bytea8 __clustered_err_log_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_log_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_log_step (boolean, float8[], float8[])
 
__clustered_log_result __clustered_log_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, text optimizer_params, boolean verbose_mode)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, text optimizer_params)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname)
 
text clustered_variance_mlogregr ()
 
text clustered_variance_mlogregr (text msg)
 
bytea8 __clustered_err_mlog_transition (bytea8 state, integer y, float8[] x, float8[] coef, integer num_cat, integer ref_cat)
 
bytea8 __clustered_err_mlog_merge (bytea8 state1, bytea8 state2)
 
__clustered_agg_result __clustered_err_mlog_final (bytea8 state)
 
aggregate __clustered_agg_result __clustered_err_mlog_step (integer, float8[], float8[], integer, integer)
 
__clustered_mlog_result __clustered_mlog_compute_stats (float8[] coef, float8[] meatvec, float8[] breadvec, integer mcluster, integer numrows)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer, float8 tolerance, boolean verbose_mode)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer, float8 tolerance)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter, varchar optimizer)
 
void clustered_variance_mlogregr (text source_table, text out_table, text dependent_varname, text independent_varname, text cluster_varname, integer ref_category, text grouping_cols, integer max_iter)
 

Function Documentation

◆ __array_add()

float8 [] __array_add ( float8 []  x,
float8 []  y 
)

◆ __array_sum()

aggregate float8 [] __array_sum ( float8  [])

◆ __clustered_err_lin_final()

__clustered_agg_result __clustered_err_lin_final ( bytea8  state)

◆ __clustered_err_lin_merge()

bytea8 __clustered_err_lin_merge ( bytea8  state1,
bytea8  state2 
)

◆ __clustered_err_lin_step()

aggregate __clustered_agg_result __clustered_err_lin_step ( float8  ,
float8  [],
float8  [] 
)

◆ __clustered_err_lin_transition()

bytea8 __clustered_err_lin_transition ( bytea8  state,
float8  y,
float8 []  x,
float8 []  coef 
)

◆ __clustered_err_log_final()

__clustered_agg_result __clustered_err_log_final ( bytea8  state)

◆ __clustered_err_log_merge()

bytea8 __clustered_err_log_merge ( bytea8  state1,
bytea8  state2 
)

◆ __clustered_err_log_step()

aggregate __clustered_agg_result __clustered_err_log_step ( boolean  ,
float8  [],
float8  [] 
)

◆ __clustered_err_log_transition()

bytea8 __clustered_err_log_transition ( bytea8  state,
boolean  y,
float8 []  x,
float8 []  coef 
)

◆ __clustered_err_mlog_final()

__clustered_agg_result __clustered_err_mlog_final ( bytea8  state)

◆ __clustered_err_mlog_merge()

bytea8 __clustered_err_mlog_merge ( bytea8  state1,
bytea8  state2 
)

◆ __clustered_err_mlog_step()

aggregate __clustered_agg_result __clustered_err_mlog_step ( integer  ,
float8  [],
float8  [],
integer  ,
integer   
)

◆ __clustered_err_mlog_transition()

bytea8 __clustered_err_mlog_transition ( bytea8  state,
integer  y,
float8 []  x,
float8 []  coef,
integer  num_cat,
integer  ref_cat 
)

◆ __clustered_lin_compute_stats()

__clustered_lin_result __clustered_lin_compute_stats ( float8 []  coef,
float8 []  meatvec,
float8 []  breadvec,
integer  mcluster,
integer  numrows 
)

◆ __clustered_log_compute_stats()

__clustered_log_result __clustered_log_compute_stats ( float8 []  coef,
float8 []  meatvec,
float8 []  breadvec,
integer  mcluster,
integer  numrows 
)

◆ __clustered_mlog_compute_stats()

__clustered_mlog_result __clustered_mlog_compute_stats ( float8 []  coef,
float8 []  meatvec,
float8 []  breadvec,
integer  mcluster,
integer  numrows 
)

◆ clustered_variance_linregr() [1/4]

void clustered_variance_linregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col 
)
Parameters
source_tableData table name
out_tableThe result table
depvarDependent variable expression
indvarIndependent variable expression
clustervarThe expressions used to clustering
grouping_colThe names of grouping columns

◆ clustered_variance_linregr() [2/4]

void clustered_variance_linregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar 
)

◆ clustered_variance_linregr() [3/4]

text clustered_variance_linregr ( )

◆ clustered_variance_linregr() [4/4]

text clustered_variance_linregr ( text  msg)

◆ clustered_variance_logregr() [1/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance,
boolean  verbose_mode 
)

◆ clustered_variance_logregr() [2/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar 
)

◆ clustered_variance_logregr() [3/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col 
)

◆ clustered_variance_logregr() [4/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter 
)

◆ clustered_variance_logregr() [5/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer 
)

◆ clustered_variance_logregr() [6/8]

void clustered_variance_logregr ( text  source_table,
text  out_table,
text  depvar,
text  indvar,
text  clustervar,
text  grouping_col,
integer  max_iter,
text  optimizer,
float8  tolerance 
)

◆ clustered_variance_logregr() [7/8]

text clustered_variance_logregr ( )

◆ clustered_variance_logregr() [8/8]

text clustered_variance_logregr ( text  msg)

◆ clustered_variance_mlogregr() [1/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
text  optimizer_params,
boolean  verbose_mode 
)

◆ clustered_variance_mlogregr() [2/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
text  optimizer_params 
)

◆ clustered_variance_mlogregr() [3/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols 
)

◆ clustered_variance_mlogregr() [4/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category 
)

◆ clustered_variance_mlogregr() [5/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname 
)

◆ clustered_variance_mlogregr() [6/11]

text clustered_variance_mlogregr ( )

◆ clustered_variance_mlogregr() [7/11]

text clustered_variance_mlogregr ( text  msg)

◆ clustered_variance_mlogregr() [8/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
integer  max_iter,
varchar  optimizer,
float8  tolerance,
boolean  verbose_mode 
)

◆ clustered_variance_mlogregr() [9/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
integer  max_iter,
varchar  optimizer,
float8  tolerance 
)

◆ clustered_variance_mlogregr() [10/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
integer  max_iter,
varchar  optimizer 
)

◆ clustered_variance_mlogregr() [11/11]

void clustered_variance_mlogregr ( text  source_table,
text  out_table,
text  dependent_varname,
text  independent_varname,
text  cluster_varname,
integer  ref_category,
text  grouping_cols,
integer  max_iter 
)