A set of string constants for the parameter AlterTableRequest.action. More...

Static Public Attributes
const string	CREATE\_INDEX = "create\_index"
	Creates a column (attribute) index, low-cardinality index, chunk skip index, geospatial index, CAGRA index, or HNSW index (depending on the specified INDEX\_TYPE), on the column name specified in AlterTableRequest.\_value.

const string	REFRESH\_INDEX = "refresh\_index"
	Refreshes an index identified by INDEX\_TYPE, on the column name specified in AlterTableRequest.\_value.

const string	DELETE\_INDEX = "delete\_index"
	Deletes a column (attribute) index, low-cardinality index, chunk skip index, geospatial index, CAGRA index, or HNSW index (depending on the specified INDEX\_TYPE), on the column name specified in AlterTableRequest.\_value.

const string	MOVE\_TO\_COLLECTION = "move\_to\_collection"
	\[DEPRECATED–please use MOVE\_TO\_SCHEMA and use Kinetica.createSchema to create the schema if non-existent] Moves a table or view into a schema named AlterTableRequest.\_value.

const string	MOVE\_TO\_SCHEMA = "move\_to\_schema"
	Moves a table or view into a schema named AlterTableRequest.\_value.

const string	PROTECTED = "protected"
	No longer used.

const string	RENAME\_TABLE = "rename\_table"
	Renames a table or view to AlterTableRequest.\_value.

const string	TTL = "ttl"
	Sets the time-to-live in minutes of the table or view specified in AlterTableRequest.table\_name.

const string	ADD\_COMMENT = "add\_comment"
	Adds the comment specified in AlterTableRequest.\_value to the table specified in AlterTableRequest.table\_name.

const string	ADD\_COLUMN = "add\_column"
	Adds the column specified in AlterTableRequest.\_value to the table specified in AlterTableRequest.table\_name.

const string	CHANGE\_COLUMN = "change\_column"
	Changes type and properties of the column specified in AlterTableRequest.\_value.

const string	DELETE\_COLUMN = "delete\_column"
	Deletes the column specified in AlterTableRequest.\_value from the table specified in AlterTableRequest.table\_name.

const string	SET\_DEFAULT = "set\_default"
	Sets or replaces the default value expression for the column specified in AlterTableRequest.\_value.

const string	DELETE\_DEFAULT = "delete\_default"
	Removes the default value expression from the column specified in AlterTableRequest.\_value.

const string	CREATE\_FOREIGN\_KEY = "create\_foreign\_key"
	Creates a foreign key specified in AlterTableRequest.\_value using the format '(source\_column\_name \[, ...]) references target\_table\_name(primary\_key\_column\_name \[, ...]) \[as foreign\_key\_name]'.

const string	DELETE\_FOREIGN\_KEY = "delete\_foreign\_key"
	Deletes a foreign key.

const string	ADD\_PARTITION = "add\_partition"
	Adds the partition specified in AlterTableRequest.\_value, to either a range-partitioned or manual list-partitioned table.

const string	REMOVE\_PARTITION = "remove\_partition"
	Removes the partition specified in AlterTableRequest.\_value (and relocates all of its data to the default partition) from either a range-partitioned or manual list-partitioned table.

const string	DELETE\_PARTITION = "delete\_partition"
	Deletes the partition specified in AlterTableRequest.\_value (and all of its data) from either a range-partitioned or manual list-partitioned table.

