GPUdb C++ API
Version 6.0.1.0
|
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 |
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.
|
inline |
Constructs a CreateProjectionResponse object with default parameter values.
Definition at line 244 of file create_projection.h.
std::string gpudb::CreateProjectionResponse::projectionName |
Definition at line 249 of file create_projection.h.