Version:

Create UnionΒΆ

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 string 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 array of strings The list of table names making up the union. Must contain the names of one or more existing tables.
input_column_names array of arrays of strings The list of columns from each of the corresponding input tables.
output_column_names array of strings The list of names of the columns to be stored in the union.
options map of strings

Optional parameters. Default value is an empty map ( {} ).

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 string Value of input parameter table_name.