Class AlterTableRequest

java.lang.Object

com.gpudb.protocol.AlterTableRequest

All Implemented Interfaces:

org.apache.avro.generic.GenericContainer, org.apache.avro.generic.IndexedRecord

public class AlterTableRequest extends Object implements org.apache.avro.generic.IndexedRecord

A set of parameters for GPUdb.alterTable.

Apply various modifications to a table or view. The available modifications include the following:

Manage a table's columns--a column can be added, removed, or have its type and properties modified, including whether it is dictionary encoded or not.

External tables cannot be modified except for their refresh method.

Create or delete a column, low-cardinality index, chunk skip, geospatial, CAGRA, or HNSW index. This can speed up certain operations when using expressions containing equality or relational operators on indexed columns. This only applies to tables.

Create or delete a foreign key on a particular column.

Manage a range-partitioned or a manual list-partitioned table's partitions.

Set (or reset) the tier strategy of a table or view.

Refresh and manage the refresh mode of a materialized view or an external table.

Set the time-to-live (TTL). This can be applied to tables or views.

Set the global access mode (i.e. locking) for a table. This setting trumps any role-based access controls that may be in place; e.g., a user with write access to a table marked read-only will not be able to insert records into it. The mode can be set to read-only, write-only, read/write, and no access.

Nested Class Summary

Nested Classes

Modifier and Type

Class

Description

static final class

AlterTableRequest.Action

A set of string constants for the AlterTableRequest parameter action.

static final class

AlterTableRequest.Options

A set of string constants for the AlterTableRequest parameter options.
Constructor Summary

Constructors

Constructor

Description

AlterTableRequest()

Constructs an AlterTableRequest object with default parameters.

AlterTableRequest(String tableName, String action, String value, Map\<String,String> options)

Constructs an AlterTableRequest object with the specified parameters.
Method Summary

Modifier and Type

Method

Description

boolean

equals(Object obj)

Object

get(int index)

This method supports the Avro framework and is not intended to be called directly by the user.

String

getAction()

Modification operation to be applied.

static org.apache.avro.Schema

getClassSchema()

This method supports the Avro framework and is not intended to be called directly by the user.

Map\<String,String>

getOptions()

Optional parameters.

org.apache.avro.Schema

getSchema()

This method supports the Avro framework and is not intended to be called directly by the user.

String

getTableName()

Table on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules.

String

getValue()

The value of the modification, depending on action.

int

hashCode()

void

put(int index, Object value)

This method supports the Avro framework and is not intended to be called directly by the user.

AlterTableRequest

setAction(String action)

Modification operation to be applied.

AlterTableRequest

setOptions(Map\<String,String> options)

Optional parameters.

AlterTableRequest

setTableName(String tableName)

Table on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules.

AlterTableRequest

setValue(String value)

The value of the modification, depending on action.

String

toString()

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Details
- AlterTableRequest
  
  public AlterTableRequest()
  
  Constructs an AlterTableRequest object with default parameters.
