Skip to content

Instantly share code, notes, and snippets.

Avatar

Paul Meinshausen PMeinshausen

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.