create_indicators.sql_in File Reference

SQL functions for dummy coding categorical variables. More...

Functions
void	create_indicator_variables (text source_table, text out_table, text categorical_cols, boolean keep_null, text distributed_by)
	Create new table containing dummy coded variables for categorical variables. More...
void	create_indicator_variables (text source_table, text out_table, text categorical_cols, boolean keep_null)
	Create new table containing dummy coded variables for categorical variables. More...
void	create_indicator_variables (text source_table, text out_table, text categorical_cols)
varchar	create_indicator_variables (varchar message)
varchar	create_indicator_variables ()

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 2014

See also

Calculates dummy-coded indicator variables for categorical variables

Function Documentation

create_indicator_variables() [1/5]

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols,
		boolean	keep_null,
		text	distributed_by
	)

Parameters

source_table	Name of table containing categorical variable
out_table	Name of table to output dummy variables
categorical_cols	Comma-separated list of column names to dummy code
keep_null	Boolean to determine the behavior for rows with NULL value
distributed_by	Comma-separated list of column names to use for distribution of output

Returns

Void

create_indicator_variables() [2/5]

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols,
		boolean	keep_null
	)

Parameters

source_table	Name of table containing categorical variable
out_table	Name of table to output dummy variables
categorical_cols	Comma-separated list of column names to dummy code
keep_null	Boolean to determine the behavior for rows with NULL value

Returns

Void

create_indicator_variables() [3/5]

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols
	)

create_indicator_variables() [4/5]

varchar create_indicator_variables

(

varchar

message

)

create_indicator_variables() [5/5]

varchar create_indicator_variables

(

)