Kinetica C# API  Version 6.1.0.0
Public Attributes | List of all members
kinetica.AlterTableRequest.Options Struct Reference

Optional parameters. More...

Public Attributes

const string COLUMN_DEFAULT_VALUE = "column_default_value"
 When adding a column, set a default value for existing records. More...
 
const string COLUMN_PROPERTIES = "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). More...
 
const string COLUMN_TYPE = "column_type"
 When adding or changing a column, set the column type (strings, separated by a comma: int, double, string, null etc). More...
 
const string COMPRESSION_TYPE = "compression_type"
 When setting column compression (set_column_compression for action), compression type to use: none (to use no compression) or a valid compression type. More...
 
const string NONE = "none"
 
const string SNAPPY = "snappy"
 
const string LZ4 = "lz4"
 
const string LZ4HC = "lz4hc"
 
const string COPY_VALUES_FROM_COLUMN = "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. More...
 
const string RENAME_COLUMN = "rename_column"
 When changing a column, specify new column name. More...
 
const string VALIDATE_CHANGE_COLUMN = "validate_change_column"
 When changing a column, validate the change before applying it. More...
 
const string TRUE = "true"
 true More...
 
const string FALSE = "false"
 false More...
 

Detailed Description

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: 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: The default value is TRUE.


A set of string constants for the parameter options.

Definition at line 370 of file AlterTable.cs.

Member Data Documentation

◆ COLUMN_DEFAULT_VALUE

const string kinetica.AlterTableRequest.Options.COLUMN_DEFAULT_VALUE = "column_default_value"

When adding a column, set a default value for existing records.

Definition at line 375 of file AlterTable.cs.

◆ COLUMN_PROPERTIES

const string kinetica.AlterTableRequest.Options.COLUMN_PROPERTIES = "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).

Definition at line 380 of file AlterTable.cs.

◆ COLUMN_TYPE

const string kinetica.AlterTableRequest.Options.COLUMN_TYPE = "column_type"

When adding or changing a column, set the column type (strings, separated by a comma: int, double, string, null etc).

Definition at line 385 of file AlterTable.cs.

◆ COMPRESSION_TYPE

const string kinetica.AlterTableRequest.Options.COMPRESSION_TYPE = "compression_type"

When setting column compression (set_column_compression for action), compression type to use: none (to use no compression) or a valid compression type.

Supported values:

The default value is SNAPPY.

Definition at line 412 of file AlterTable.cs.

◆ COPY_VALUES_FROM_COLUMN

const string kinetica.AlterTableRequest.Options.COPY_VALUES_FROM_COLUMN = "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.

Definition at line 422 of file AlterTable.cs.

◆ FALSE

const string kinetica.AlterTableRequest.Options.FALSE = "false"

false

Definition at line 454 of file AlterTable.cs.

◆ LZ4

const string kinetica.AlterTableRequest.Options.LZ4 = "lz4"

Definition at line 415 of file AlterTable.cs.

◆ LZ4HC

const string kinetica.AlterTableRequest.Options.LZ4HC = "lz4hc"

Definition at line 416 of file AlterTable.cs.

◆ NONE

const string kinetica.AlterTableRequest.Options.NONE = "none"

Definition at line 413 of file AlterTable.cs.

◆ RENAME_COLUMN

const string kinetica.AlterTableRequest.Options.RENAME_COLUMN = "rename_column"

When changing a column, specify new column name.

Definition at line 426 of file AlterTable.cs.

◆ SNAPPY

const string kinetica.AlterTableRequest.Options.SNAPPY = "snappy"

Definition at line 414 of file AlterTable.cs.

◆ TRUE

const string kinetica.AlterTableRequest.Options.TRUE = "true"

true

Definition at line 451 of file AlterTable.cs.

◆ VALIDATE_CHANGE_COLUMN

const string kinetica.AlterTableRequest.Options.VALIDATE_CHANGE_COLUMN = "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:

The default value is TRUE.

Definition at line 448 of file AlterTable.cs.

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