A set of input parameters for createUnion(const CreateUnionRequest&) const. More...

#include <gpudb/protocol/create_union.h>

Public Member Functions
	CreateUnionRequest ()
	Constructs a CreateUnionRequest object with default parameter values. More...

	CreateUnionRequest (const std::string &tableName_, const std::vector< std::string > &tableNames_, const std::vector< std::vector< std::string > > &inputColumnNames_, const std::vector< std::string > &outputColumnNames_, const std::map< std::string, std::string > &options_)
	Constructs a CreateUnionRequest object with the specified parameters. More...

Public Attributes
std::string	tableName

std::vector< std::string >	tableNames

std::vector< std::vector< std::string > >	inputColumnNames

std::vector< std::string >	outputColumnNames

std::map< std::string, std::string >	options

Detailed Description

A set of input parameters for createUnion(const CreateUnionRequest&) const.

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.

MERGE VIEWS - For a given set of filtered views on a single table, creates a single filtered view containing all of the unique records across all of the given filtered data sets.

Non-charN 'string' and 'bytes' column types cannot be merged, nor can columns marked as store-only.

Definition at line 47 of file create_union.h.

Constructor & Destructor Documentation

◆ CreateUnionRequest() [1/2]

gpudb::CreateUnionRequest::CreateUnionRequest ( )

inline

Constructs a CreateUnionRequest object with default parameter values.

Definition at line 54 of file create_union.h.

◆ CreateUnionRequest() [2/2]

gpudb::CreateUnionRequest::CreateUnionRequest	(	const std::string &	tableName_,
		const std::vector< std::string > &	tableNames_,
		const std::vector< std::vector< std::string > > &	inputColumnNames_,
		const std::vector< std::string > &	outputColumnNames_,
		const std::map< std::string, std::string > &	options_
	)

inline

Constructs a CreateUnionRequest object with the specified parameters.

Parameters

[in]	tableName_	Name of the table to be created. Has the same naming restrictions as tables.
[in]	tableNames_	The list of table names to merge. Must contain the names of one or more existing tables.
[in]	inputColumnNames_	The list of columns from each of the corresponding input tables.
[in]	outputColumnNames_	The list of names of the columns to be stored in the output table.
[in]	options_	Optional parameters. gpudb::create_union_collection_name: Name of a collection which is to contain the output table. If the collection provided is non-existent, the collection will be automatically created. If empty, the output table will be a top-level table. The default value is ''. gpudb::create_union_materialize_on_gpu: If true, then the columns of the output table will be cached on the GPU. gpudb::create_union_true gpudb::create_union_false The default value is gpudb::create_union_false. gpudb::create_union_mode: If merge_views, then this operation will merge the provided views. All tableNames must be views from the same underlying base table. gpudb::create_union_union_all: Retains all rows from the specified tables. gpudb::create_union_union: Retains all unique rows from the specified tables (synonym for union_distinct). gpudb::create_union_union_distinct: Retains all unique rows from the specified tables. gpudb::create_union_except: Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables). gpudb::create_union_except_all: Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables). gpudb::create_union_intersect: Retains all unique rows that appear in both of the specified tables (only works on 2 tables). gpudb::create_union_intersect_all: Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables). gpudb::create_union_merge_views: Merge two or more views (or views of views) of the same base data set into a new view. If this mode is selected inputColumnNames AND outputColumnNames must be empty. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 20' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 20 OR x <= 10'. The default value is gpudb::create_union_union_all. gpudb::create_union_chunk_size: Indicates the chunk size to be used for this table. gpudb::create_union_create_indexes: Comma-separated list of columns on which to create indexes on the output table. The columns specified must be present in outputColumnNames. gpudb::create_union_ttl: Sets the TTL of the table specified in tableName. gpudb::create_union_persist: If true, then the table specified in tableName will be persisted and will not expire unless a ttl is specified. If false, then the table will be an in-memory table and will expire unless a ttl is specified otherwise. gpudb::create_union_true gpudb::create_union_false The default value is gpudb::create_union_false. gpudb::create_union_view_id: view the output table will be a part of. The default value is ''. gpudb::create_union_force_replicated: If true, then the table specified in tableName will be replicated even if the source tables are not. gpudb::create_union_true gpudb::create_union_false The default value is gpudb::create_union_false.

Definition at line 179 of file create_union.h.

Member Data Documentation

◆ inputColumnNames

std::vector<std::vector<std::string> > gpudb::CreateUnionRequest::inputColumnNames

Definition at line 190 of file create_union.h.

◆ options

std::map<std::string, std::string> gpudb::CreateUnionRequest::options

Definition at line 192 of file create_union.h.

◆ outputColumnNames

std::vector<std::string> gpudb::CreateUnionRequest::outputColumnNames

Definition at line 191 of file create_union.h.

◆ tableName

std::string gpudb::CreateUnionRequest::tableName

Definition at line 188 of file create_union.h.

◆ tableNames

std::vector<std::string> gpudb::CreateUnionRequest::tableNames

Definition at line 189 of file create_union.h.

The documentation for this struct was generated from the following file:

gpudb/protocol/create_union.h

Public Member Functions

Public Attributes