Skip to main content

◆ alterTableColumns() [1/2]

AlterTableColumnsResponse kinetica.Kinetica.alterTableColumns (AlterTableColumnsRequestrequest_)
inline

Apply various modifications to columns in a table, view.

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.

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.

Parameters
request_Request object containing the parameters for the operation.
Returns
Response object containing the result of the operation.

Definition at line 14104 of file KineticaFunctions.cs.

◆ alterTableColumns() [2/2]

AlterTableColumnsResponse kinetica.Kinetica.alterTableColumns (stringtable_name,
IList< IDictionary< string, string > >column_alterations,
IDictionary< string, string >options )
inline

Apply various modifications to columns in a table, view.

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.

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.

Parameters
table_nameTable on which the operation will be performed. Must be an existing table or view, in [schema_name.]table_name format, using standard name resolution rules.
column_alterationsList of alter table add/delete/change column requests - all for the same table. Each request is a map that includes ‘column_name’, ‘action’ and the options specific for the action. Note that the same options as in alter table requests but in the same map as the column name and the action. For example: [‘column_name’:‘col_1’,‘action’:‘change_column’,‘rename_column’:‘col_2’,‘column_name’:‘col_1’,‘action’:‘add_column’, ‘type’:‘int’,‘default_value’:‘1’].
optionsOptional parameters.
Returns
Response object containing the result of the operation.

Definition at line 14170 of file KineticaFunctions.cs.

◆ AlterTableColumnsAsync() [1/2]

async System.Threading.Tasks.Task< AlterTableColumnsResponse > kinetica.Kinetica.AlterTableColumnsAsync (AlterTableColumnsRequestrequest_,
System.Threading.CancellationTokencancellationToken = default )
inline

Apply various modifications to columns in a table, view.

(async)

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.

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.

Parameters
request_Request object containing the parameters for the operation.
cancellationTokenCancellation token to cancel the operation.
Returns
Task that returns the response object containing the result of the operation.

Definition at line 14132 of file KineticaFunctions.cs.

◆ AlterTableColumnsAsync() [2/2]

async System.Threading.Tasks.Task< AlterTableColumnsResponse > kinetica.Kinetica.AlterTableColumnsAsync (stringtable_name,
IList< IDictionary< string, string > >column_alterations,
IDictionary< string, string >options,
System.Threading.CancellationTokencancellationToken = default )
inline

Apply various modifications to columns in a table, view.

(async)

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.

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.

Parameters
table_nameTable on which the operation will be performed. Must be an existing table or view, in [schema_name.]table_name format, using standard name resolution rules.
column_alterationsList of alter table add/delete/change column requests - all for the same table. Each request is a map that includes ‘column_name’, ‘action’ and the options specific for the action. Note that the same options as in alter table requests but in the same map as the column name and the action. For example: [‘column_name’:‘col_1’,‘action’:‘change_column’,‘rename_column’:‘col_2’,‘column_name’:‘col_1’,‘action’:‘add_column’, ‘type’:‘int’,‘default_value’:‘1’].
optionsOptional parameters.
cancellationTokenCancellation token to cancel the operation.
Returns
Task that returns the response object containing the result of the operation.

Definition at line 14211 of file KineticaFunctions.cs.