7 using System.Collections.Generic;
59 public class AlterTableRequest : KineticaData
134 public const string PROTECTED =
"protected";
146 public const string TTL =
"ttl";
162 public const string ADD_COLUMN =
"add_column";
240 public const string REFRESH =
"refresh";
352 public struct Options
354 public const string ACTION =
"action";
356 public const string TABLE_NAME =
"table_name";
405 public const string TRUE =
"true";
410 public const string FALSE =
"false";
505 public const string INDEX_TYPE =
"index_type";
510 public const string COLUMN =
"column";
521 public const string CHUNK_SKIP =
"chunk_skip";
526 public const string GEOSPATIAL =
"geospatial";
533 public const string CAGRA =
"cagra";
539 public const string HNSW =
"hnsw";
925 public string action {
get;
set; }
942 public string _value {
get;
set; }
1135 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
1732 IDictionary<string, string>
options =
null)
1735 this.action =
action ??
"";
1736 this._value =
_value ??
"";
1744 public class AlterTableResponse : KineticaData
1750 public string action {
get;
set; }
1754 public string _value {
get;
set; }
1758 public string type_id {
get;
set; }
1766 public IDictionary<string, IList<string>>
properties {
get;
set; } =
new Dictionary<string, IList<string>>();
1770 public string label {
get;
set; }
1773 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string SET_REFRESH_STOP_TIME
Sets the time to stop periodic refreshes of this materialized view to the datetime string specified i...
const string MOVE_TO_SCHEMA
Moves a table or view into a schema named _value.
AlterTableRequest(string table_name, string action, string _value, IDictionary< string, string > options=null)
Constructs an AlterTableRequest object with the specified parameters.
string table_name
Table on which the operation was performed.
const string DELETE_COLUMN
Deletes the column specified in _value from the table specified in table_name.
const string CREATE_INDEX
Creates a column (attribute) index, low-cardinality index, chunk skip index, geospatial index,...
const string COPY_VALUES_FROM_COLUMN
[DEPRECATED–please use ADD_COLUMN_EXPRESSION instead.
const string HNSW
Create or delete an HNSW index on a vector column
const string DELETE_INDEX
Deletes a column (attribute) index, low-cardinality index, chunk skip index, geospatial index,...
const string COLUMN
Create or delete a column (attribute) index.
const string SET_STRATEGY_DEFINITION
Sets the tier strategy for the table and its columns to the one specified in _value,...
const string GEOSPATIAL
Create or delete a geospatial index
string action
Modification operation to be applied.
const string REMOVE_SHARD_KEYS
Removes the shard key property from all columns, so that the table will be considered randomly sharde...
const string COLUMN_DEFAULT_VALUE
When adding a column, set a default value for existing records.
const string SET_GLOBAL_ACCESS_MODE
Sets the global access mode (i.e.
const string DELETE_PARTITION
Deletes the partition specified in _value (and all of its data) from either a range-partitioned or ma...
const string COLUMN_TYPE
When adding or changing a column, set the column type (strings, separated by a comma: int,...
const string ADD_PARTITION
Adds the partition specified in _value, to either a range-partitioned or manual list-partitioned tabl...
const string REFRESH
For a materialized view, replays all the table creation commands required to create the view.
const string VALIDATE_CHANGE_COLUMN
When changing a column, validate the change before applying it (or not).
IDictionary< string, string > options
Optional parameters.
const string CREATE_FOREIGN_KEY
Creates a foreign key specified in _value using the format '(source_column_name [,...
const string RESUME_DATASOURCE_SUBSCRIPTION
Resubscribe to a paused data source subscription.
string action
Modification operation that was performed.
const string COLUMN_PROPERTIES
When adding or changing a column, set the column properties (strings, separated by a comma: data,...
AlterTableRequest()
Constructs an AlterTableRequest object with default parameters.
const string SET_REFRESH_METHOD
For a materialized view, sets the method by which the view is refreshed to the method specified in _v...
const string REMOVE_TEXT_SEARCH_ATTRIBUTES
Removes text search attribute from all columns.
const string SET_LOAD_VECTORS_POLICY
Set startup data loading scheme for the table; see description of 'load_vectors_policy' in Kinetica....
const string CANCEL_DATASOURCE_SUBSCRIPTION
Permanently unsubscribe a data source that is loading continuously as a stream.
const string SET_REFRESH_EXECUTE_AS
Sets the user name to refresh this materialized view to the value specified in _value.
string label
return the type label (when changing a table, a new type may be created)
const string DELETE_FOREIGN_KEY
Deletes a foreign key.
const string LOW_CARDINALITY
Create a low-cardinality column (attribute) index.
const string SET_REFRESH_SPAN
Sets the future time-offset(in seconds) for the view refresh to stop.
const string REMOVE_PARTITION
Removes the partition specified in _value (and relocates all of its data to the default partition) fr...
const string FALSE
Don't reset the timer; expiration countdown will continue from where it is, as if the table had not b...
const string ADD_COLUMN
Adds the column specified in _value to the table specified in table_name.
string _value
The value of the modification that was performed.
string type_id
return the type_id (when changing a table, a new type may be created)
const string INDEX_OPTIONS
Options to use when creating an index, in the format "key: value [, key: value [, ....
const string SET_REFRESH_START_TIME
Sets the time to start periodic refreshes of this materialized view to the datetime string specified ...
const string MOVE_TO_COLLECTION
[DEPRECATED–please use MOVE_TO_SCHEMA and use Kinetica.createSchema to create the schema if non-exist...
const string CHUNK_SKIP
Create or delete a chunk skip index.
IDictionary< string, IList< string > > properties
return the type properties (when changing a table, a new type may be created)
const string SET_REFRESH_PERIOD
Sets the time interval in seconds at which to refresh this materialized view to the value specified i...
const string PROTECTED
No longer used.
const string UPDATE_LAST_ACCESS_TIME
Indicates whether the time-to-live (TTL) expiration countdown timer should be reset to the table's TT...
string table_name
Table on which the operation will be performed, in [schema_name.
const string ADD_COMMENT
Adds the comment specified in _value to the table specified in table_name.
const string CHANGE_COLUMN
Changes type and properties of the column specified in _value.
const string CHANGE_OWNER
Change the owner resource group of the table.
const string RENAME_COLUMN
When changing a column, specify new column name.
const string TTL
Sets the time-to-live in minutes of the table or view specified in table_name.
string _value
The value of the modification, depending on action.
const string SET_BUILD_PK_INDEX_POLICY
Set startup primary key generation scheme for the table; see description of 'build_pk_index_policy' i...
const string TRUE
Reset the expiration countdown timer to the table's configured TTL.
const string RENAME_TABLE
Renames a table or view to _value.
const string SET_BUILD_MATERIALIZED_VIEW_POLICY
Set startup rebuilding scheme for the materialized view; see description of 'build_materialized_view_...
const string PAUSE_DATASOURCE_SUBSCRIPTION
Temporarily unsubscribe a data source that is loading continuously as a stream.
const string REFRESH_INDEX
Refreshes an index identified by INDEX_TYPE, on the column name specified in _value.
const string STRATEGY_DEFINITION
Optional parameter for specifying the tier strategy for the table and its columns when action is SET_...
IDictionary< string, string > info
Additional information.
string type_definition
return the type_definition (when changing a table, a new type may be created)
const string CAGRA
Create or delete a CAGRA index on a vector column
const string INDEX_TYPE
Type of index to create, when action is CREATE_INDEX; to refresh, when action is REFRESH_INDEX; or to...
const string ADD_COLUMN_EXPRESSION
When adding a column, an optional expression to use for the new column's values.