SQL functions for test train split. More...

Functions
void	train_test_split (text source_table, text output_table, float8 train_proportion, float8 test_proportion, text grouping_cols, text target_cols, boolean with_replacement, boolean separate_output_tables)

void	train_test_split (text source_table, text output_table, float8 train_proportion, float8 test_proportion, text grouping_cols, text target_cols, boolean with_replacement)

void	train_test_split (text source_table, text output_table, float8 train_proportion, float8 test_proportion, text grouping_cols, text target_cols)

void	train_test_split (text source_table, text output_table, float8 train_proportion, float8 test_proportion, text grouping_cols)

void	train_test_split (text source_table, text output_table, float8 train_proportion, float8 test_proportion)

void	train_test_split (text source_table, text output_table, float8 train_proportion)

varchar	train_test_split (varchar message)

varchar	train_test_split ()

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: 07/19/2017

See also: Given a table, test train split returns a proportion of records for each group (strata).

Function Documentation

◆ train_test_split() [1/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion,
		float8	test_proportion,
		text	grouping_cols,
		text	target_cols,
		boolean	with_replacement,
		boolean	separate_output_tables
	)

◆ train_test_split() [2/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion,
		float8	test_proportion,
		text	grouping_cols,
		text	target_cols,
		boolean	with_replacement
	)

◆ train_test_split() [3/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion,
		float8	test_proportion,
		text	grouping_cols,
		text	target_cols
	)

◆ train_test_split() [4/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion,
		float8	test_proportion,
		text	grouping_cols
	)

◆ train_test_split() [5/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion,
		float8	test_proportion
	)

◆ train_test_split() [6/8]

void train_test_split	(	text	source_table,
		text	output_table,
		float8	train_proportion
	)

◆ train_test_split() [7/8]

varchar train_test_split ( varchar message )

◆ train_test_split() [8/8]

varchar train_test_split ( )

Functions