Kinetica   C#   API  Version 7.2.3.0
CreateTable.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 {
54  public class CreateTableRequest : KineticaData
55  {
59  public struct Options
60  {
75  public const string NO_ERROR_IF_EXISTS = "no_error_if_exists";
76 
77  public const string TRUE = "true";
78  public const string FALSE = "false";
79 
94  public const string CREATE_TEMP_TABLE = "create_temp_table";
95 
103  public const string COLLECTION_NAME = "collection_name";
104 
120  public const string IS_COLLECTION = "is_collection";
121 
137  public const string IS_REPLICATED = "is_replicated";
138 
145  public const string FOREIGN_KEYS = "foreign_keys";
146 
150  public const string FOREIGN_SHARD_KEY = "foreign_shard_key";
151 
188  public const string PARTITION_TYPE = "partition_type";
189 
193  public const string RANGE = "RANGE";
194 
198  public const string INTERVAL = "INTERVAL";
199 
203  public const string LIST = "LIST";
204 
208  public const string HASH = "HASH";
209 
213  public const string SERIES = "SERIES";
214 
220  public const string PARTITION_KEYS = "partition_keys";
221 
237  public const string PARTITION_DEFINITIONS = "partition_definitions";
238 
253  public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";
254 
258  public const string TTL = "ttl";
259 
262  public const string CHUNK_SIZE = "chunk_size";
263 
266  public const string CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory";
267 
270  public const string CHUNK_MAX_MEMORY = "chunk_max_memory";
271 
286  public const string IS_RESULT_TABLE = "is_result_table";
287 
291  public const string STRATEGY_DEFINITION = "strategy_definition";
292 
297  public const string COMPRESSION_CODEC = "compression_codec";
298 
327  public const string LOAD_VECTORS_POLICY = "load_vectors_policy";
328 
331  public const string ALWAYS = "always";
332 
335  public const string LAZY = "lazy";
336 
339  public const string ON_DEMAND = "on_demand";
340 
343  public const string SYSTEM = "system";
344 
374  public const string BUILD_PK_INDEX_POLICY = "build_pk_index_policy";
375  } // end struct Options
376 
387  public string table_name { get; set; }
388 
393  public string type_id { get; set; }
394 
758  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
759 
762  public CreateTableRequest() { }
763 
1146  string type_id,
1147  IDictionary<string, string> options = null)
1148  {
1149  this.table_name = table_name ?? "";
1150  this.type_id = type_id ?? "";
1151  this.options = options ?? new Dictionary<string, string>();
1152  } // end constructor
1153  } // end class CreateTableRequest
1154 
1158  public class CreateTableResponse : KineticaData
1159  {
1163  public struct Info
1164  {
1167  public const string QUALIFIED_TABLE_NAME = "qualified_table_name";
1168  } // end struct Info
1169 
1172  public string table_name { get; set; }
1173 
1176  public string type_id { get; set; }
1177 
1180  public bool is_collection { get; set; }
1181 
1193  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1194  } // end class CreateTableResponse
1195 } // end namespace kinetica
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
Definition: CreateTable.cs:291
const string SERIES
Use series partitioning.
Definition: CreateTable.cs:213
const string PARTITION_TYPE
Partitioning scheme to use.
Definition: CreateTable.cs:188
const string FOREIGN_KEYS
Semicolon-separated list of foreign keys, of the format '(source_column_name [, .....
Definition: CreateTable.cs:145
const string RANGE
Use range partitioning.
Definition: CreateTable.cs:193
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema as part of table_name and use Kinetica....
Definition: CreateTable.cs:103
string type_id
The type for the table, specified as either an existing table's numerical type ID (as returned by Kin...
Definition: CreateTable.cs:393
IDictionary< string, string > options
Optional parameters.
Definition: CreateTable.cs:758
const string HASH
Use hash partitioning.
Definition: CreateTable.cs:208
const string TTL
Sets the TTL of the table specified in table_name.
Definition: CreateTable.cs:258
const string IS_REPLICATED
Affects the distribution scheme for the table's data.
Definition: CreateTable.cs:137
const string COMPRESSION_CODEC
The default compression codec for this table's columns.
Definition: CreateTable.cs:297
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
Definition: CreateTable.cs:220
string table_name
Name of the table to be created, in [schema_name.
Definition: CreateTable.cs:387
const string NO_ERROR_IF_EXISTS
If TRUE, prevents an error from occurring if the table already exists and is of the given type.
Definition: CreateTable.cs:75
const string IS_RESULT_TABLE
Indicates whether the table is a memory-only table.
Definition: CreateTable.cs:286
const string LAZY
Generate the necessary primary key index data at start, and load the remainder lazily.
Definition: CreateTable.cs:335
IDictionary< string, string > info
Additional information.
const string ALWAYS
Generate as much primary key index data as possible before accepting requests.
Definition: CreateTable.cs:331
const string CHUNK_COLUMN_MAX_MEMORY
Indicates the target maximum data size for each column in a chunk to be used for this table.
Definition: CreateTable.cs:266
const string IS_AUTOMATIC_PARTITION
If TRUE, a new partition will be created for values which don't fall into an existing partition.
Definition: CreateTable.cs:253
const string QUALIFIED_TABLE_NAME
The fully qualified name of the new table (i.e.
string table_name
Value of table_name.
const string LOAD_VECTORS_POLICY
Set startup data loading scheme for the table.
Definition: CreateTable.cs:327
const string SYSTEM
Generate primary key index data using the system-configured default.
Definition: CreateTable.cs:343
const string IS_COLLECTION
[DEPRECATED–please use Kinetica.createSchema to create a schema instead] Indicates whether to create ...
Definition: CreateTable.cs:120
const string ON_DEMAND
Generate primary key index data as requests use it.
Definition: CreateTable.cs:339
const string CHUNK_MAX_MEMORY
Indicates the target maximum data size for all columns in a chunk to be used for this table.
Definition: CreateTable.cs:270
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this table.
Definition: CreateTable.cs:262
string type_id
Value of type_id.
CreateTableRequest()
Constructs a CreateTableRequest object with default parameters.
Definition: CreateTable.cs:762
const string INTERVAL
Use interval partitioning.
Definition: CreateTable.cs:198
bool is_collection
[DEPRECATED–this will always return false] Indicates if the created entity is a schema.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.
Definition: CreateTable.cs:237
const string FOREIGN_SHARD_KEY
Foreign shard key of the format 'source_column references shard_by_column from target_table(primary_k...
Definition: CreateTable.cs:150
const string LIST
Use list partitioning.
Definition: CreateTable.cs:203
CreateTableRequest(string table_name, string type_id, IDictionary< string, string > options=null)
Constructs a CreateTableRequest object with the specified parameters.
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 ...
Definition: CreateTable.cs:94
const string BUILD_PK_INDEX_POLICY
Set startup primary-key index generation scheme for the table.
Definition: CreateTable.cs:374