PMeinshausen

--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')
);

PMeinshausen

--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;

PMeinshausen

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']*)]
);

PMeinshausen

SELECT * FROM LinReg(
  ON LinRegMatrix(ON {table_name | view_name | (query)}) PARTITION BY 1
);

PMeinshausen

--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')]

PMeinshausen

--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')]

PMeinshausen

--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')]

PMeinshausen

--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')]

PMeinshausen

--Syntax (version 1.1)

select * from FMeasure
(
  ON table_name PARTITION BY 1
  ExpectColumn('expect_column_name')
  PredictColumn('result_column_name')
  [Beta(beta_value)]
);

PMeinshausen

--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')]