create_union

GPUdb.create_union( table_name = None, table_names = None, input_column_names =
                    None, output_column_names = None, options = {} )

Creates a table that is the concatenation of one or more existing tables. It is equivalent to the SQL UNION ALL operator. Non-charN 'string' and 'bytes' column types cannot be included in a union, neither can columns with the property 'store_only'.

Input Parameter Description

Name	Type	Description
table_name	str	Name of the table to be created. Must not be the name of a currently existing GPUdb table. Cannot be an empty string.
table_names	list of str	The list of table names making up the union. Must contain the names of one or more existing tables.
input_column_names	list of lists of str	The list of columns from each of the corresponding input tables.
output_column_names	list of str	The list of names of the columns to be stored in the union.
options	dict of str	Optional parameters. Default value is an empty dict ( {} ). Supported Parameters (keys) Parameter Description collection_name Name of a collection in GPUdb to which the union is to be assigned as a child table. If empty, then the union will be a top level table. Default value is ''.

Output Parameter Description

Name	Type	Description
table_name	str	Value of input parameter table_name.