SQL functions for distributed deep learning with keras. More...

Functions
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus, varchar validation_table, integer metrics_compute_frequency, boolean warm_start, varchar name, varchar description)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus, varchar validation_table, integer metrics_compute_frequency, boolean warm_start, varchar name)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus, varchar validation_table, integer metrics_compute_frequency, boolean warm_start)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus, varchar validation_table, integer metrics_compute_frequency)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus, varchar validation_table)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations, boolean use_gpus)

void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_id, varchar compile_params, varchar fit_params, integer num_iterations)

bytea	fit_transition (bytea state, bytea dependent_var, bytea independent_var, integer[] dependent_var_shape, integer[] independent_var_shape, text model_architecture, text compile_params, text fit_params, integer dist_key, integer[] dist_key_mapping, integer current_seg_id, integer segments_per_host, integer[] images_per_seg, boolean use_gpus, integer[] accessible_gpus_for_seg, bytea prev_serialized_weights, boolean is_final_iteration)

bytea	fit_merge (bytea state1, bytea state2)

bytea	fit_final (bytea state)

aggregate bytea	fit_step (bytea, bytea, integer[], integer[], text, text, text, integer, integer[], integer, integer, integer[], boolean, integer[], bytea, boolean)

void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, boolean use_gpus, integer mst_key)

void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, boolean use_gpus)

void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type)

void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table)

float8[]	internal_keras_predict (real[] independent_var, text model_architecture, bytea model_weights, boolean is_response, float8 normalizing_const, integer current_seg_id, integer[] seg_ids, integer[] images_per_seg, boolean use_gpus, integer gpus_per_host, integer segments_per_host)

void	madlib_keras_predict_byom (varchar model_arch_table, integer model_id, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, boolean use_gpus, text[] class_values, float8 normalizing_const)

void	madlib_keras_predict_byom (varchar model_arch_table, integer model_id, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, boolean use_gpus, text[] class_values)

void	madlib_keras_predict_byom (varchar model_arch_table, integer model_id, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, boolean use_gpus)

void	madlib_keras_predict_byom (varchar model_arch_table, integer model_id, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type)

void	madlib_keras_predict_byom (varchar model_arch_table, integer model_id, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table)

void	madlib_keras_evaluate (varchar model_table, varchar test_table, varchar output_table, boolean use_gpus, integer mst_key)

void	madlib_keras_evaluate (varchar model_table, varchar test_table, varchar output_table, boolean use_gpus)

void	madlib_keras_evaluate (varchar model_table, varchar test_table, varchar output_table)

real[3]	internal_keras_eval_transition (real[3] state, bytea dependent_var, bytea independent_var, integer[] dependent_var_shape, integer[] independent_var_shape, text model_architecture, bytea serialized_weights, text compile_params, integer dist_key, integer[] dist_key_mapping, integer current_seg_id, integer segments_per_host, integer[] images_per_seg, boolean use_gpus, integer[] accessible_gpus_for_seg, boolean is_final_iteration)

real[3]	internal_keras_eval_merge (real[3] state1, real[3] state2)

real[2]	internal_keras_eval_final (real[3] state)

aggregate real[2]	internal_keras_evaluate (bytea, bytea, integer[], integer[], text, bytea, text, integer, integer[], integer, integer, integer[], boolean, integer[], boolean)

varchar	madlib_keras_fit (varchar message)

varchar	madlib_keras_fit ()

varchar	madlib_keras_evaluate (varchar message)

varchar	madlib_keras_evaluate ()

varchar	madlib_keras_predict (varchar message)

varchar	madlib_keras_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 2019

Function Documentation

bytea fit_final ( bytea state )

bytea fit_merge	(	bytea	state1,
		bytea	state2
	)

aggregate bytea fit_step	(	bytea	,
		bytea	,
		integer	[],
		integer	[],
		text	,
		text	,
		text	,
		integer	,
		integer	[],
		integer	,
		integer	,
		integer	[],
		boolean	,
		integer	[],
		bytea	,
		boolean
	)

