1.10.0
User Documentation for MADlib
pca_project.sql_in File Reference

Principal Component Analysis Projection. More...

Functions

void pca_project (text source_table, text pc_table, text out_table, text row_id, text residual_table, text result_summary_table)
 
void pca_project (text source_table, text pc_table, text out_table, text row_id)
 
void pca_project (text source_table, text pc_table, text out_table, text row_id, text residual_table)
 
varchar pca_project (text usage_string)
 
varchar pca_project ()
 
void pca_sparse_project (text source_table, text pc_table, text out_table, text row_id, text col_id, text val_id, int4 row_dim, int4 col_dim, text residual_table, text result_summary_table)
 
void pca_sparse_project (text source_table, text pc_table, text out_table, text row_id, text col_id, text val_id, int4 row_dim, int4 col_dim)
 
void pca_sparse_project (text source_table, text pc_table, text out_table, text row_id, text col_id, text val_id, int4 row_dim, int4 col_dim, text residual_table)
 
void _pca_project_union (text source_table, text pc_table, text out_table, text row_id, text original_row_id, text grouping_cols, text grouping_cols_clause, text residual_table, text result_summary_table, integer grp_id, text grouping_where_clause, text sparse_where_condition, text select_grouping_cols, text grouping_cols_values, text temp_source_table_columns, text temp_pc_table_columns, boolean is_sparse, text col_id, text val_id, integer row_dim, integer col_dim)
 
varchar pca_sparse_project (text usage_string)
 
varchar pca_sparse_project ()
 

Detailed Description

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

Function Documentation

◆ _pca_project_union()

void _pca_project_union ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  original_row_id,
text  grouping_cols,
text  grouping_cols_clause,
text  residual_table,
text  result_summary_table,
integer  grp_id,
text  grouping_where_clause,
text  sparse_where_condition,
text  select_grouping_cols,
text  grouping_cols_values,
text  temp_source_table_columns,
text  temp_pc_table_columns,
boolean  is_sparse,
text  col_id,
text  val_id,
integer  row_dim,
integer  col_dim 
)

◆ pca_project() [1/5]

void pca_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  residual_table,
text  result_summary_table 
)

◆ pca_project() [2/5]

void pca_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id 
)

◆ pca_project() [3/5]

void pca_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  residual_table 
)

◆ pca_project() [4/5]

varchar pca_project ( text  usage_string)

◆ pca_project() [5/5]

varchar pca_project ( )

◆ pca_sparse_project() [1/5]

void pca_sparse_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  col_id,
text  val_id,
int4  row_dim,
int4  col_dim,
text  residual_table,
text  result_summary_table 
)

◆ pca_sparse_project() [2/5]

void pca_sparse_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  col_id,
text  val_id,
int4  row_dim,
int4  col_dim 
)

◆ pca_sparse_project() [3/5]

void pca_sparse_project ( text  source_table,
text  pc_table,
text  out_table,
text  row_id,
text  col_id,
text  val_id,
int4  row_dim,
int4  col_dim,
text  residual_table 
)

◆ pca_sparse_project() [4/5]

varchar pca_sparse_project ( text  usage_string)

◆ pca_sparse_project() [5/5]

varchar pca_sparse_project ( )