A set of string constants for the parameter create_table_options. More...

Public Attributes
const string	TYPE_ID = "type_id"
	ID of a currently registered type. More...

const string	NO_ERROR_IF_EXISTS = "no_error_if_exists"
	If TRUE, prevents an error from occurring if the table already exists and is of the given type. More...

const string	TRUE = "true"

const string	FALSE = "false"

const string	IS_REPLICATED = "is_replicated"
	Affects the distribution scheme for the table's data. More...

const string	FOREIGN_KEYS = "foreign_keys"
	Semicolon-separated list of foreign keys, of the format '(source_column_name [, ...]) references target_table_name(primary_key_column_name [, ...]) [as foreign_key_name]'. More...

const string	FOREIGN_SHARD_KEY = "foreign_shard_key"
	Foreign shard key of the format 'source_column references shard_by_column from target_table(primary_key_column)'. More...

const string	PARTITION_TYPE = "partition_type"
	Partitioning scheme to use. More...

const string	RANGE = "RANGE"
	Use range partitioning. More...

const string	INTERVAL = "INTERVAL"
	Use interval partitioning. More...

const string	LIST = "LIST"
	Use list partitioning. More...

const string	HASH = "HASH"
	Use hash partitioning. More...

const string	SERIES = "SERIES"
	Use series partitioning. More...

const string	PARTITION_KEYS = "partition_keys"
	Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by PARTITION_DEFINITIONS. More...

const string	PARTITION_DEFINITIONS = "partition_definitions"
	Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE. More...

const string	IS_AUTOMATIC_PARTITION = "is_automatic_partition"
	If TRUE, a new partition will be created for values which don't fall into an existing partition. More...

const string	TTL = "ttl"
	Sets the TTL of the table specified in table_name. More...

const string	CHUNK_SIZE = "chunk_size"
	Indicates the number of records per chunk to be used for this table. More...

const string	CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory"
	Indicates the target maximum data size for each column in a chunk to be used for this table. More...

const string	CHUNK_MAX_MEMORY = "chunk_max_memory"
	Indicates the target maximum data size for all columns in a chunk to be used for this table. More...

const string	IS_RESULT_TABLE = "is_result_table"
	Indicates whether the table is a memory-only table. More...

const string	STRATEGY_DEFINITION = "strategy_definition"
	The tier strategy for the table and its columns. More...

Detailed Description

A set of string constants for the parameter create_table_options.

Options used when creating the target table. Includes type to use. The other options match those in Kinetica.createTable

Definition at line 26 of file InsertRecordsFromPayload.cs.

Member Data Documentation

◆ CHUNK_COLUMN_MAX_MEMORY

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.CHUNK_COLUMN_MAX_MEMORY = "chunk_column_max_memory"

Indicates the target maximum data size for each column in a chunk to be used for this table.

Definition at line 209 of file InsertRecordsFromPayload.cs.

◆ CHUNK_MAX_MEMORY

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.CHUNK_MAX_MEMORY = "chunk_max_memory"

Indicates the target maximum data size for all columns in a chunk to be used for this table.

Definition at line 213 of file InsertRecordsFromPayload.cs.

◆ CHUNK_SIZE

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.CHUNK_SIZE = "chunk_size"

Indicates the number of records per chunk to be used for this table.

Definition at line 205 of file InsertRecordsFromPayload.cs.

◆ FALSE

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.FALSE = "false"

Definition at line 53 of file InsertRecordsFromPayload.cs.

◆ FOREIGN_KEYS

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.FOREIGN_KEYS = "foreign_keys"

Semicolon-separated list of foreign keys, of the format '(source_column_name [, ...]) references target_table_name(primary_key_column_name [, ...]) [as foreign_key_name]'.

Definition at line 80 of file InsertRecordsFromPayload.cs.

◆ FOREIGN_SHARD_KEY

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.FOREIGN_SHARD_KEY = "foreign_shard_key"

Foreign shard key of the format 'source_column references shard_by_column from target_table(primary_key_column)'.

Definition at line 85 of file InsertRecordsFromPayload.cs.

◆ HASH

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.HASH = "HASH"

Use hash partitioning.

Definition at line 148 of file InsertRecordsFromPayload.cs.

◆ INTERVAL

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.INTERVAL = "INTERVAL"

Use interval partitioning.

Definition at line 138 of file InsertRecordsFromPayload.cs.

◆ IS_AUTOMATIC_PARTITION

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.IS_AUTOMATIC_PARTITION = "is_automatic_partition"

If TRUE, a new partition will be created for values which don't fall into an existing partition.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 196 of file InsertRecordsFromPayload.cs.

◆ IS_REPLICATED

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.IS_REPLICATED = "is_replicated"

Affects the distribution scheme for the table's data.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 72 of file InsertRecordsFromPayload.cs.

◆ IS_RESULT_TABLE

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.IS_RESULT_TABLE = "is_result_table"

Indicates whether the table is a memory-only table.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 231 of file InsertRecordsFromPayload.cs.

◆ LIST

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.LIST = "LIST"

Use list partitioning.

Definition at line 143 of file InsertRecordsFromPayload.cs.

◆ NO_ERROR_IF_EXISTS

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.NO_ERROR_IF_EXISTS = "no_error_if_exists"

If TRUE, prevents an error from occurring if the table already exists and is of the given type.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 50 of file InsertRecordsFromPayload.cs.

◆ PARTITION_DEFINITIONS

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.PARTITION_DEFINITIONS = "partition_definitions"

Comma-separated list of partition definitions, whose format depends on the choice of PARTITION_TYPE.

See range partitioning, interval partitioning, list partitioning, hash partitioning, or series partitioning for example formats.

Definition at line 178 of file InsertRecordsFromPayload.cs.

◆ PARTITION_KEYS

const string kinetica.InsertRecordsFromPayloadRequest.CreateTableOptions.PARTITION_KEYS = "partition_keys"

Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by PARTITION_DEFINITIONS.

Definition at line 160 of file InsertRecordsFromPayload.cs.