Skip to main content
Source

​
pub async fn create_union( &self, table_name: String, table_names: Vec<String>, input_column_names: Vec<Vec<String>>, output_column_names: Vec<String>, ) -> Result<CreateUnionResponse, KineticaError>

Create a table that is the merge of one or more tables

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.

  • table_name - 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 - 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.
  • input_column_names - The list of columns from each of the corresponding input tables.
  • output_column_names - The list of names of the columns to be stored in the output table.
Source

​
pub async fn create_union_with_opts( &self, table_name: String, table_names: Vec<String>, input_column_names: Vec<Vec<String>>, output_column_names: Vec<String>, options: CreateUnionRequestOptions, ) -> Result<CreateUnionResponse, KineticaError>

Create a table that is the merge of one or more tables

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.

  • table_name - 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 - 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.
  • input_column_names - The list of columns from each of the corresponding input tables.
  • output_column_names - The list of names of the columns to be stored in the output table.
  • options - The optional parameters; any left unset take the server’s defaults.

Sends a pre-built CreateUnionRequest to the /create/union endpoint.

Sends a pre-built CreateUnionRequest to a specific worker URL, bypassing HA head-node selection. Used for multi-head access.