Skip to content

Instantly share code, notes, and snippets.

Paul Meinshausen PMeinshausen

Block or report user

Report or block PMeinshausen

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View SMAVG.sql
--Syntax (version 1.1)
SELECT * FROM SMAVG(
ON {table_name|view_name|(query)}
PARTITION BY partition_column
ORDER BY order_by_column
COLUMNS('column_names')
RETURN_ALL('true'|'false')
WINDOW_SIZE('window_size')
);
View PrincipalComponentAnalysis.sql
--Syntax (version 1.1)
SELECT * FROM Pca_Reduce(
ON Pca_Map(
ON target_table
[TARGET_COLUMNS(target_columns)]
) PARTITION BY 1
[COMPONENTS(num_components)]
) ORDER BY component_rank;
View Percentile.sql
SELECT * FROM percentile(
ON input_table
PARTITION BY column_name [, column_name]*
PERCENTILE('percentile'[,'percentile']*)
TARGET_COLUMNS('column_name'[,'column_name']*)
[GROUP_COLUMNS('column_name'[,'column_name']*)]
);
View LinReg.sql
SELECT * FROM LinReg(
ON LinRegMatrix(ON {table_name | view_name | (query)}) PARTITION BY 1
);
View LARS.sql
--Syntax (version 1.0)
SELECT * FROM LARS(
ON (SELECT 1)
PARTITION BY 1
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
View KNN.sql
--Syntax (version 1.2)
SELECT * FROM KNN(
ON (SELECT 1)
PARTITION BY 1
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
View GLMPredict.sql
--Syntax (version 1.3)
SELECT * FROM GLMPredict(
ON input_table
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
[SSLTRUSTSTOREPASSWORD('SSLtruststorepassword')]
View GLM.sql
--Syntax (version 1.3)
SELECT * FROM GLM(
ON (SELECT 1)
PARTITION BY 1
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
View FMeasure.sql
--Syntax (version 1.1)
select * from FMeasure
(
ON table_name PARTITION BY 1
ExpectColumn('expect_column_name')
PredictColumn('result_column_name')
[Beta(beta_value)]
);
View EMAVG.sql
--Syntax (version 1.1)
SELECT * FROM EMAVG(
ON {table_name|view_name|(query)}
PARTITION BY partition_column
ORDER BY order_by_column
[COLUMNS('column_names')]
[RETURN_ALL('true'|'false')]
[START_ROWS('number')]
[ALPHA('alpha_value')]
You can’t perform that action at this time.