- AlterTableRequest
  
  public AlterTableRequest(String tableName, String action, String value, Map\<String,String> options)
  
  Constructs an AlterTableRequest object with the specified parameters.
  Parameters:
  
  tableName - Table on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules. Must be an existing table or view.
  
  action - Modification operation to be applied. Supported values:
  
  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 value. If this column already has the specified index, an error will be returned.
  
  REFRESH\_INDEX: Refreshes an index identified by INDEX\_TYPE, on the column name specified in value. Currently applicable only to CAGRA indices.
  
  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 value. If this column does not have the specified index, an error will be returned.
  
  MOVE\_TO\_COLLECTION: \[DEPRECATED--please use MOVE\_TO\_SCHEMA and use GPUdb.createSchema to create the schema if non-existent] Moves a table or view into a schema named value. If the schema provided is non-existent, it will be automatically created.
  
  MOVE\_TO\_SCHEMA: Moves a table or view into a schema named value. If the schema provided is nonexistent, an error will be thrown. If value is empty, then the table or view will be placed in the user's default schema.
  
  PROTECTED: No longer used. Previously set whether the given tableName should be protected or not. The value would have been either 'true' or 'false'.
  
  RENAME\_TABLE: Renames a table or view to value. Has the same naming restrictions as tables.
  
  TTL: Sets the time-to-live in minutes of the table or view specified in tableName.
  
  ADD\_COMMENT: Adds the comment specified in value to the table specified in tableName. Use COLUMN\_NAME to set the comment for a column.
  
  ADD\_COLUMN: Adds the column specified in value to the table specified in tableName. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in options to set the column's type and properties, respectively.
  
  CHANGE\_COLUMN: Changes type and properties of the column specified in value. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in 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 options map.
  
  DELETE\_COLUMN: Deletes the column specified in value from the table specified in tableName.
  
  SET\_DEFAULT: Sets or replaces the default value expression for the column specified in value. The new default is taken from ADD\_COLUMN\_EXPRESSION. Existing properties on the column are preserved.
  
  DELETE\_DEFAULT: Removes the default value expression from the column specified in value. Other column properties are preserved.
  
  CREATE\_FOREIGN\_KEY: Creates a foreign key specified in value using the format '(source\_column\_name \[, ...]) references target\_table\_name(primary\_key\_column\_name \[, ...]) \[as foreign\_key\_name]'.
  
  DELETE\_FOREIGN\_KEY: Deletes a foreign key. The value should be the foreign\_key\_name specified when creating the key or the complete string used to define it.
  
  ADD\_PARTITION: Adds the partition specified in value, to either a range-partitioned or manual list-partitioned table.
  
  REMOVE\_PARTITION: Removes the partition specified in value (and relocates all of its data to the default partition) from either a range-partitioned or manual list-partitioned table.
  
  DELETE\_PARTITION: Deletes the partition specified in value (and all of its data) from either a range-partitioned or manual list-partitioned table.
  
  SET\_GLOBAL\_ACCESS\_MODE: Sets the global access mode (i.e. locking) for the table specified in tableName. Specify the access mode in value. Valid modes are 'no\_access', 'read\_only', 'write\_only' and 'read\_write'.
  
  REFRESH: 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.
  
  SET\_REFRESH\_METHOD: For a materialized view, sets the method by which the view is refreshed to the method specified in 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 value - either 'manual' or 'on\_start'.
  
  SET\_REFRESH\_START\_TIME: Sets the time to start periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'. Subsequent refreshes occur at the specified time + N \* the refresh period.
  
  SET\_REFRESH\_STOP\_TIME: Sets the time to stop periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'.
  
  SET\_REFRESH\_PERIOD: Sets the time interval in seconds at which to refresh this materialized view to the value specified in value. Also, sets the refresh method to periodic if not already set.
  
  SET\_REFRESH\_SPAN: Sets the future time-offset(in seconds) for the view refresh to stop.
  
  SET\_REFRESH\_EXECUTE\_AS: Sets the user name to refresh this materialized view to the value specified in value.
  
  REMOVE\_TEXT\_SEARCH\_ATTRIBUTES: Removes text search attribute from all columns.
  
  REMOVE\_SHARD\_KEYS: Removes the shard key property from all columns, so that the table will be considered randomly sharded. The data is not moved. The value is ignored.
  
  SET\_STRATEGY\_DEFINITION: Sets the tier strategy for the table and its columns to the one specified in value, replacing the existing tier strategy in its entirety.
  
  CANCEL\_DATASOURCE\_SUBSCRIPTION: Permanently unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  DROP\_DATASOURCE\_SUBSCRIPTION: Permanently delete a cancelled data source subscription.
  
  PAUSE\_DATASOURCE\_SUBSCRIPTION: Temporarily unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  RESUME\_DATASOURCE\_SUBSCRIPTION: Resubscribe to a paused data source subscription. The data source can be Kafka / S3 / Azure / GCS.
  
  CHANGE\_OWNER: Change the owner resource group of the table.
  
  SET\_LOAD\_VECTORS\_POLICY: Set startup data loading scheme for the table; see description of 'load\_vectors\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_PK\_INDEX\_POLICY: Set startup primary key generation scheme for the table; see description of 'build\_pk\_index\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY: Set startup rebuilding scheme for the materialized view; see description of 'build\_materialized\_view\_policy' in GPUdb.createMaterializedView for possible values for value.
  
  value - The value of the modification, depending on action. For example, if action is ADD\_COLUMN, this would be the column name; while the column's definition would be covered by the COLUMN\_TYPE, COLUMN\_PROPERTIES, COLUMN\_DEFAULT\_VALUE, and ADD\_COLUMN\_EXPRESSION in options. If action is TTL, it would be the number of minutes for the new TTL. If action is REFRESH, this field would be blank.
  
  options - Optional parameters.
  
  ACTION
  
  COLUMN\_NAME
  
  TABLE\_NAME
  
  COLUMN\_DEFAULT\_VALUE: When adding a column, set a literal default value for existing records. For nullable columns, the default value will be null, regardless of data type. Also persisted as the column's default for future inserts that omit the column.
  
  COLUMN\_PROPERTIES: When adding or changing a column, set the column properties (strings, separated by a comma: data, 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).
  
  COPY\_VALUES\_FROM\_COLUMN: \[DEPRECATED] Please use ADD\_COLUMN\_EXPRESSION instead.
  
  RENAME\_COLUMN: When changing a column, specify new column name.
  
  VALIDATE\_CHANGE\_COLUMN: When changing a column, validate the change before applying it (or not). Supported values:
  
  TRUE: Validate all values. A value too large (or too long) for the new type will prevent any change.
  
  FALSE: When a value is too large or long, it will be truncated.
  
  The default value is TRUE.
  
  UPDATE\_LAST\_ACCESS\_TIME: Indicates whether the time-to-live (TTL) expiration countdown timer should be reset to the table's TTL. Supported values:
  
  TRUE: Reset the expiration countdown timer to the table's configured TTL.
  
  FALSE: Don't reset the timer; expiration countdown will continue from where it is, as if the table had not been accessed.
  
  The default value is TRUE.
  
  ADD\_COLUMN\_EXPRESSION: When adding a column or setting a new default with action set to SET\_DEFAULT, the new default expression (GPUdb-syntax) for the column. Any valid expression may be used, including one containing references to existing columns in the same table. Persisted as the column's default for future inserts that omit the column; for add\_column, also used to backfill existing rows.
  
  ADD\_COLUMN\_EXPRESSION\_SQL: Optional SQL-syntax form of ADD\_COLUMN\_EXPRESSION, used only when the SQL syntax differs from the GPUdb syntax. Persisted alongside the GPUdb form so SHOW CREATE TABLE / information\_schema can reproduce the original SQL.
  
  STRATEGY\_DEFINITION: Parameter for specifying the tier strategy for the table and its columns when action is SET\_STRATEGY\_DEFINITION, replacing the existing tier strategy in its entirety.
  
  INDEX\_TYPE: Type of index to create, when action is CREATE\_INDEX; to refresh, when action is REFRESH\_INDEX; or to delete, when action is DELETE\_INDEX. Supported values:
  
  COLUMN: Create or delete a column (attribute) index.
  
  LOW\_CARDINALITY: Create a low-cardinality column (attribute) index.
  
  CHUNK\_SKIP: Create or delete a chunk skip index.
  
  GEOSPATIAL: Create or delete a geospatial index.
  
  CAGRA: Create or delete a CAGRA index on a vector column.
  
  HNSW: Create or delete an HNSW index on a vector column.
  
  The default value is COLUMN.
  
  INDEX\_OPTIONS: Options to use when creating an index, in the format "key: value \[, key: value \[, ...]]". Valid options vary by index type.
  
  The default value is an empty Map.
