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 {
43  public class CreateProjectionRequest : KineticaData
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 
318  public const string COMPRESSION_CODEC = "compression_codec";
319 
325  public const string JOIN_WINDOW_FUNCTIONS = "join_window_functions";
326 
331  public const string JOIN_WINDOW_FUNCTIONS_THRESHOLD = "join_window_functions_threshold";
332  } // end struct Options
333 
341  public string table_name { get; set; }
342 
349  public string projection_name { get; set; }
350 
355  public IList<string> column_names { get; set; } = new List<string>();
356 
686  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
687 
691 
1043  string projection_name,
1044  IList<string> column_names,
1045  IDictionary<string, string> options = null)
1046  {
1047  this.table_name = table_name ?? "";
1048  this.projection_name = projection_name ?? "";
1049  this.column_names = column_names ?? new List<string>();
1050  this.options = options ?? new Dictionary<string, string>();
1051  } // end constructor
1052  } // end class CreateProjectionRequest
1053 
1057  public class CreateProjectionResponse : KineticaData
1058  {
1062  public struct Info
1063  {
1065  public const string COUNT = "count";
1066 
1069  public const string QUALIFIED_PROJECTION_NAME = "qualified_projection_name";
1070  } // end struct Info
1071 
1075  public string projection_name { get; set; }
1076 
1093  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1094  } // end class CreateProjectionResponse
1095 } // end namespace kinetica
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 JOIN_WINDOW_FUNCTIONS_THRESHOLD
If the projection is greater than this width (in bytes), then window functions which require a reshar...
const string OFFSET
The number of initial results to skip (this can be useful for paging through the results).
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 TTL
Sets the TTL of the projection specified in projection_name.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string JOIN_WINDOW_FUNCTIONS
If set, window functions which require a reshard will be computed separately and joined back together...
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.
IList< string > column_names
List of columns from table_name to be included in the projection.
IDictionary< string, string > options
Optional parameters.
const string COMPRESSION_CODEC
The default compression codec for the projection's columns.
const string IS_REPLICATED
If TRUE then the projection will be replicated even if the source table is not.
const string CHUNK_COLUMN_MAX_MEMORY
Indicates the target maximum data size for each column in a chunk to be used for this projection.
string projection_name
Value of projection_name.
CreateProjectionRequest()
Constructs a CreateProjectionRequest object with default parameters.
const string LIST
Use list partitioning.
const string VIEW_ID
ID of view of which this projection is a member.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
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 HASH
Use hash partitioning.
const string RANGE
Use range partitioning.
const string ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
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 COUNT
Number of records in the final table
IDictionary< string, string > info
Additional information.
const string QUALIFIED_PROJECTION_NAME
The fully qualified name of the projection (i.e.
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this projection.
const string PARTITION_TYPE
Partitioning scheme to use.
string table_name
Name of the existing table on which the projection is to be applied, in [schema_name.
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.
string projection_name
Name of the projection to be created, in [schema_name.
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 SERIES
Use series partitioning.
const string PERSIST
If TRUE, then the projection specified in projection_name will be persisted and will not expire unles...
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of projection_name and us...
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
const string EXPRESSION
An optional filter expression to be applied to the source table prior to the projection.