Kinetica C# API
Version 7.1.10.0
|
A set of parameters for Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}). More...
Classes | |
struct | Options |
Optional parameters. More... | |
Public Member Functions | |
CreateProjectionRequest () | |
Constructs a CreateProjectionRequest object with default parameters. More... | |
CreateProjectionRequest (string table_name, string projection_name, IList< string > column_names, IDictionary< string, string > options=null) | |
Constructs a CreateProjectionRequest object with the specified parameters. More... | |
![]() | |
KineticaData (KineticaType type) | |
Constructor from Kinetica Type More... | |
KineticaData (System.Type type=null) | |
Default constructor, with optional System.Type More... | |
object | Get (int fieldPos) |
Retrieve a specific property from this object More... | |
void | Put (int fieldPos, object fieldValue) |
Write a specific property to this object More... | |
Properties | |
string | table_name [get, set] |
Name of the existing table on which the projection is to be applied, in [schema_name. More... | |
string | projection_name [get, set] |
Name of the projection to be created, in [schema_name. More... | |
IList< string > | column_names [get, set] |
List of columns from to be included in the projection. More... | |
IDictionary< string, string > | options = new List<string>() [get, set] |
Optional parameters. More... | |
![]() | |
Schema | Schema [get] |
Avro Schema for this class More... | |
Additional Inherited Members | |
![]() | |
static RecordSchema | SchemaFromType (System.Type t, KineticaType ktype=null) |
Create an Avro Schema from a System.Type and a KineticaType. More... | |
A set of parameters for Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}).
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 Kinetica.getRecordsByColumn(string,IList{string},long,long,IDictionary{string, string}).
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 table_name 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 56 of file CreateProjection.cs.
|
inline |
Constructs a CreateProjectionRequest object with default parameters.
Definition at line 928 of file CreateProjection.cs.
|
inline |
Constructs a CreateProjectionRequest object with the specified parameters.
table_name | Name of the existing table on which the projection is to be applied, in [schema_name.]table_name format, using standard name resolution rules. An empty table name creates a projection from a single-row virtual table, where columns specified should be constants or constant expressions. |
projection_name | Name of the projection to be created, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria. |
column_names | List of columns from to be included in the projection. Can include derived columns. Can be specified as aliased via the syntax 'column_name as alias'. |
options | Optional parameters.
|
Definition at line 1236 of file CreateProjection.cs.
|
getset |
List of columns from to be included in the projection.
Can include derived columns. Can be specified as aliased via the syntax 'column_name as alias'.
Definition at line 636 of file CreateProjection.cs.
|
getset |
Optional parameters.
The default value is an empty Dictionary.
Definition at line 923 of file CreateProjection.cs.
|
getset |
Name of the projection to be created, in [schema_name.
]table_name format, using standard name resolution rules and meeting table naming criteria.
Definition at line 630 of file CreateProjection.cs.
|
getset |
Name of the existing table on which the projection is to be applied, in [schema_name.
]table_name format, using standard name resolution rules. An empty table name creates a projection from a single-row virtual table, where columns specified should be constants or constant expressions.
Definition at line 622 of file CreateProjection.cs.