GPUdb C++ API  Version 6.0.1.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends
gpudb::CreateProjectionResponse Struct Reference

A set of output parameters for 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 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 237 of file create_projection.h.

Constructor & Destructor Documentation

gpudb::CreateProjectionResponse::CreateProjectionResponse ( )
inline

Constructs a CreateProjectionResponse object with default parameter values.

Definition at line 244 of file create_projection.h.

Member Data Documentation

std::string gpudb::CreateProjectionResponse::projectionName

Definition at line 249 of file create_projection.h.


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