Method Details
- getClassSchema
  
  public static org.apache.avro.Schema getClassSchema()
  
  This method supports the Avro framework and is not intended to be called directly by the user.
  
  Returns:
  
  The schema for the class.
- getTableName
  
  public String getTableName()
  
  Table on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules. Must be an existing table or view.
  
  Returns:
  
  The current value of tableName.
- setTableName
  
  public AlterTableRequest setTableName(String tableName)
  
  Table on which the operation will be performed, in \[schema\_name.]table\_name format, using standard name resolution rules. Must be an existing table or view.
  
  Parameters:
  
  tableName - The new value for tableName.
  
  Returns:
  
  this to mimic the builder pattern.
- getAction
  
  public String getAction()
  Modification operation to be applied. Supported values:
  
  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 value. If this column already has the specified index, an error will be returned.
  
  REFRESH\_INDEX: Refreshes an index identified by INDEX\_TYPE, on the column name specified in value. Currently applicable only to CAGRA indices.
  
  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 value. If this column does not have the specified index, an error will be returned.
  
  MOVE\_TO\_COLLECTION: \[DEPRECATED--please use MOVE\_TO\_SCHEMA and use GPUdb.createSchema to create the schema if non-existent] Moves a table or view into a schema named value. If the schema provided is non-existent, it will be automatically created.
  
  MOVE\_TO\_SCHEMA: Moves a table or view into a schema named value. If the schema provided is nonexistent, an error will be thrown. If value is empty, then the table or view will be placed in the user's default schema.
  
  PROTECTED: No longer used. Previously set whether the given tableName should be protected or not. The value would have been either 'true' or 'false'.
  
  RENAME\_TABLE: Renames a table or view to value. Has the same naming restrictions as tables.
  
  TTL: Sets the time-to-live in minutes of the table or view specified in tableName.
  
  ADD\_COMMENT: Adds the comment specified in value to the table specified in tableName. Use COLUMN\_NAME to set the comment for a column.
  
  ADD\_COLUMN: Adds the column specified in value to the table specified in tableName. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in options to set the column's type and properties, respectively.
  
  CHANGE\_COLUMN: Changes type and properties of the column specified in value. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in 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 options map.
  
  DELETE\_COLUMN: Deletes the column specified in value from the table specified in tableName.
  
  SET\_DEFAULT: Sets or replaces the default value expression for the column specified in value. The new default is taken from ADD\_COLUMN\_EXPRESSION. Existing properties on the column are preserved.
  
  DELETE\_DEFAULT: Removes the default value expression from the column specified in value. Other column properties are preserved.
  
  CREATE\_FOREIGN\_KEY: Creates a foreign key specified in value using the format '(source\_column\_name \[, ...]) references target\_table\_name(primary\_key\_column\_name \[, ...]) \[as foreign\_key\_name]'.
  
  DELETE\_FOREIGN\_KEY: Deletes a foreign key. The value should be the foreign\_key\_name specified when creating the key or the complete string used to define it.
  
  ADD\_PARTITION: Adds the partition specified in value, to either a range-partitioned or manual list-partitioned table.
  
  REMOVE\_PARTITION: Removes the partition specified in value (and relocates all of its data to the default partition) from either a range-partitioned or manual list-partitioned table.
  
  DELETE\_PARTITION: Deletes the partition specified in value (and all of its data) from either a range-partitioned or manual list-partitioned table.
  
  SET\_GLOBAL\_ACCESS\_MODE: Sets the global access mode (i.e. locking) for the table specified in tableName. Specify the access mode in value. Valid modes are 'no\_access', 'read\_only', 'write\_only' and 'read\_write'.
  
  REFRESH: 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.
  
  SET\_REFRESH\_METHOD: For a materialized view, sets the method by which the view is refreshed to the method specified in 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 value - either 'manual' or 'on\_start'.
  
  SET\_REFRESH\_START\_TIME: Sets the time to start periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'. Subsequent refreshes occur at the specified time + N \* the refresh period.
  
  SET\_REFRESH\_STOP\_TIME: Sets the time to stop periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'.
  
  SET\_REFRESH\_PERIOD: Sets the time interval in seconds at which to refresh this materialized view to the value specified in value. Also, sets the refresh method to periodic if not already set.
  
  SET\_REFRESH\_SPAN: Sets the future time-offset(in seconds) for the view refresh to stop.
  
  SET\_REFRESH\_EXECUTE\_AS: Sets the user name to refresh this materialized view to the value specified in value.
  
  REMOVE\_TEXT\_SEARCH\_ATTRIBUTES: Removes text search attribute from all columns.
  
  REMOVE\_SHARD\_KEYS: Removes the shard key property from all columns, so that the table will be considered randomly sharded. The data is not moved. The value is ignored.
  
  SET\_STRATEGY\_DEFINITION: Sets the tier strategy for the table and its columns to the one specified in value, replacing the existing tier strategy in its entirety.
  
  CANCEL\_DATASOURCE\_SUBSCRIPTION: Permanently unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  DROP\_DATASOURCE\_SUBSCRIPTION: Permanently delete a cancelled data source subscription.
  
  PAUSE\_DATASOURCE\_SUBSCRIPTION: Temporarily unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  RESUME\_DATASOURCE\_SUBSCRIPTION: Resubscribe to a paused data source subscription. The data source can be Kafka / S3 / Azure / GCS.
  
  CHANGE\_OWNER: Change the owner resource group of the table.
  
  SET\_LOAD\_VECTORS\_POLICY: Set startup data loading scheme for the table; see description of 'load\_vectors\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_PK\_INDEX\_POLICY: Set startup primary key generation scheme for the table; see description of 'build\_pk\_index\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY: Set startup rebuilding scheme for the materialized view; see description of 'build\_materialized\_view\_policy' in GPUdb.createMaterializedView for possible values for value.
  Returns:
  
  The current value of action.
