PMeinshausen

--Syntax (version 1.1)
select * from ConfusionMatrix(
  ON {table_name|view_name|(query)} PARTITION BY <expect_column_name> 
  EXPECTCOLUMN('expect_column_name')
  PREDICTCOLUMN('result_column_name')
);

PMeinshausen

--Syntax (version 1.3)

SELECT * FROM Corr_Reduce( 
  ON Corr_Map(
    ON {table_name | view_name | (query)}
    COLUMNPAIRS('col_name1:col_name2',
                '[col_index1:col_index2]',...)
                KEY_NAME ('key_name')
    )
    PARTITION BY key_name

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

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.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.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.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.0)

SELECT * FROM LARS(
  ON (SELECT 1)
  PARTITION BY 1
  [DOMAIN('host:port')]
  [DATABASE('db_name')]
  [USERID('user_id')]
  [PASSWORD('password')]
  [SSLSETTINGS('SSLsettings')]

PMeinshausen

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

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