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

(

)