- setAction
  
  public AlterTableRequest setAction(String action)
  Modification operation to be applied. Supported values:
  
  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 value. If this column already has the specified index, an error will be returned.
  
  REFRESH\_INDEX: Refreshes an index identified by INDEX\_TYPE, on the column name specified in value. Currently applicable only to CAGRA indices.
  
  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 value. If this column does not have the specified index, an error will be returned.
  
  MOVE\_TO\_COLLECTION: \[DEPRECATED--please use MOVE\_TO\_SCHEMA and use GPUdb.createSchema to create the schema if non-existent] Moves a table or view into a schema named value. If the schema provided is non-existent, it will be automatically created.
  
  MOVE\_TO\_SCHEMA: Moves a table or view into a schema named value. If the schema provided is nonexistent, an error will be thrown. If value is empty, then the table or view will be placed in the user's default schema.
  
  PROTECTED: No longer used. Previously set whether the given tableName should be protected or not. The value would have been either 'true' or 'false'.
  
  RENAME\_TABLE: Renames a table or view to value. Has the same naming restrictions as tables.
  
  TTL: Sets the time-to-live in minutes of the table or view specified in tableName.
  
  ADD\_COMMENT: Adds the comment specified in value to the table specified in tableName. Use COLUMN\_NAME to set the comment for a column.
  
  ADD\_COLUMN: Adds the column specified in value to the table specified in tableName. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in options to set the column's type and properties, respectively.
  
  CHANGE\_COLUMN: Changes type and properties of the column specified in value. Use COLUMN\_TYPE and COLUMN\_PROPERTIES in 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 options map.
  
  DELETE\_COLUMN: Deletes the column specified in value from the table specified in tableName.
  
  SET\_DEFAULT: Sets or replaces the default value expression for the column specified in value. The new default is taken from ADD\_COLUMN\_EXPRESSION. Existing properties on the column are preserved.
  
  DELETE\_DEFAULT: Removes the default value expression from the column specified in value. Other column properties are preserved.
  
  CREATE\_FOREIGN\_KEY: Creates a foreign key specified in value using the format '(source\_column\_name \[, ...]) references target\_table\_name(primary\_key\_column\_name \[, ...]) \[as foreign\_key\_name]'.
  
  DELETE\_FOREIGN\_KEY: Deletes a foreign key. The value should be the foreign\_key\_name specified when creating the key or the complete string used to define it.
  
  ADD\_PARTITION: Adds the partition specified in value, to either a range-partitioned or manual list-partitioned table.
  
  REMOVE\_PARTITION: Removes the partition specified in value (and relocates all of its data to the default partition) from either a range-partitioned or manual list-partitioned table.
  
  DELETE\_PARTITION: Deletes the partition specified in value (and all of its data) from either a range-partitioned or manual list-partitioned table.
  
  SET\_GLOBAL\_ACCESS\_MODE: Sets the global access mode (i.e. locking) for the table specified in tableName. Specify the access mode in value. Valid modes are 'no\_access', 'read\_only', 'write\_only' and 'read\_write'.
  
  REFRESH: 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.
  
  SET\_REFRESH\_METHOD: For a materialized view, sets the method by which the view is refreshed to the method specified in 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 value - either 'manual' or 'on\_start'.
  
  SET\_REFRESH\_START\_TIME: Sets the time to start periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'. Subsequent refreshes occur at the specified time + N \* the refresh period.
  
  SET\_REFRESH\_STOP\_TIME: Sets the time to stop periodic refreshes of this materialized view to the datetime string specified in value with format 'YYYY-MM-DD HH:MM:SS'.
  
  SET\_REFRESH\_PERIOD: Sets the time interval in seconds at which to refresh this materialized view to the value specified in value. Also, sets the refresh method to periodic if not already set.
  
  SET\_REFRESH\_SPAN: Sets the future time-offset(in seconds) for the view refresh to stop.
  
  SET\_REFRESH\_EXECUTE\_AS: Sets the user name to refresh this materialized view to the value specified in value.
  
  REMOVE\_TEXT\_SEARCH\_ATTRIBUTES: Removes text search attribute from all columns.
  
  REMOVE\_SHARD\_KEYS: Removes the shard key property from all columns, so that the table will be considered randomly sharded. The data is not moved. The value is ignored.
  
  SET\_STRATEGY\_DEFINITION: Sets the tier strategy for the table and its columns to the one specified in value, replacing the existing tier strategy in its entirety.
  
  CANCEL\_DATASOURCE\_SUBSCRIPTION: Permanently unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  DROP\_DATASOURCE\_SUBSCRIPTION: Permanently delete a cancelled data source subscription.
  
  PAUSE\_DATASOURCE\_SUBSCRIPTION: Temporarily unsubscribe a data source that is loading continuously as a stream. The data source can be Kafka / S3 / Azure / GCS.
  
  RESUME\_DATASOURCE\_SUBSCRIPTION: Resubscribe to a paused data source subscription. The data source can be Kafka / S3 / Azure / GCS.
  
  CHANGE\_OWNER: Change the owner resource group of the table.
  
  SET\_LOAD\_VECTORS\_POLICY: Set startup data loading scheme for the table; see description of 'load\_vectors\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_PK\_INDEX\_POLICY: Set startup primary key generation scheme for the table; see description of 'build\_pk\_index\_policy' in GPUdb.createTable for possible values for value.
  
  SET\_BUILD\_MATERIALIZED\_VIEW\_POLICY: Set startup rebuilding scheme for the materialized view; see description of 'build\_materialized\_view\_policy' in GPUdb.createMaterializedView for possible values for value.
  Parameters:
  
  action - The new value for action.
  
  Returns:
  
  this to mimic the builder pattern.
