> ## Documentation Index > Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt > Use this file to discover all available pages before exploring further. # create_union
create\_union(table\_name=None, table\_names=None, input\_column\_names=None, output\_column\_names=None, options={"{"}{"}"})\[source]

Merges data from one or more tables with comparable data types into a new table.

The following merges are supported:

UNION (DISTINCT/ALL) - For data set union details and examples, see Union. For limitations, see Union Limitations and Cautions.

INTERSECT (DISTINCT/ALL) - For data set intersection details and examples, see Intersect. For limitations, see Intersect Limitations.

EXCEPT (DISTINCT/ALL) - For data set subtraction details and examples, see Except. For limitations, see Except Limitations.

Parameters

table\_name (str) –

Name of the table to be created, in \[schema\_name.]table\_name format, using standard name resolution rules and meeting table naming criteria.

table\_names (list of str) –

The list of table names to merge, in \[schema\_name.]table\_name format, using standard name resolution rules. Must contain the names of one or more existing tables. The user can provide a single element (which will be automatically promoted to a list internally) or a list.

input\_column\_names (list of lists of str) –

The list of columns from each of the corresponding input tables. The user can provide a single element (which will be automatically promoted to a list internally) or a list.

output\_column\_names (list of str) –

The list of names of the columns to be stored in the output table. The user can provide a single element (which will be automatically promoted to a list internally) or a list.

options (dict of str to str) –

Optional parameters. Allowed keys are:

  • create\_temp\_table – If true, a unique temporary table name will be generated in the sys\_temp schema and used in place of input parameter table\_name. If persist is false (or unspecified), then this is always allowed even if the caller does not have permission to create tables. The generated name is returned in qualified\_table\_name. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • collection\_name – \[DEPRECATED–please specify the containing schema for the projection as part of input parameter table\_name and use GPUdb.create\_schema() to create the schema if non-existent] Name of the schema for the output table. If the schema provided is non-existent, it will be automatically created. The default value is ‘’.

  • mode – The mode describes what rows of the tables being unioned will be retained. Allowed values are:

    • union\_all – Retains all rows from the specified tables.

    • union – Retains all unique rows from the specified tables (synonym for union\_distinct).

    • union\_distinct – Retains all unique rows from the specified tables.

    • except – Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).

    • except\_all – Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).

    • intersect – Retains all unique rows that appear in both of the specified tables (only works on 2 tables).

    • intersect\_all – Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).

    The default value is ‘union\_all’.

  • chunk\_size – Indicates the number of records per chunk to be used for this output table.

  • chunk\_column\_max\_memory – Indicates the target maximum data size for each column in a chunk to be used for this output table.

  • chunk\_max\_memory – Indicates the target maximum data size for all columns in a chunk to be used for this output table.

  • create\_indexes – Comma-separated list of columns on which to create indexes on the output table. The columns specified must be present in input parameter output\_column\_names.

  • partition\_type – Partitioning scheme to use for the output table. Allowed values are:

  • partition\_keys – Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by partition\_definitions.

  • partition\_definitions – Comma-separated list of partition definitions, whose format depends on the choice of partition\_type. See range partitioning, interval partitioning, list partitioning, hash partitioning, or series partitioning for example formats.

  • is\_automatic\_partition – If true, a new partition will be created for values which don’t fall into an existing partition. Currently only supported for list partitions. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • ttl – Sets the TTL of the output table specified in input parameter table\_name.

  • persist – If true, then the output table specified in input parameter table\_name will be persisted and will not expire unless a ttl is specified. If false, then the output table will be an in-memory table and will expire unless a ttl is specified otherwise. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • view\_id – ID of view of which this output table is a member. The default value is ‘’.

  • force\_replicated – If true, then the output table specified in input parameter table\_name will be replicated even if the source tables are not. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • strategy\_definition – The tier strategy for the table and its columns.

  • compression\_codec – The default compression codec for this table’s columns.

  • no\_count – Return a count of 0 for the union table response to avoid the cost of counting; optimization needed for many chunk virtual unions. The default value is ‘false’.

The default value is an empty dict ( {"{"}{"}"} ).

Returns

A dict with the following entries–

table\_name (str) –

Value of input parameter table\_name.

info (dict of str to str) –

Additional information. Allowed keys are:

  • count – Number of records in the final table.

  • qualified\_table\_name – The fully qualified name of the result table (i.e. including the schema).

The default value is an empty dict ( {"{"}{"}"} ).