linear.sql_in File Reference

SQL functions for linear regression. More...

Functions
CREATE FUNCTION MADlib	linregr_train (source_table VARCHAR,--name of input table out_table VARCHAR,--name of output table dependent_varname VARCHAR,--name of dependent variable independent_varname VARCHAR,--name of independent variable grouping_cols VARCHAR,--names of columns to group-by heteroskedasticity_option BOOLEAN--do heteroskedasticity test or not) RETURNS VOID AS $$PythonFunction(regress
	Linear regression training function with grouping support. More...
CREATE FUNCTION MADlib	linregr_train (source_table VARCHAR,--name of input table out_table VARCHAR,--name of output table dependent_varname VARCHAR,--name of dependent variable independent_varname VARCHAR,--name of independent variable grouping_cols VARCHAR--names of columns to group-by) RETURNS VOID AS $$SELECT MADlib.linregr_train($1
CREATE FUNCTION MADlib	linregr_train (source_table VARCHAR,--name of input table out_table VARCHAR,--name of output table dependent_varname VARCHAR,--name of dependent variable independent_varname VARCHAR--name of independent variable) RETURNS VOID AS $$SELECT MADlib.linregr_train($1
Online help function CREATE OR REPLACE FUNCTION MADlib	linregr_train () RETURNS VARCHAR AS $$BEGIN RETURN MADlib.linregr_train('')
CREATE OR REPLACE FUNCTION MADlib	linregr_train (message VARCHAR--usage string) RETURNS VARCHAR AS $$PythonFunction(regress
Deprecated functions Result Types CREATE TYPE MADlib linregr_result	AS (coef DOUBLE PRECISION[], r2 DOUBLE PRECISION, std_err DOUBLE PRECISION[], t_stats DOUBLE PRECISION[], p_values DOUBLE PRECISION[], condition_no DOUBLE PRECISION, num_processed BIGINT)
CREATE TYPE MADlib heteroskedasticity_test_result	AS (bp_stats DOUBLE PRECISION, bp_p_value DOUBLE PRECISION)
Functions for user defined aggregates normal CREATE OR REPLACE FUNCTION MADlib	linregr_transition (state MADlib.bytea8, y DOUBLE PRECISION, x DOUBLE PRECISION[]) RETURNS MADlib.bytea8 AS 'MODULE_PATHNAME'LANGUAGE C IMMUTABLE STRICT
CREATE OR REPLACE FUNCTION MADlib	linregr_merge_states (state1 MADlib.bytea8, state2 MADlib.bytea8) RETURNS MADlib.bytea8 AS 'MODULE_PATHNAME'LANGUAGE C IMMUTABLE STRICT
CREATE OR REPLACE FUNCTION MADlib	linregr_final (state MADlib.bytea8) RETURNS MADlib.linregr_result AS 'MODULE_PATHNAME'LANGUAGE C IMMUTABLE STRICT

Variables
CREATE FUNCTION MADlib	linear
CREATE FUNCTION MADlib linregr_train LANGUAGE	plpythonu
CREATE FUNCTION MADlib	FALSE
LANGUAGE	sql
CREATE FUNCTION MADlib	NULL
	END
LANGUAGE plpgsql	VOLATILE

Detailed Description

Date

January 2011

See Also

For a brief introduction to linear regression, see the module description Linear Regression.

Function Documentation

Deprecated functions Result Types CREATE TYPE MADlib linregr_result AS	(	coef DOUBLE	PRECISION[],
		r2 DOUBLE	PRECISION,
		std_err DOUBLE	PRECISION[],
		t_stats DOUBLE	PRECISION[],
		p_values DOUBLE	PRECISION[],
		condition_no DOUBLE	PRECISION,
		num_processed	BIGINT
	)

CREATE TYPE MADlib heteroskedasticity_test_result AS	(	bp_stats DOUBLE	PRECISION,
		bp_p_value DOUBLE	PRECISION
	)

CREATE OR REPLACE FUNCTION MADlib linregr_final

(

state MADlib.

bytea8)

CREATE OR REPLACE FUNCTION MADlib linregr_merge_states	(	state1 MADlib.	bytea8,
		state2 MADlib.	bytea8
	)

CREATE FUNCTION MADlib linregr_train	(	source_table	VARCHAR,
		--name of input table out_table	VARCHAR,
		--name of output table dependent_varname	VARCHAR,
		--name of dependent variable independent_varname	VARCHAR,
		--name of independent variable grouping_cols	VARCHAR,
		--names of columns to group-by heteroskedasticity_option BOOLEAN--do heteroskedasticity test or	not
	)

CREATE FUNCTION MADlib linregr_train	(	source_table	VARCHAR,
		--name of input table out_table	VARCHAR,
		--name of output table dependent_varname	VARCHAR,
		--name of dependent variable independent_varname	VARCHAR,
		--name of independent variable grouping_cols VARCHAR--names of columns to group-	by
	)

CREATE FUNCTION MADlib linregr_train	(	source_table	VARCHAR,
		--name of input table out_table	VARCHAR,
		--name of output table dependent_varname	VARCHAR,
		--name of dependent variable independent_varname VARCHAR--name of independent	variable
	)

Online help function CREATE OR REPLACE FUNCTION MADlib linregr_train

(

)

CREATE OR REPLACE FUNCTION MADlib linregr_train

(

message VARCHAR--usage

string)

Functions for user defined aggregates normal CREATE OR REPLACE FUNCTION MADlib linregr_transition	(	state MADlib.	bytea8,
		y DOUBLE	PRECISION,
		x DOUBLE	PRECISION[]
	)

Variable Documentation

END

CREATE OR REPLACE FUNCTION MADlib FALSE

CREATE OR REPLACE FUNCTION MADlib linear

CREATE OR REPLACE FUNCTION MADlib NULL

CREATE FUNCTION MADlib linregr_train LANGUAGE plpythonu

LANGUAGE sql

CREATE FUNCTION MADlib TRUE LANGUAGE sql VOLATILE