1.14
User Documentation for Apache MADlib
mlp.sql_in File Reference

SQL functions for multilayer perceptron. More...

Functions

float8 [] mlp_igd_transition (float8[] state, float8[] ind_var, float8[] dep_var, float8[] previous_state, float8[] layer_sizes, float8 learning_rate_init, integer activation, integer is_classification, float8 weight, float8[] warm_start_coeff, float8 lambda)
 
float8 [] mlp_minibatch_transition (float8[] state, float8[] ind_var, float8[] dep_var, float8[] previous_state, float8[] layer_sizes, float8 learning_rate_init, integer activation, integer is_classification, float8 weight, float8[] warm_start_coeff, float8 lambda, integer batch_size, integer n_epochs)
 
float8 [] mlp_igd_merge (float8[] state1, float8[] state2)
 
float8 [] mlp_igd_final (float8[] state)
 
float8 [] mlp_minibatch_merge (float8[] state1, float8[] state2)
 
float8 [] mlp_minibatch_final (float8[] state)
 
aggregate float8 [] mlp_igd_step (float8[], float8[], float8[], float8[], float8, integer, integer, float8, float8[], float8)
 
aggregate float8 [] mlp_minibatch_step (float8[], float8[], float8[], float8[], float8, integer, integer, float8, float8[], float8, integer, integer)
 
float8 internal_mlp_igd_distance (float8[] state1, float8[] state2)
 
mlp_result internal_mlp_igd_result (float8[] state)
 
mlp_result internal_mlp_minibatch_result (float8[] state)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose, varchar grouping_col)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose, varchar grouping_col)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params)
 
void mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params)
 
void mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes)
 
void mlp_predict (varchar model_table, varchar data_table, varchar id_col_name, varchar output_table, varchar pred_type)
 
float8 [] internal_predict_mlp (float8[] coeff, float8[] independent_varname, float8 is_classification, float8 activation, float8[] layer_sizes, integer is_response, float8[] x_means, float8[] x_stds, integer array_dep_var_for_classification)
 
text mlp_classification (text message)
 
text mlp_classification ()
 
text mlp_regression (text message)
 
text mlp_regression ()
 
text mlp_predict (text message)
 
text mlp_predict ()
 

Detailed Description

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Date
June 2012

Function Documentation

◆ internal_mlp_igd_distance()

float8 internal_mlp_igd_distance ( float8 []  state1,
float8 []  state2 
)

◆ internal_mlp_igd_result()

mlp_result internal_mlp_igd_result ( float8 []  state)

◆ internal_mlp_minibatch_result()

mlp_result internal_mlp_minibatch_result ( float8 []  state)

◆ internal_predict_mlp()

float8 [] internal_predict_mlp ( float8 []  coeff,
float8 []  independent_varname,
float8  is_classification,
float8  activation,
float8 []  layer_sizes,
integer  is_response,
float8 []  x_means,
float8 []  x_stds,
integer  array_dep_var_for_classification 
)

◆ mlp_classification() [1/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start,
boolean  verbose,
varchar  grouping_col 
)

◆ mlp_classification() [2/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start,
boolean  verbose 
)

◆ mlp_classification() [3/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start 
)

◆ mlp_classification() [4/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights 
)

◆ mlp_classification() [5/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation 
)

◆ mlp_classification() [6/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params 
)

◆ mlp_classification() [7/9]

void mlp_classification ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes 
)

◆ mlp_classification() [8/9]

text mlp_classification ( text  message)

◆ mlp_classification() [9/9]

text mlp_classification ( )

◆ mlp_igd_final()

float8 [] mlp_igd_final ( float8 []  state)

◆ mlp_igd_merge()

float8 [] mlp_igd_merge ( float8 []  state1,
float8 []  state2 
)

◆ mlp_igd_step()

aggregate float8 [] mlp_igd_step ( float8  [],
float8  [],
float8  [],
float8  [],
float8  ,
integer  ,
integer  ,
float8  ,
float8  [],
float8   
)

◆ mlp_igd_transition()

float8 [] mlp_igd_transition ( float8 []  state,
float8 []  ind_var,
float8 []  dep_var,
float8 []  previous_state,
float8 []  layer_sizes,
float8  learning_rate_init,
integer  activation,
integer  is_classification,
float8  weight,
float8 []  warm_start_coeff,
float8  lambda 
)

◆ mlp_minibatch_final()

float8 [] mlp_minibatch_final ( float8 []  state)

◆ mlp_minibatch_merge()

float8 [] mlp_minibatch_merge ( float8 []  state1,
float8 []  state2 
)

◆ mlp_minibatch_step()

aggregate float8 [] mlp_minibatch_step ( float8  [],
float8  [],
float8  [],
float8  [],
float8  ,
integer  ,
integer  ,
float8  ,
float8  [],
float8  ,
integer  ,
integer   
)

◆ mlp_minibatch_transition()

float8 [] mlp_minibatch_transition ( float8 []  state,
float8 []  ind_var,
float8 []  dep_var,
float8 []  previous_state,
float8 []  layer_sizes,
float8  learning_rate_init,
integer  activation,
integer  is_classification,
float8  weight,
float8 []  warm_start_coeff,
float8  lambda,
integer  batch_size,
integer  n_epochs 
)

◆ mlp_predict() [1/3]

void mlp_predict ( varchar  model_table,
varchar  data_table,
varchar  id_col_name,
varchar  output_table,
varchar  pred_type 
)

◆ mlp_predict() [2/3]

text mlp_predict ( text  message)

◆ mlp_predict() [3/3]

text mlp_predict ( )

◆ mlp_regression() [1/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start,
boolean  verbose,
varchar  grouping_col 
)

◆ mlp_regression() [2/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start,
boolean  verbose 
)

◆ mlp_regression() [3/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights,
boolean  warm_start 
)

◆ mlp_regression() [4/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation,
varchar  weights 
)

◆ mlp_regression() [5/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params,
varchar  activation 
)

◆ mlp_regression() [6/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes,
varchar  optimizer_params 
)

◆ mlp_regression() [7/9]

void mlp_regression ( varchar  source_table,
varchar  output_table,
varchar  independent_varname,
varchar  dependent_varname,
integer []  hidden_layer_sizes 
)

◆ mlp_regression() [8/9]

text mlp_regression ( text  message)

◆ mlp_regression() [9/9]

text mlp_regression ( )