A set of parameters for Kinetica.alterTable(string,string,string,IDictionary<string, string>). More...

Inheritance diagram for kinetica.AlterTableRequest:

Collaboration diagram for kinetica.AlterTableRequest:

Classes
struct	Action
	Modification operation to be applied Supported values: ALLOW_HOMOGENEOUS_TABLES: Sets whether homogeneous tables are allowed in the given collection. More...

struct	Options
	Optional parameters. More...

Public Member Functions
	AlterTableRequest ()
	Constructs an AlterTableRequest object with default parameters. More...

	AlterTableRequest (string table_name, string action, string _value, IDictionary< string, string > options=null)
	Constructs an AlterTableRequest object with the specified parameters. More...

Public Member Functions inherited from kinetica.KineticaData
	KineticaData (KineticaType type)
	Constructor from Kinetica Type More...

	KineticaData (System.Type type=null)
	Default constructor, with optional System.Type More...

object	Get (int fieldPos)
	Retrieve a specific property from this object More...

void	Put (int fieldPos, object fieldValue)
	Write a specific property to this object More...

Properties
string	table_name `[get, set]`
	Table on which the operation will be performed. More...

string	action `[get, set]`
	Modification operation to be applied Supported values: ALLOW_HOMOGENEOUS_TABLES: Sets whether homogeneous tables are allowed in the given collection. More...

string	_value `[get, set]`
	The value of the modification. More...

IDictionary< string, string >	options `[get, set]`
	Optional parameters. More...

Properties inherited from kinetica.KineticaData
Schema	Schema `[get]`
	Avro Schema for this class More...

Additional Inherited Members
Static Public Member Functions inherited from kinetica.KineticaData
static RecordSchema	SchemaFromType (System.Type t, KineticaType ktype=null)
	Create an Avro Schema from a System.Type and a KineticaType. More...

Detailed Description

A set of parameters for Kinetica.alterTable(string,string,string,IDictionary<string, string>).

Apply various modifications to a table, view, or collection. The available modifications include the following:
Create or delete an index on a particular column. This can speed up certain operations when using expressions containing equality or relational operators on indexed columns. This only applies to tables.
Set the time-to-live (TTL). This can be applied to tables, views, or collections. When applied to collections, every contained table & view that is not protected will have its TTL set to the given value.
Set the global access mode (i.e. locking) for a table. The mode can be set to 'no_access', 'read_only', 'write_only' or 'read_write'.
Change the protection mode to prevent or allow automatic expiration. This can be applied to tables, views, and collections.
Allow homogeneous tables within a collection.
Manage a table's columns–a column can be added, removed, or have its type and properties modified.
Set or unset compression for a column.

Definition at line 55 of file AlterTable.cs.

Constructor & Destructor Documentation

◆ AlterTableRequest() [1/2]

kinetica.AlterTableRequest.AlterTableRequest ( )

inline

Constructs an AlterTableRequest object with default parameters.

Definition at line 691 of file AlterTable.cs.

◆ AlterTableRequest() [2/2]

kinetica.AlterTableRequest.AlterTableRequest	(	string	table_name,
		string	action,
		string	_value,
		IDictionary< string, string >	options = `null`
	)

inline

Constructs an AlterTableRequest object with the specified parameters.

Parameters

table_name	Table on which the operation will be performed. Must be an existing table, view, or collection.
action	Modification operation to be applied Supported values: ALLOW_HOMOGENEOUS_TABLES: Sets whether homogeneous tables are allowed in the given collection. This action is only valid if is a collection. The must be either 'true' or 'false'. CREATE_INDEX: Creates an index on the column name specified in . If this column is already indexed, an error will be returned. DELETE_INDEX: Deletes an existing index on the column name specified in . If this column does not have indexing turned on, an error will be returned. MOVE_TO_COLLECTION: Moves a table into a collection . PROTECTED: Sets whether the given should be protected or not. The must be either 'true' or 'false'. RENAME_TABLE: Renames a table, view or collection to . Has the same naming restrictions as tables. TTL: Sets the TTL of the table, view, or collection specified in . ADD_COLUMN: Adds the column specified in to the table specified in . Use column_type and column_properties in to set the column's type and properties, respectively. CHANGE_COLUMN: Changes type and properties of the column specified in . Use column_type and column_properties in to set the column's type and properties, respectively. SET_COLUMN_COMPRESSION: Modifies the compression setting on the column specified in . DELETE_COLUMN: Deletes the column specified in from the table specified in . CREATE_FOREIGN_KEY: Creates a foreign key using the format 'source_column references target_table(primary_key_column) [ as <foreign_key_name> ]'. DELETE_FOREIGN_KEY: Deletes a foreign key. The should be the <foreign_key_name> specified when creating the key or the complete string used to define it. SET_GLOBAL_ACCESS_MODE: Sets the global access mode (i.e. locking) for the table specified in . Specify the access mode in . Valid modes are 'no_access', 'read_only', 'write_only' and 'read_write'.
_value	The value of the modification. May be a column name, 'true' or 'false', a TTL, or the global access mode depending on .
options	Optional parameters. COLUMN_DEFAULT_VALUE: When adding a column, set a default value for existing records. COLUMN_PROPERTIES: When adding or changing a column, set the column properties (strings, separated by a comma: data, store_only, text_search, char8, int8 etc). COLUMN_TYPE: When adding or changing a column, set the column type (strings, separated by a comma: int, double, string, null etc). COMPRESSION_TYPE: When setting column compression (set_column_compression for ), compression type to use: none (to use no compression) or a valid compression type. Supported values: NONE SNAPPY LZ4 LZ4HC The default value is SNAPPY. COPY_VALUES_FROM_COLUMN: When adding or changing a column, enter a column name from the same table being altered to use as a source for the column being added/changed; values will be copied from this source column into the new/modified column. RENAME_COLUMN: When changing a column, specify new column name. VALIDATE_CHANGE_COLUMN: When changing a column, validate the change before applying it. If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated. Supported values: TRUE: true FALSE: false The default value is TRUE.

