GPUdb C++ API  Version 7.0.19.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Pages
gpudb::CreateProjectionRequest Struct Reference

A set of input parameters for const. More...

#include <gpudb/protocol/create_projection.h>

Public Member Functions

 CreateProjectionRequest ()
 Constructs a CreateProjectionRequest object with default parameter values. More...
 
 CreateProjectionRequest (const std::string &tableName_, const std::string &projectionName_, const std::vector< std::string > &columnNames_, const std::map< std::string, std::string > &options_)
 Constructs a CreateProjectionRequest object with the specified parameters. More...
 

Public Attributes

std::string tableName
 
std::string projectionName
 
std::vector< std::string > columnNames
 
std::map< std::string,
std::string > 
options
 

Detailed Description

A set of input parameters for const.

Creates a new projection of an existing table. A projection represents a subset of the columns (potentially including derived columns) of a table.

For projection details and examples, see Projections. For limitations, see Projection Limitations and Cautions.

Window functions, which can perform operations like moving averages, are available through this endpoint as well as const.

A projection can be created with a different shard key than the source table. By specifying shard_key, the projection will be sharded according to the specified columns, regardless of how the source table is sharded. The source table can even be unsharded or replicated.

If tableName is empty, selection is performed against a single-row virtual table. This can be useful in executing temporal (NOW()), identity (USER()), or constant-based functions (GEODIST(-77.11, 38.88, -71.06, 42.36)).

Definition at line 48 of file create_projection.h.

Constructor & Destructor Documentation

gpudb::CreateProjectionRequest::CreateProjectionRequest ( )
inline

Constructs a CreateProjectionRequest object with default parameter values.

Definition at line 55 of file create_projection.h.

gpudb::CreateProjectionRequest::CreateProjectionRequest ( const std::string &  tableName_,
const std::string &  projectionName_,
const std::vector< std::string > &  columnNames_,
const std::map< std::string, std::string > &  options_ 
)
inline

Constructs a CreateProjectionRequest object with the specified parameters.

Parameters
[in]tableName_Name of the existing table on which the projection is to be applied. An empty table name creates a projection from a single-row virtual table, where columns specified should be constants or constant expressions.
[in]projectionName_Name of the projection to be created. Has the same naming restrictions as tables.
[in]columnNames_List of columns from tableName to be included in the projection. Can include derived columns. Can be specified as aliased via the syntax 'column_name as alias'.
[in]options_Optional parameters.

Definition at line 204 of file create_projection.h.

Member Data Documentation

std::vector<std::string> gpudb::CreateProjectionRequest::columnNames

Definition at line 214 of file create_projection.h.

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

Definition at line 215 of file create_projection.h.

std::string gpudb::CreateProjectionRequest::projectionName

Definition at line 213 of file create_projection.h.

std::string gpudb::CreateProjectionRequest::tableName

Definition at line 212 of file create_projection.h.


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