const string	SET\_GLOBAL\_ACCESS\_MODE = "set\_global\_access\_mode"
	Sets the global access mode (i.e.

const string	REFRESH = "refresh"
	For a materialized view, replays all the table creation commands required to create the view.

const string	SET\_REFRESH\_METHOD = "set\_refresh\_method"
	For a materialized view, sets the method by which the view is refreshed to the method specified in AlterTableRequest.\_value - one of 'manual', 'periodic', or 'on\_change'.

const string	SET\_REFRESH\_START\_TIME = "set\_refresh\_start\_time"
	Sets the time to start periodic refreshes of this materialized view to the datetime string specified in AlterTableRequest.\_value with format 'YYYY-MM-DD HH:MM:SS'.

const string	SET\_REFRESH\_STOP\_TIME = "set\_refresh\_stop\_time"
	Sets the time to stop periodic refreshes of this materialized view to the datetime string specified in AlterTableRequest.\_value with format 'YYYY-MM-DD HH:MM:SS'.

const string	SET\_REFRESH\_PERIOD = "set\_refresh\_period"
	Sets the time interval in seconds at which to refresh this materialized view to the value specified in AlterTableRequest.\_value.

const string	SET\_REFRESH\_SPAN = "set\_refresh\_span"
	Sets the future time-offset(in seconds) for the view refresh to stop.

const string	SET\_REFRESH\_EXECUTE\_AS = "set\_refresh\_execute\_as"
	Sets the user name to refresh this materialized view to the value specified in AlterTableRequest.\_value.

const string	REMOVE\_TEXT\_SEARCH\_ATTRIBUTES = "remove\_text\_search\_attributes"
	Removes text search attribute from all columns.

const string	REMOVE\_SHARD\_KEYS = "remove\_shard\_keys"
	Removes the shard key property from all columns, so that the table will be considered randomly sharded.

const string	SET\_STRATEGY\_DEFINITION = "set\_strategy\_definition"
	Sets the tier strategy for the table and its columns to the one specified in AlterTableRequest.\_value, replacing the existing tier strategy in its entirety.

const string	CANCEL\_DATASOURCE\_SUBSCRIPTION = "cancel\_datasource\_subscription"
	Permanently unsubscribe a data source that is loading continuously as a stream.

const string	DROP\_DATASOURCE\_SUBSCRIPTION = "drop\_datasource\_subscription"
	Permanently delete a cancelled data source subscription.

const string	PAUSE\_DATASOURCE\_SUBSCRIPTION = "pause\_datasource\_subscription"
	Temporarily unsubscribe a data source that is loading continuously as a stream.

const string	RESUME\_DATASOURCE\_SUBSCRIPTION = "resume\_datasource\_subscription"
	Resubscribe to a paused data source subscription.

const string	CHANGE\_OWNER = "change\_owner"
	Change the owner resource group of the table.

const string	SET\_LOAD\_VECTORS\_POLICY = "set\_load\_vectors\_policy"
	Set startup data loading scheme for the table; see description of 'load\_vectors\_policy' in Kinetica.createTable for possible values for AlterTableRequest.\_value.

const string	SET\_BUILD\_PK\_INDEX\_POLICY = "set\_build\_pk\_index\_policy"
	Set startup primary key generation scheme for the table; see description of 'build\_pk\_index\_policy' in Kinetica.createTable for possible values for AlterTableRequest.\_value.

const string	SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY = "set\_build\_materialized\_view\_policy"
	Set startup rebuilding scheme for the materialized view; see description of 'build\_materialized\_view\_policy' in Kinetica.createMaterializedView for possible values for AlterTableRequest.\_value.

Detailed Description

A set of string constants for the parameter AlterTableRequest.action.

Modification operation to be applied.

Definition at line 59 of file AlterTable.cs.

Member Data Documentation

◆ ADD\_COLUMN

const string kinetica.AlterTableRequest.Action.ADD\_COLUMN = "add\_column"

static

Adds the column specified in AlterTableRequest.\_value to the table specified in AlterTableRequest.table\_name.

Use COLUMN\_TYPE and COLUMN\_PROPERTIES in AlterTableRequest.options to set the column's type and properties, respectively.

Definition at line 161 of file AlterTable.cs.

◆ ADD\_COMMENT

const string kinetica.AlterTableRequest.Action.ADD\_COMMENT = "add\_comment"

static

Adds the comment specified in AlterTableRequest.\_value to the table specified in AlterTableRequest.table\_name.

Use COLUMN\_NAME to set the comment for a column.

Definition at line 150 of file AlterTable.cs.

◆ ADD\_PARTITION

const string kinetica.AlterTableRequest.Action.ADD\_PARTITION = "add\_partition"

static

Adds the partition specified in AlterTableRequest.\_value, to either a range-partitioned or manual list-partitioned table.

Definition at line 218 of file AlterTable.cs.

◆ CANCEL\_DATASOURCE\_SUBSCRIPTION

const string kinetica.AlterTableRequest.Action.CANCEL\_DATASOURCE\_SUBSCRIPTION = "cancel\_datasource\_subscription"

static

Permanently unsubscribe a data source that is loading continuously as a stream.

The data source can be Kafka / S3 / Azure / GCS.

Definition at line 320 of file AlterTable.cs.

◆ CHANGE\_COLUMN

const string kinetica.AlterTableRequest.Action.CHANGE\_COLUMN = "change\_column"

static

Changes type and properties of the column specified in AlterTableRequest.\_value.

Use COLUMN\_TYPE and COLUMN\_PROPERTIES in AlterTableRequest.options to set the column's type and properties, respectively. Note that primary key and/or shard key columns cannot be changed. All unchanging column properties must be listed for the change to take place, e.g., to add dictionary encoding to an existing 'char4' column, both 'char4' and 'dict' must be specified in the AlterTableRequest.options map.

Definition at line 176 of file AlterTable.cs.

◆ CHANGE\_OWNER

const string kinetica.AlterTableRequest.Action.CHANGE\_OWNER = "change\_owner"

static

Change the owner resource group of the table.

Definition at line 339 of file AlterTable.cs.

◆ CREATE\_FOREIGN\_KEY

const string kinetica.AlterTableRequest.Action.CREATE\_FOREIGN\_KEY = "create\_foreign\_key"

static

Creates a foreign key specified in AlterTableRequest.\_value using the format '(source\_column\_name \[, ...]) references target\_table\_name(primary\_key\_column\_name \[, ...]) \[as foreign\_key\_name]'.

Definition at line 203 of file AlterTable.cs.

◆ CREATE\_INDEX

const string kinetica.AlterTableRequest.Action.CREATE\_INDEX = "create\_index"

static

Creates a column (attribute) index, low-cardinality index, chunk skip index, geospatial index, CAGRA index, or HNSW index (depending on the specified INDEX\_TYPE), on the column name specified in AlterTableRequest.\_value.

If this column already has the specified index, an error will be returned.

Definition at line 78 of file AlterTable.cs.

◆ DELETE\_COLUMN

const string kinetica.AlterTableRequest.Action.DELETE\_COLUMN = "delete\_column"

static

Deletes the column specified in AlterTableRequest.\_value from the table specified in AlterTableRequest.table\_name.

Definition at line 181 of file AlterTable.cs.

◆ DELETE\_DEFAULT

const string kinetica.AlterTableRequest.Action.DELETE\_DEFAULT = "delete\_default"

static

Removes the default value expression from the column specified in AlterTableRequest.\_value.

Other column properties are preserved.

Definition at line 195 of file AlterTable.cs.

◆ DELETE\_FOREIGN\_KEY

const string kinetica.AlterTableRequest.Action.DELETE\_FOREIGN\_KEY = "delete\_foreign\_key"

static

Deletes a foreign key.

The AlterTableRequest.\_value should be the foreign\_key\_name specified when creating the key or the complete string used to define it.

Definition at line 210 of file AlterTable.cs.

◆ DELETE\_INDEX

const string kinetica.AlterTableRequest.Action.DELETE\_INDEX = "delete\_index"

static

Deletes a column (attribute) index, low-cardinality index, chunk skip index, geospatial index, CAGRA index, or HNSW index (depending on the specified INDEX\_TYPE), on the column name specified in AlterTableRequest.\_value.

If this column does not have the specified index, an error will be returned.

Definition at line 105 of file AlterTable.cs.

◆ DELETE\_PARTITION

const string kinetica.AlterTableRequest.Action.DELETE\_PARTITION = "delete\_partition"

static

Deletes the partition specified in AlterTableRequest.\_value (and all of its data) from either a range-partitioned or manual list-partitioned table.

Definition at line 235 of file AlterTable.cs.

◆ DROP\_DATASOURCE\_SUBSCRIPTION

const string kinetica.AlterTableRequest.Action.DROP\_DATASOURCE\_SUBSCRIPTION = "drop\_datasource\_subscription"

static

Permanently delete a cancelled data source subscription.

Definition at line 324 of file AlterTable.cs.

◆ MOVE\_TO\_COLLECTION

const string kinetica.AlterTableRequest.Action.MOVE\_TO\_COLLECTION = "move\_to\_collection"

static

\[DEPRECATED–please use MOVE\_TO\_SCHEMA and use Kinetica.createSchema to create the schema if non-existent] Moves a table or view into a schema named AlterTableRequest.\_value.

If the schema provided is non-existent, it will be automatically created.

Definition at line 115 of file AlterTable.cs.

◆ MOVE\_TO\_SCHEMA

const string kinetica.AlterTableRequest.Action.MOVE\_TO\_SCHEMA = "move\_to\_schema"

static

Moves a table or view into a schema named AlterTableRequest.\_value.

If the schema provided is nonexistent, an error will be thrown. If AlterTableRequest.\_value is empty, then the table or view will be placed in the user's default schema.

Definition at line 123 of file AlterTable.cs.

◆ PAUSE\_DATASOURCE\_SUBSCRIPTION

const string kinetica.AlterTableRequest.Action.PAUSE\_DATASOURCE\_SUBSCRIPTION = "pause\_datasource\_subscription"

static

Temporarily unsubscribe a data source that is loading continuously as a stream.

The data source can be Kafka / S3 / Azure / GCS.

Definition at line 330 of file AlterTable.cs.

◆ PROTECTED

const string kinetica.AlterTableRequest.Action.PROTECTED = "protected"

static

No longer used.

Previously set whether the given AlterTableRequest.table\_name should be protected or not. The AlterTableRequest.\_value would have been either 'true' or 'false'.

Definition at line 130 of file AlterTable.cs.

◆ REFRESH

const string kinetica.AlterTableRequest.Action.REFRESH = "refresh"

static

For a materialized view, replays all the table creation commands required to create the view.

For an external table, reloads all data in the table from its associated source files or data source.

Definition at line 252 of file AlterTable.cs.

◆ REFRESH\_INDEX

const string kinetica.AlterTableRequest.Action.REFRESH\_INDEX = "refresh\_index"

static

Refreshes an index identified by INDEX\_TYPE, on the column name specified in AlterTableRequest.\_value.

Currently applicable only to CAGRA indices.

Definition at line 86 of file AlterTable.cs.

◆ REMOVE\_PARTITION

const string kinetica.AlterTableRequest.Action.REMOVE\_PARTITION = "remove\_partition"

static

Removes the partition specified in AlterTableRequest.\_value (and relocates all of its data to the default partition) from either a range-partitioned or manual list-partitioned table.

Definition at line 227 of file AlterTable.cs.

◆ REMOVE\_SHARD\_KEYS

const string kinetica.AlterTableRequest.Action.REMOVE\_SHARD\_KEYS = "remove\_shard\_keys"

static

Removes the shard key property from all columns, so that the table will be considered randomly sharded.

The data is not moved. The AlterTableRequest.\_value is ignored.

Definition at line 308 of file AlterTable.cs.

◆ REMOVE\_TEXT\_SEARCH\_ATTRIBUTES

const string kinetica.AlterTableRequest.Action.REMOVE\_TEXT\_SEARCH\_ATTRIBUTES = "remove\_text\_search\_attributes"

static

Removes text search attribute from all columns.

Definition at line 302 of file AlterTable.cs.

◆ RENAME\_TABLE

const string kinetica.AlterTableRequest.Action.RENAME\_TABLE = "rename\_table"

static

Renames a table or view to AlterTableRequest.\_value.

Has the same naming restrictions as tables.

Definition at line 137 of file AlterTable.cs.

◆ RESUME\_DATASOURCE\_SUBSCRIPTION

const string kinetica.AlterTableRequest.Action.RESUME\_DATASOURCE\_SUBSCRIPTION = "resume\_datasource\_subscription"

static

Resubscribe to a paused data source subscription.

The data source can be Kafka / S3 / Azure / GCS.

Definition at line 336 of file AlterTable.cs.

◆ SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY

const string kinetica.AlterTableRequest.Action.SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY = "set\_build\_materialized\_view\_policy"

static

Set startup rebuilding scheme for the materialized view; see description of 'build\_materialized\_view\_policy' in Kinetica.createMaterializedView for possible values for AlterTableRequest.\_value.

Definition at line 360 of file AlterTable.cs.

◆ SET\_BUILD\_PK\_INDEX\_POLICY

const string kinetica.AlterTableRequest.Action.SET\_BUILD\_PK\_INDEX\_POLICY = "set\_build\_pk\_index\_policy"

static

Set startup primary key generation scheme for the table; see description of 'build\_pk\_index\_policy' in Kinetica.createTable for possible values for AlterTableRequest.\_value.

Definition at line 353 of file AlterTable.cs.

◆ SET\_DEFAULT

const string kinetica.AlterTableRequest.Action.SET\_DEFAULT = "set\_default"

static

Sets or replaces the default value expression for the column specified in AlterTableRequest.\_value.

The new default is taken from ADD\_COLUMN\_EXPRESSION. Existing properties on the column are preserved.

Definition at line 189 of file AlterTable.cs.

◆ SET\_GLOBAL\_ACCESS\_MODE

const string kinetica.AlterTableRequest.Action.SET\_GLOBAL\_ACCESS\_MODE = "set\_global\_access\_mode"

static

Sets the global access mode (i.e.

locking) for the table specified in AlterTableRequest.table\_name.

Specify the access mode in AlterTableRequest.\_value. Valid modes are 'no\_access', 'read\_only', 'write\_only' and 'read\_write'.

Definition at line 242 of file AlterTable.cs.

◆ SET\_LOAD\_VECTORS\_POLICY

const string kinetica.AlterTableRequest.Action.SET\_LOAD\_VECTORS\_POLICY = "set\_load\_vectors\_policy"

static

Set startup data loading scheme for the table; see description of 'load\_vectors\_policy' in Kinetica.createTable for possible values for AlterTableRequest.\_value.

Definition at line 346 of file AlterTable.cs.

◆ SET\_REFRESH\_EXECUTE\_AS

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_EXECUTE\_AS = "set\_refresh\_execute\_as"

static

Sets the user name to refresh this materialized view to the value specified in AlterTableRequest.\_value.

Definition at line 298 of file AlterTable.cs.

◆ SET\_REFRESH\_METHOD

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_METHOD = "set\_refresh\_method"

static

For a materialized view, sets the method by which the view is refreshed to the method specified in AlterTableRequest.\_value - one of 'manual', 'periodic', or 'on\_change'.

For an external table, sets the method by which the table is refreshed to the method specified in AlterTableRequest.\_value - either 'manual' or 'on\_start'.

Definition at line 264 of file AlterTable.cs.

◆ SET\_REFRESH\_PERIOD

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_PERIOD = "set\_refresh\_period"

static

Sets the time interval in seconds at which to refresh this materialized view to the value specified in AlterTableRequest.\_value.

Also, sets the refresh method to periodic if not already set.

Definition at line 288 of file AlterTable.cs.

◆ SET\_REFRESH\_SPAN

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_SPAN = "set\_refresh\_span"

static

Sets the future time-offset(in seconds) for the view refresh to stop.

Definition at line 292 of file AlterTable.cs.

◆ SET\_REFRESH\_START\_TIME

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_START\_TIME = "set\_refresh\_start\_time"

static

Sets the time to start periodic refreshes of this materialized view to the datetime string specified in AlterTableRequest.\_value with format 'YYYY-MM-DD HH:MM:SS'.

Subsequent refreshes occur at the specified time + N \* the refresh period.

Definition at line 273 of file AlterTable.cs.

◆ SET\_REFRESH\_STOP\_TIME

const string kinetica.AlterTableRequest.Action.SET\_REFRESH\_STOP\_TIME = "set\_refresh\_stop\_time"

static

Sets the time to stop periodic refreshes of this materialized view to the datetime string specified in AlterTableRequest.\_value with format 'YYYY-MM-DD HH:MM:SS'.

Definition at line 280 of file AlterTable.cs.

◆ SET\_STRATEGY\_DEFINITION

const string kinetica.AlterTableRequest.Action.SET\_STRATEGY\_DEFINITION = "set\_strategy\_definition"

static

Sets the tier strategy for the table and its columns to the one specified in AlterTableRequest.\_value, replacing the existing tier strategy in its entirety.

Definition at line 314 of file AlterTable.cs.

◆ TTL

const string kinetica.AlterTableRequest.Action.TTL = "ttl"

static

Sets the time-to-live in minutes of the table or view specified in AlterTableRequest.table\_name.

Definition at line 142 of file AlterTable.cs.

The documentation for this struct was generated from the following files:

\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/AlterTable.cs
Kinetica/Protocol/AlterTable.cs

Static Public Attributes

Detailed Description

Member Data Documentation

◆ ADD\_COLUMN

◆ ADD\_COMMENT

◆ ADD\_PARTITION

◆ CANCEL\_DATASOURCE\_SUBSCRIPTION

◆ CHANGE\_COLUMN

◆ CHANGE\_OWNER

◆ CREATE\_FOREIGN\_KEY

◆ CREATE\_INDEX

◆ DELETE\_COLUMN

◆ DELETE\_DEFAULT

◆ DELETE\_FOREIGN\_KEY

◆ DELETE\_INDEX

◆ DELETE\_PARTITION

◆ DROP\_DATASOURCE\_SUBSCRIPTION

◆ MOVE\_TO\_COLLECTION

◆ MOVE\_TO\_SCHEMA

◆ PAUSE\_DATASOURCE\_SUBSCRIPTION

◆ PROTECTED

◆ REFRESH

◆ REFRESH\_INDEX

◆ REMOVE\_PARTITION

◆ REMOVE\_SHARD\_KEYS

◆ REMOVE\_TEXT\_SEARCH\_ATTRIBUTES

◆ RENAME\_TABLE

◆ RESUME\_DATASOURCE\_SUBSCRIPTION

◆ SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY

◆ SET\_BUILD\_PK\_INDEX\_POLICY

◆ SET\_DEFAULT

◆ SET\_GLOBAL\_ACCESS\_MODE

◆ SET\_LOAD\_VECTORS\_POLICY

◆ SET\_REFRESH\_EXECUTE\_AS

◆ SET\_REFRESH\_METHOD

◆ SET\_REFRESH\_PERIOD

◆ SET\_REFRESH\_SPAN

◆ SET\_REFRESH\_START\_TIME

◆ SET\_REFRESH\_STOP\_TIME

◆ SET\_STRATEGY\_DEFINITION

◆ TTL