- getValue
  
  public String getValue()
  
  The value of the modification, depending on action. For example, if action is ADD\_COLUMN, this would be the column name; while the column's definition would be covered by the COLUMN\_TYPE, COLUMN\_PROPERTIES, COLUMN\_DEFAULT\_VALUE, and ADD\_COLUMN\_EXPRESSION in options. If action is TTL, it would be the number of minutes for the new TTL. If action is REFRESH, this field would be blank.
  
  Returns:
  
  The current value of value.
- setValue
  
  public AlterTableRequest setValue(String value)
  
  The value of the modification, depending on action. For example, if action is ADD\_COLUMN, this would be the column name; while the column's definition would be covered by the COLUMN\_TYPE, COLUMN\_PROPERTIES, COLUMN\_DEFAULT\_VALUE, and ADD\_COLUMN\_EXPRESSION in options. If action is TTL, it would be the number of minutes for the new TTL. If action is REFRESH, this field would be blank.
  
  Parameters:
  
  value - The new value for value.
  
  Returns:
  
  this to mimic the builder pattern.
- getOptions
  
  public Map\<String,String> getOptions()
  Optional parameters.
  
  ACTION
  
  COLUMN\_NAME
  
  TABLE\_NAME
  
  COLUMN\_DEFAULT\_VALUE: When adding a column, set a literal default value for existing records. For nullable columns, the default value will be null, regardless of data type. Also persisted as the column's default for future inserts that omit the column.
  
  COLUMN\_PROPERTIES: When adding or changing a column, set the column properties (strings, separated by a comma: data, 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).
  
  COPY\_VALUES\_FROM\_COLUMN: \[DEPRECATED] Please use ADD\_COLUMN\_EXPRESSION instead.
  
  RENAME\_COLUMN: When changing a column, specify new column name.
  
  VALIDATE\_CHANGE\_COLUMN: When changing a column, validate the change before applying it (or not). Supported values:
  
  TRUE: Validate all values. A value too large (or too long) for the new type will prevent any change.
  
  FALSE: When a value is too large or long, it will be truncated.
  
  The default value is TRUE.
  
  UPDATE\_LAST\_ACCESS\_TIME: Indicates whether the time-to-live (TTL) expiration countdown timer should be reset to the table's TTL. Supported values:
  
  TRUE: Reset the expiration countdown timer to the table's configured TTL.
  
  FALSE: Don't reset the timer; expiration countdown will continue from where it is, as if the table had not been accessed.
  
  The default value is TRUE.
  
  ADD\_COLUMN\_EXPRESSION: When adding a column or setting a new default with action set to SET\_DEFAULT, the new default expression (GPUdb-syntax) for the column. Any valid expression may be used, including one containing references to existing columns in the same table. Persisted as the column's default for future inserts that omit the column; for add\_column, also used to backfill existing rows.
  
  ADD\_COLUMN\_EXPRESSION\_SQL: Optional SQL-syntax form of ADD\_COLUMN\_EXPRESSION, used only when the SQL syntax differs from the GPUdb syntax. Persisted alongside the GPUdb form so SHOW CREATE TABLE / information\_schema can reproduce the original SQL.
  
  STRATEGY\_DEFINITION: Parameter for specifying the tier strategy for the table and its columns when action is SET\_STRATEGY\_DEFINITION, replacing the existing tier strategy in its entirety.
  
  INDEX\_TYPE: Type of index to create, when action is CREATE\_INDEX; to refresh, when action is REFRESH\_INDEX; or to delete, when action is DELETE\_INDEX. Supported values:
  
  COLUMN: Create or delete a column (attribute) index.
  
  LOW\_CARDINALITY: Create a low-cardinality column (attribute) index.
  
  CHUNK\_SKIP: Create or delete a chunk skip index.
  
  GEOSPATIAL: Create or delete a geospatial index.
  
  CAGRA: Create or delete a CAGRA index on a vector column.
  
  HNSW: Create or delete an HNSW index on a vector column.
  
  The default value is COLUMN.
  
  INDEX\_OPTIONS: Options to use when creating an index, in the format "key: value \[, key: value \[, ...]]". Valid options vary by index type.
  
  The default value is an empty Map.
  Returns:
  
  The current value of options.
