1.15.1
User Documentation for Apache MADlib
pca.sql_in File Reference

Principal Component Analysis. More...

Functions

void pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, float8 variance)
 
void pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
 
void pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation)
 
void pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter)
 
void pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols)
 
void pca_train (text source_table, text pc_table, text row_id, integer k)
 
void pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
 
void pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation)
 
void pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter)
 
void pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols)
 
void pca_train (text source_table, text pc_table, text row_id, float8 variance)
 
text pca_train (varchar usage_string)
 
varchar pca_train ()
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, float8 variance)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols)
 
void pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance)
 
text pca_sparse_train (varchar usage_string)
 
text pca_sparse_train ()
 
void _pca_union (text source_table, text pc_table, text pc_table_mean, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, text result_summary_table_temp, float8 variance, integer grp_id, text grouping_where_clause, text sparse_where_condition, text select_grouping_cols, text temp_table_columns, boolean is_sparse, text col_id, text val_id, integer row_dim, integer col_dim)
 

Detailed Description

See also
For a brief introduction to Principal Component Analysis, see the module description Dimensionality Reduction.

Function Documentation

◆ _pca_union()

void _pca_union ( text  source_table,
text  pc_table,
text  pc_table_mean,
text  row_id,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table,
text  result_summary_table_temp,
float8  variance,
integer  grp_id,
text  grouping_where_clause,
text  sparse_where_condition,
text  select_grouping_cols,
text  temp_table_columns,
boolean  is_sparse,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim 
)

◆ pca_sparse_train() [1/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table,
float8  variance 
)

◆ pca_sparse_train() [2/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table 
)

◆ pca_sparse_train() [3/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation 
)

◆ pca_sparse_train() [4/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k,
text  grouping_cols,
integer  lanczos_iter 
)

◆ pca_sparse_train() [5/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k,
text  grouping_cols 
)

◆ pca_sparse_train() [6/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
integer  k 
)

◆ pca_sparse_train() [7/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
float8  variance,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table 
)

◆ pca_sparse_train() [8/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
float8  variance,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation 
)

◆ pca_sparse_train() [9/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
float8  variance,
text  grouping_cols,
integer  lanczos_iter 
)

◆ pca_sparse_train() [10/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
float8  variance,
text  grouping_cols 
)

◆ pca_sparse_train() [11/13]

void pca_sparse_train ( text  source_table,
text  pc_table,
text  row_id,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim,
float8  variance 
)

◆ pca_sparse_train() [12/13]

text pca_sparse_train ( varchar  usage_string)

◆ pca_sparse_train() [13/13]

text pca_sparse_train ( )

◆ pca_train() [1/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table,
float8  variance 
)

◆ pca_train() [2/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table 
)

◆ pca_train() [3/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation 
)

◆ pca_train() [4/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k,
text  grouping_cols,
integer  lanczos_iter 
)

◆ pca_train() [5/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k,
text  grouping_cols 
)

◆ pca_train() [6/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
integer  k 
)

◆ pca_train() [7/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
float8  variance,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation,
text  result_summary_table 
)

◆ pca_train() [8/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
float8  variance,
text  grouping_cols,
integer  lanczos_iter,
boolean  use_correlation 
)

◆ pca_train() [9/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
float8  variance,
text  grouping_cols,
integer  lanczos_iter 
)

◆ pca_train() [10/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
float8  variance,
text  grouping_cols 
)

◆ pca_train() [11/13]

void pca_train ( text  source_table,
text  pc_table,
text  row_id,
float8  variance 
)

◆ pca_train() [12/13]

text pca_train ( varchar  usage_string)

◆ pca_train() [13/13]

varchar pca_train ( )