Kinetica   C#   API  Version 7.2.3.0
CreateProjection.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 using System.Collections.Generic;
8 
9 namespace kinetica
10 {
44  {
48  public struct Options
49  {
64  public const string CREATE_TEMP_TABLE = "create_temp_table";
65 
66  public const string TRUE = "true";
67  public const string FALSE = "false";
68 
78  public const string COLLECTION_NAME = "collection_name";
79 
85  public const string EXPRESSION = "expression";
86 
101  public const string IS_REPLICATED = "is_replicated";
102 
106  public const string OFFSET = "offset";
107 
110  public const string LIMIT = "limit";
111 
118  public const string ORDER_BY = "order_by";
119 
122  public const string CHUNK_SIZE = "chunk_size";
123 
126  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
127 
130  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
131 
138  public const string CREATE_INDEXES = "create_indexes";
139 
143  public const string TTL = "ttl";
144 
151  public const string SHARD_KEY = "shard_key";
152 
168  public const string PERSIST = "persist";
169 
184  public const string PRESERVE_DICT_ENCODING = "preserve_dict_encoding";
185 
199  public const string RETAIN_PARTITIONS = "retain_partitions";
200 
237  public const string PARTITION_TYPE = "partition_type";
238 
242  public const string RANGE = "RANGE";
243 
247  public const string INTERVAL = "INTERVAL";
248 
252  public const string LIST = "LIST";
253 
257  public const string HASH = "HASH";
258 
262  public const string SERIES = "SERIES";
263 
269  public const string PARTITION_KEYS = "partition_keys";
270 
286  public const string PARTITION_DEFINITIONS = "partition_definitions";
287 
302  public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";
303 
307  public const string VIEW_ID = "view_id";
308 
312  public const string STRATEGY_DEFINITION = "strategy_definition";
313 
319  public const string JOIN_WINDOW_FUNCTIONS = "join_window_functions";
320 
325  public const string JOIN_WINDOW_FUNCTIONS_THRESHOLD = "join_window_functions_threshold";
326  } // end struct Options
327 
335  public string table_name { get; set; }
336 
343  public string projection_name { get; set; }
344 
349  public IList<string> column_names { get; set; } = new List<string>();
350 
671  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
672 
676 
1019  string projection_name,
1020  IList<string> column_names,
1021  IDictionary<string, string> options = null)
1022  {
1023  this.table_name = table_name ?? "";
1024  this.projection_name = projection_name ?? "";
1025  this.column_names = column_names ?? new List<string>();
1026  this.options = options ?? new Dictionary<string, string>();
1027  } // end constructor
1028  } // end class CreateProjectionRequest
1029 
1034  {
1038  public struct Info
1039  {
1041  public const string COUNT = "count";
1042 
1045  public const string QUALIFIED_PROJECTION_NAME = "qualified_projection_name";
1046  } // end struct Info
1047 
1051  public string projection_name { get; set; }
1052 
1069  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1070  } // end class CreateProjectionResponse
1071 } // end namespace kinetica
const string ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
CreateProjectionRequest(string table_name, string projection_name, IList< string > column_names, IDictionary< string, string > options=null)
Constructs a CreateProjectionRequest object with the specified parameters.
const string PERSIST
If TRUE, then the projection specified in projection_name will be persisted and will not expire unles...
const string EXPRESSION
An optional filter expression to be applied to the source table prior to the projection.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string SERIES
Use series partitioning.
const string HASH
Use hash partitioning.
string projection_name
Name of the projection to be created, in [schema_name.
IList< string > column_names
List of columns from table_name to be included in the projection.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
const string LIMIT
The number of records to keep.
const string CREATE_TEMP_TABLE
If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of ...
IDictionary< string, string > options
Optional parameters.
IDictionary< string, string > info
Additional information.
const string PARTITION_TYPE
Partitioning scheme to use.
const string RANGE
Use range partitioning.
string projection_name
Value of projection_name.
const string INTERVAL
Use interval partitioning.
const string CHUNK_COLUMN_MAX_MEMORY
Indicates the target maximum data size for each column in a chunk to be used for this projection.
const string COUNT
Number of records in the final table
A set of results returned by Kinetica.createProjection.
const string OFFSET
The number of initial results to skip (this can be useful for paging through the results).
const string JOIN_WINDOW_FUNCTIONS
If set, window functions which require a reshard will be computed separately and joined back together...
CreateProjectionRequest()
Constructs a CreateProjectionRequest object with default parameters.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
A set of parameters for Kinetica.createProjection.
const string QUALIFIED_PROJECTION_NAME
The fully qualified name of the projection (i.e.
A set of string constants for the parameter info.
const string JOIN_WINDOW_FUNCTIONS_THRESHOLD
If the projection is greater than this width (in bytes), then window functions which require a reshar...
const string IS_AUTOMATIC_PARTITION
If TRUE, a new partition will be created for values which don't fall into an existing partition.
const string LIST
Use list partitioning.
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this projection.
const string TTL
Sets the TTL of the projection specified in projection_name.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of projection_name and us...
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this projection.
const string PRESERVE_DICT_ENCODING
If TRUE, then columns that were dict encoded in the source table will be dict encoded in the projecti...
A set of string constants for the parameter options.
string table_name
Name of the existing table on which the projection is to be applied, in [schema_name.
const string VIEW_ID
ID of view of which this projection is a member.
const string RETAIN_PARTITIONS
Determines whether the created projection will retain the partitioning scheme from the source table.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the projection.
const string IS_REPLICATED
If TRUE then the projection will be replicated even if the source table is not.