- setOptions
  
  public AlterTableRequest setOptions(Map\<String,String> options)
  Optional parameters.
  
  ACTION
  
  COLUMN\_NAME
  
  TABLE\_NAME
  
  COLUMN\_DEFAULT\_VALUE: When adding a column, set a literal default value for existing records. For nullable columns, the default value will be null, regardless of data type. Also persisted as the column's default for future inserts that omit the column.
  
  COLUMN\_PROPERTIES: When adding or changing a column, set the column properties (strings, separated by a comma: data, 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).
  
  COPY\_VALUES\_FROM\_COLUMN: \[DEPRECATED] Please use ADD\_COLUMN\_EXPRESSION instead.
  
  RENAME\_COLUMN: When changing a column, specify new column name.
  
  VALIDATE\_CHANGE\_COLUMN: When changing a column, validate the change before applying it (or not). Supported values:
  
  TRUE: Validate all values. A value too large (or too long) for the new type will prevent any change.
  
  FALSE: When a value is too large or long, it will be truncated.
  
  The default value is TRUE.
  
  UPDATE\_LAST\_ACCESS\_TIME: Indicates whether the time-to-live (TTL) expiration countdown timer should be reset to the table's TTL. Supported values:
  
  TRUE: Reset the expiration countdown timer to the table's configured TTL.
  
  FALSE: Don't reset the timer; expiration countdown will continue from where it is, as if the table had not been accessed.
  
  The default value is TRUE.
  
  ADD\_COLUMN\_EXPRESSION: When adding a column or setting a new default with action set to SET\_DEFAULT, the new default expression (GPUdb-syntax) for the column. Any valid expression may be used, including one containing references to existing columns in the same table. Persisted as the column's default for future inserts that omit the column; for add\_column, also used to backfill existing rows.
  
  ADD\_COLUMN\_EXPRESSION\_SQL: Optional SQL-syntax form of ADD\_COLUMN\_EXPRESSION, used only when the SQL syntax differs from the GPUdb syntax. Persisted alongside the GPUdb form so SHOW CREATE TABLE / information\_schema can reproduce the original SQL.
  
  STRATEGY\_DEFINITION: Parameter for specifying the tier strategy for the table and its columns when action is SET\_STRATEGY\_DEFINITION, replacing the existing tier strategy in its entirety.
  
  INDEX\_TYPE: Type of index to create, when action is CREATE\_INDEX; to refresh, when action is REFRESH\_INDEX; or to delete, when action is DELETE\_INDEX. Supported values:
  
  COLUMN: Create or delete a column (attribute) index.
  
  LOW\_CARDINALITY: Create a low-cardinality column (attribute) index.
  
  CHUNK\_SKIP: Create or delete a chunk skip index.
  
  GEOSPATIAL: Create or delete a geospatial index.
  
  CAGRA: Create or delete a CAGRA index on a vector column.
  
  HNSW: Create or delete an HNSW index on a vector column.
  
  The default value is COLUMN.
  
  INDEX\_OPTIONS: Options to use when creating an index, in the format "key: value \[, key: value \[, ...]]". Valid options vary by index type.
  
  The default value is an empty Map.
  Parameters:
  
  options - The new value for options.
  
  Returns:
  
  this to mimic the builder pattern.