Definition at line 920 of file AlterTable.cs.

Property Documentation

◆ _value

string kinetica.AlterTableRequest._value

getset

The value of the modification.

May be a column name, 'true' or 'false', a TTL, or the global access mode depending on .

Definition at line 593 of file AlterTable.cs.

◆ action

string kinetica.AlterTableRequest.action

getset

Modification operation to be applied Supported values:

ALLOW_HOMOGENEOUS_TABLES: Sets whether homogeneous tables are allowed in the given collection.

This action is only valid if is a collection. The must be either 'true' or 'false'. CREATE_INDEX: Creates an index on the column name specified in . If this column is already indexed, an error will be returned. DELETE_INDEX: Deletes an existing index on the column name specified in . If this column does not have indexing turned on, an error will be returned. MOVE_TO_COLLECTION: Moves a table into a collection . PROTECTED: Sets whether the given should be protected or not. The must be either 'true' or 'false'. RENAME_TABLE: Renames a table, view or collection to . Has the same naming restrictions as tables. TTL: Sets the TTL of the table, view, or collection specified in . ADD_COLUMN: Adds the column specified in to the table specified in . Use column_type and column_properties in to set the column's type and properties, respectively. CHANGE_COLUMN: Changes type and properties of the column specified in . Use column_type and column_properties in to set the column's type and properties, respectively. SET_COLUMN_COMPRESSION: Modifies the compression setting on the column specified in . DELETE_COLUMN: Deletes the column specified in from the table specified in . CREATE_FOREIGN_KEY: Creates a foreign key using the format 'source_column references target_table(primary_key_column) [ as <foreign_key_name> ]'. DELETE_FOREIGN_KEY: Deletes a foreign key. The should be the <foreign_key_name> specified when creating the key or the complete string used to define it. SET_GLOBAL_ACCESS_MODE: Sets the global access mode (i.e. locking) for the table specified in . Specify the access mode in . Valid modes are 'no_access', 'read_only', 'write_only' and 'read_write'.

Definition at line 588 of file AlterTable.cs.

◆ options

IDictionary<string, string> kinetica.AlterTableRequest.options

getset

Optional parameters.

COLUMN_DEFAULT_VALUE: When adding a column, set a default value for existing records.
COLUMN_PROPERTIES: When adding or changing a column, set the column properties (strings, separated by a comma: data, store_only, text_search, char8, int8 etc).
COLUMN_TYPE: When adding or changing a column, set the column type (strings, separated by a comma: int, double, string, null etc).
COMPRESSION_TYPE: When setting column compression (set_column_compression for ), compression type to use: none (to use no compression) or a valid compression type. Supported values:
- NONE
- SNAPPY
- LZ4
- LZ4HC
The default value is SNAPPY.
COPY_VALUES_FROM_COLUMN: When adding or changing a column, enter a column name from the same table being altered to use as a source for the column being added/changed; values will be copied from this source column into the new/modified column.
RENAME_COLUMN: When changing a column, specify new column name.
VALIDATE_CHANGE_COLUMN: When changing a column, validate the change before applying it. If true, then validate all values. A value too large (or too long) for the new type will prevent any change. If false, then when a value is too large or long, it will be truncated. Supported values:
- TRUE: true
- FALSE: false
The default value is TRUE.

Definition at line 686 of file AlterTable.cs.

◆ table_name

string kinetica.AlterTableRequest.table_name

getset

Table on which the operation will be performed.

Must be an existing table, view, or collection.

Definition at line 460 of file AlterTable.cs.

The documentation for this class was generated from the following file:

Kinetica/Protocol/AlterTable.cs

Classes

Public Member Functions

Properties

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ AlterTableRequest() [1/2]

◆ AlterTableRequest() [2/2]

Property Documentation

◆ _value

◆ action

◆ options

◆ table_name