Kinetica   C#   API  Version 7.2.3.1
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 
42 {
46  public struct Options
47  {
62  public const string CREATE_TEMP_TABLE = "create_temp_table";
63 
64  public const string TRUE = "true";
65  public const string FALSE = "false";
66 
74  public const string COLLECTION_NAME = "collection_name";
75 
81  public const string EXPRESSION = "expression";
82 
96  public const string IS_REPLICATED = "is_replicated";
97 
101  public const string OFFSET = "offset";
102 
105  public const string LIMIT = "limit";
106 
113  public const string ORDER_BY = "order_by";
114 
117  public const string CHUNK_SIZE = "chunk_size";
118 
121  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
122 
125  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
126 
133  public const string CREATE_INDEXES = "create_indexes";
134 
138  public const string TTL = "ttl";
139 
146  public const string SHARD_KEY = "shard_key";
147 
163  public const string PERSIST = "persist";
164 
179  public const string PRESERVE_DICT_ENCODING = "preserve_dict_encoding";
180 
194  public const string RETAIN_PARTITIONS = "retain_partitions";
195 
231  public const string PARTITION_TYPE = "partition_type";
232 
236  public const string RANGE = "RANGE";
237 
241  public const string INTERVAL = "INTERVAL";
242 
246  public const string LIST = "LIST";
247 
251  public const string HASH = "HASH";
252 
256  public const string SERIES = "SERIES";
257 
263  public const string PARTITION_KEYS = "partition_keys";
264 
280  public const string PARTITION_DEFINITIONS = "partition_definitions";
281 
296  public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";
297 
300  public const string VIEW_ID = "view_id";
301 
305  public const string STRATEGY_DEFINITION = "strategy_definition";
306 
311  public const string COMPRESSION_CODEC = "compression_codec";
312 
318  public const string JOIN_WINDOW_FUNCTIONS = "join_window_functions";
319 
324  public const string JOIN_WINDOW_FUNCTIONS_THRESHOLD = "join_window_functions_threshold";
325 
334  public const string QUALIFY_FILTER = "qualify_filter";
335  } // end struct Options
336 
344  public string table_name { get; set; }
345 
352  public string projection_name { get; set; }
353 
358  public IList<string> column_names { get; set; } = new List<string>();
359 
685  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
686 
690 
1037  string projection_name,
1038  IList<string> column_names,
1039  IDictionary<string, string> options = null)
1040  {
1041  this.table_name = table_name ?? "";
1042  this.projection_name = projection_name ?? "";
1043  this.column_names = column_names ?? new List<string>();
1044  this.options = options ?? new Dictionary<string, string>();
1045  } // end constructor
1046 } // end class CreateProjectionRequest
1047 
1052 {
1056  public struct Info
1057  {
1059  public const string COUNT = "count";
1060 
1063  public const string QUALIFIED_PROJECTION_NAME = "qualified_projection_name";
1064  } // end struct Info
1065 
1069  public string projection_name { get; set; }
1070 
1087  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1088 } // end class CreateProjectionResponse
const string SERIES
Use series partitioning.
const string IS_REPLICATED
If TRUE then the projection will be replicated even if the source table is not.
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 TTL
Sets the TTL of the projection specified in projection_name.
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 ...
const string LIMIT
The number of records to keep.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; 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 INTERVAL
Use interval partitioning.
const string PRESERVE_DICT_ENCODING
If TRUE, then columns that were dict encoded in the source table will be dict encoded in the projecti...
const string JOIN_WINDOW_FUNCTIONS
If set, window functions which require a reshard will be computed separately and joined back together...
const string PARTITION_TYPE
Partitioning scheme to use.
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string OFFSET
The number of initial results to skip (this can be useful for paging through the results).
const string COUNT
Number of records in the final table.
const string PERSIST
If TRUE, then the projection specified in projection_name will be persisted and will not expire unles...
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this projection.
IList< string > column_names
List of columns from table_name to be included in the projection.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this projection.
const string ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
CreateProjectionRequest()
Constructs a CreateProjectionRequest object with default parameters.
const string RETAIN_PARTITIONS
Determines whether the created projection will retain the partitioning scheme from the source table.
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 RANGE
Use range partitioning.
A set of string constants for the parameter info.
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 COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of projection_name and us...
A set of results returned by Kinetica.createProjection.
IDictionary< string, string > options
Optional parameters.
const string EXPRESSION
An optional filter expression to be applied to the source table prior to the projection.
const string QUALIFIED_PROJECTION_NAME
The fully qualified name of the projection (i.e.
const string QUALIFY_FILTER
An optional filter expression applied to the projection after window function evaluation,...
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 PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
string projection_name
Value of projection_name.
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the projection.
const string LIST
Use list partitioning.
const string COMPRESSION_CODEC
The default compression codec for the projection's columns.
A set of string constants for the parameter options.
A set of parameters for Kinetica.createProjection.
const string HASH
Use hash partitioning.
string projection_name
Name of the projection to be created, in [schema_name.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
IDictionary< string, string > info
Additional information.