- getSchema
  
  public org.apache.avro.Schema getSchema()
  
  This method supports the Avro framework and is not intended to be called directly by the user.
  
  Specified by:
  
  getSchema in interface org.apache.avro.generic.GenericContainer
  
  Returns:
  
  The schema object describing this class.
- get
  
  public Object get(int index)
  
  This method supports the Avro framework and is not intended to be called directly by the user.
  
  Specified by:
  
  get in interface org.apache.avro.generic.IndexedRecord
  
  Parameters:
  
  index - the position of the field to get
  
  Returns:
  
  value of the field with the given index.
  
  Throws:
  
  IndexOutOfBoundsException
- put
  
  public void put(int index, Object value)
  
  This method supports the Avro framework and is not intended to be called directly by the user.
  
  Specified by:
  
  put in interface org.apache.avro.generic.IndexedRecord
  
  Parameters:
  
  index - the position of the field to set
  
  value - the value to set
  
  Throws:
  
  IndexOutOfBoundsException
- equals
  
  public boolean equals(Object obj)
  
  Overrides:
  
  equals in class Object
- toString
  
  public String toString()
  
  Overrides:
  
  toString in class Object
- hashCode
  
  public int hashCode()
  
  Overrides:
  
  hashCode in class Object

Class AlterTableRequest

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Details

AlterTableRequest

AlterTableRequest

Method Details

getClassSchema

getTableName

setTableName

getAction

setAction

getValue

setValue

getOptions

setOptions

getSchema

get

put

equals

toString

hashCode