gpudb::CreateUnionRequest Struct Reference

A set of input parameters for 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 const.

Performs a union (concatenation) of one or more existing tables or views, the results of which are stored in a new view. 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'. Though not explicitly unions, intersect and except are also available from this endpoint.

Definition at line 25 of file create_union.h.

Constructor & Destructor Documentation

gpudb::CreateUnionRequest::CreateUnionRequest ( )

inline

Constructs a CreateUnionRequest object with default parameter values.

Definition at line 32 of file create_union.h.

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 making up the union. 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 union.
[in]	options_	Optional parameters. gpudb::create_union_collection_name: Name of a collection which is to contain the union. If the collection provided is non-existent, the collection will be automatically created. If empty, then the union will be a top-level table. gpudb::create_union_materialize_on_gpu: If 'true' then the columns of the union will be cached on the GPU. gpudb::create_union_true gpudb::create_union_false gpudb::create_union_mode: If 'merge_views' then this operation will merge (i.e. union) the provided views. All 'table_names' 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_intersect: Retains all unique rows 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. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 10' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 10 OR x <= 10'. gpudb::create_union_ttl: Sets the TTL of the table specified in tableName. The value must be the desired TTL in minutes. gpudb::create_union_persist: If true then the union will be persisted as a regular table (it will not be automatically cleared unless a ttl is provided, and the table data can be modified in subsequent operations). If false then the union will be a read-only, memory-only temporary table. gpudb::create_union_true gpudb::create_union_false

Definition at line 121 of file create_union.h.

Member Data Documentation

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

Definition at line 132 of file create_union.h.

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

Definition at line 134 of file create_union.h.

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

Definition at line 133 of file create_union.h.

std::string gpudb::CreateUnionRequest::tableName

Definition at line 130 of file create_union.h.

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

Definition at line 131 of file create_union.h.

---

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

• gpudb/protocol/create_union.h