bytea fit_transition	(	bytea	state,
		bytea	dependent_var,
		bytea	independent_var,
		integer[]	dependent_var_shape,
		integer[]	independent_var_shape,
		text	model_architecture,
		text	compile_params,
		text	fit_params,
		integer	dist_key,
		integer[]	dist_key_mapping,
		integer	current_seg_id,
		integer	segments_per_host,
		integer[]	images_per_seg,
		boolean	use_gpus,
		integer[]	accessible_gpus_for_seg,
		bytea	prev_serialized_weights,
		boolean	is_final_iteration
	)

real [2] internal_keras_eval_final ( real state[3] )

real [3] internal_keras_eval_merge	(	real	state1[3],
		real	state2[3]
	)

real [3] internal_keras_eval_transition	(	real	state[3],
		bytea	dependent_var,
		bytea	independent_var,
		integer[]	dependent_var_shape,
		integer[]	independent_var_shape,
		text	model_architecture,
		bytea	serialized_weights,
		text	compile_params,
		integer	dist_key,
		integer[]	dist_key_mapping,
		integer	current_seg_id,
		integer	segments_per_host,
		integer[]	images_per_seg,
		boolean	use_gpus,
		integer[]	accessible_gpus_for_seg,
		boolean	is_final_iteration
	)

aggregate real [2] internal_keras_evaluate	(	bytea	,
		bytea	,
		integer	[],
		integer	[],
		text	,
		bytea	,
		text	,
		integer	,
		integer	[],
		integer	,
		integer	,
		integer	[],
		boolean	,
		integer	[],
		boolean
	)

float8 [] internal_keras_predict	(	real[]	independent_var,
		text	model_architecture,
		bytea	model_weights,
		boolean	is_response,
		float8	normalizing_const,
		integer	current_seg_id,
		integer[]	seg_ids,
		integer[]	images_per_seg,
		boolean	use_gpus,
		integer	gpus_per_host,
		integer	segments_per_host
	)

void madlib_keras_evaluate	(	varchar	model_table,
		varchar	test_table,
		varchar	output_table,
		boolean	use_gpus,
		integer	mst_key
	)

void madlib_keras_evaluate	(	varchar	model_table,
		varchar	test_table,
		varchar	output_table,
		boolean	use_gpus
	)

void madlib_keras_evaluate	(	varchar	model_table,
		varchar	test_table,
		varchar	output_table
	)

varchar madlib_keras_evaluate ( varchar message )

varchar madlib_keras_evaluate ( )

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start,
		varchar	name,
		varchar	description
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start,
		varchar	name
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus,
		varchar	validation_table,
		integer	metrics_compute_frequency
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus,
		varchar	validation_table
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		boolean	use_gpus
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations
	)

varchar madlib_keras_fit ( varchar message )

varchar madlib_keras_fit ( )

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		boolean	use_gpus,
		integer	mst_key
	)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		boolean	use_gpus
	)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type
	)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table
	)

varchar madlib_keras_predict ( varchar message )

varchar madlib_keras_predict ( )

void madlib_keras_predict_byom	(	varchar	model_arch_table,
		integer	model_id,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		boolean	use_gpus,
		text[]	class_values,
		float8	normalizing_const
	)

void madlib_keras_predict_byom	(	varchar	model_arch_table,
		integer	model_id,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		boolean	use_gpus,
		text[]	class_values
	)

void madlib_keras_predict_byom	(	varchar	model_arch_table,
		integer	model_id,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		boolean	use_gpus
	)

void madlib_keras_predict_byom	(	varchar	model_arch_table,
		integer	model_id,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type
	)

void madlib_keras_predict_byom	(	varchar	model_arch_table,
		integer	model_id,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table
	)

Functions

Detailed Description

Function Documentation