GPUdb C++ API  Version 6.1.0.0
Public Member Functions | Public Attributes | List of all members
gpudb::CreateProjectionResponse Struct Reference

A set of output parameters for createProjection(const CreateProjectionRequest&) const. More...

#include <gpudb/protocol/create_projection.h>

Public Member Functions

 CreateProjectionResponse ()
 Constructs a CreateProjectionResponse object with default parameter values. More...
 

Public Attributes

std::string projectionName
 

Detailed Description

A set of output parameters for createProjection(const CreateProjectionRequest&) const.

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

Notes:

A moving average can be calculated on a given column using the following syntax in the columnNames parameter:

'moving_average(column_name,num_points_before,num_points_after) as new_column_name'

For each record in the moving_average function's 'column_name' parameter, it computes the average over the previous 'num_points_before' records and the subsequent 'num_points_after' records.

Note that moving average relies on order_by, and order_by requires that all the data being ordered resides on the same processing node, so it won't make sense to use order_by without moving average.

Also, 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.

Definition at line 245 of file create_projection.h.

Constructor & Destructor Documentation

◆ CreateProjectionResponse()

gpudb::CreateProjectionResponse::CreateProjectionResponse ( )
inline

Constructs a CreateProjectionResponse object with default parameter values.

Definition at line 252 of file create_projection.h.

Member Data Documentation

◆ projectionName

std::string gpudb::CreateProjectionResponse::projectionName

Definition at line 257 of file create_projection.h.

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