2.1.0
User Documentation for Apache MADlib
svm.sql_in File Reference

SQL functions for SVM (Poisson) More...

Functions

float8 [] linear_svm_igd_transition (float8[] state, float8[] ind_var, float8 dep_var, float8[] previous_state, integer dimension, float8 stepsize, float8 reg, boolean is_l2, integer n_tuples, float8 epsilon, boolean is_svc, float8 tuple_weight)
 
float8 [] linear_svm_igd_merge (float8[] state1, float8[] state2)
 
float8 [] linear_svm_igd_final (float8[] state)
 
aggregate float8 [] linear_svm_igd_step (float8[] ind_var, float8 dep_var, float8[] previous_state, integer dimension, float8 stepsize, float8 reg, boolean is_l2, integer n_tuples, float8 epsilon, boolean is_svc, float8 tuple_weight)
 
float8 internal_linear_svm_igd_distance (float8[] state1, float8[] state2)
 
linear_svm_result internal_linear_svm_igd_result (float8[] state)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func)
 
void svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func)
 
void svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname)
 
void svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
 
void svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
 
void svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
 
void svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params)
 
void svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func)
 
void svm_one_class (text source_table, text model_table, text independent_varname)
 
void svm_predict (text model_table, text new_data_table, text id_col_name, text output_table)
 Scores the data points stored in a table using a learned linear support-vector model. More...
 
text svm_predict (text message)
 Help function. More...
 
text svm_predict ()
 
text svm_classification (text message)
 
text svm_classification ()
 
text svm_one_class (text message)
 
text svm_one_class ()
 
text svm_regression (text message)
 
text svm_regression ()
 

Detailed Description

Date
July 2015
See also
For a brief introduction to SVM (Poisson), see the module description Support Vector Machines.

Function Documentation

◆ internal_linear_svm_igd_distance()

float8 internal_linear_svm_igd_distance ( float8 []  state1,
float8 []  state2 
)

◆ internal_linear_svm_igd_result()

linear_svm_result internal_linear_svm_igd_result ( float8 []  state)

◆ linear_svm_igd_final()

float8 [] linear_svm_igd_final ( float8 []  state)

◆ linear_svm_igd_merge()

float8 [] linear_svm_igd_merge ( float8 []  state1,
float8 []  state2 
)

◆ linear_svm_igd_step()

aggregate float8 [] linear_svm_igd_step ( float8 []  ind_var,
float8  dep_var,
float8 []  previous_state,
integer  dimension,
float8  stepsize,
float8  reg,
boolean  is_l2,
integer  n_tuples,
float8  epsilon,
boolean  is_svc,
float8  tuple_weight 
)

◆ linear_svm_igd_transition()

float8 [] linear_svm_igd_transition ( float8 []  state,
float8 []  ind_var,
float8  dep_var,
float8 []  previous_state,
integer  dimension,
float8  stepsize,
float8  reg,
boolean  is_l2,
integer  n_tuples,
float8  epsilon,
boolean  is_svc,
float8  tuple_weight 
)

◆ svm_classification() [1/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params,
bool  verbose 
)

◆ svm_classification() [2/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params 
)

◆ svm_classification() [3/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col 
)

◆ svm_classification() [4/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params 
)

◆ svm_classification() [5/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func 
)

◆ svm_classification() [6/8]

void svm_classification ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname 
)

◆ svm_classification() [7/8]

text svm_classification ( text  message)

◆ svm_classification() [8/8]

text svm_classification ( )

◆ svm_one_class() [1/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params,
bool  verbose 
)

◆ svm_one_class() [2/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params 
)

◆ svm_one_class() [3/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col 
)

◆ svm_one_class() [4/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname,
text  kernel_func,
text  kernel_params 
)

◆ svm_one_class() [5/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname,
text  kernel_func 
)

◆ svm_one_class() [6/8]

void svm_one_class ( text  source_table,
text  model_table,
text  independent_varname 
)

◆ svm_one_class() [7/8]

text svm_one_class ( text  message)

◆ svm_one_class() [8/8]

text svm_one_class ( )

◆ svm_predict() [1/3]

void svm_predict ( text  model_table,
text  new_data_table,
text  id_col_name,
text  output_table 
)
Parameters
model_tableName of table where the learned model to be used is stored
new_data_tableName of table/view containing the data points to be scored
id_colName of column in new_data_table containing the integer identifier of data points
output_tableName of table to store the results
Returns
Textual summary of the algorithm run

◆ svm_predict() [2/3]

text svm_predict ( text  message)

◆ svm_predict() [3/3]

text svm_predict ( )

◆ svm_regression() [1/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params,
bool  verbose 
)

◆ svm_regression() [2/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col,
text  params 
)

◆ svm_regression() [3/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params,
text  grouping_col 
)

◆ svm_regression() [4/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func,
text  kernel_params 
)

◆ svm_regression() [5/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname,
text  kernel_func 
)

◆ svm_regression() [6/8]

void svm_regression ( text  source_table,
text  model_table,
text  dependent_varname,
text  independent_varname 
)

◆ svm_regression() [7/8]

text svm_regression ( text  message)

◆ svm_regression() [8/8]

text svm_regression ( )