com.gpudb.protocol

Class AlterTableRequest.Options

java.lang.Object

com.gpudb.protocol.AlterTableRequest.Options

Enclosing class:

AlterTableRequest

public static final class AlterTableRequest.Options
extends Object

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 action), compression type to use: none (to use no compression) or a valid compression type. Supported values:
  • NONE
  • SNAPPY
  • LZ4
  • LZ4HC
  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:
  • TRUE: true
  • FALSE: false
  The default value is TRUE.

A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	COLUMN_DEFAULT_VALUE When adding a column, set a default value for existing records.
static String	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).
static String	COLUMN_TYPE When adding or changing a column, set the column type (strings, separated by a comma: int, double, string, null etc).
static String	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.
static String	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.
static String	FALSE false
static String	LZ4
static String	LZ4HC
static String	NONE
static String	RENAME_COLUMN When changing a column, specify new column name.
static String	SNAPPY
static String	TRUE true
static String	VALIDATE_CHANGE_COLUMN When changing a column, validate the change before applying it.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COLUMN_DEFAULT_VALUE

public static final String COLUMN_DEFAULT_VALUE

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

See Also:

Constant Field Values

COLUMN_PROPERTIES

public static final String 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).

See Also:

Constant Field Values

COLUMN_TYPE

public static final String COLUMN_TYPE

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

See Also:

Constant Field Values

COMPRESSION_TYPE

public static final String 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:

• NONE
• SNAPPY
• LZ4
• LZ4HC

The default value is SNAPPY.

See Also:

Constant Field Values

NONE

public static final String NONE

See Also:

Constant Field Values

SNAPPY

public static final String SNAPPY

See Also:

Constant Field Values

LZ4

public static final String LZ4

See Also:

Constant Field Values

LZ4HC

public static final String LZ4HC

See Also:

Constant Field Values

COPY_VALUES_FROM_COLUMN

public static final String 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.

See Also:

Constant Field Values

RENAME_COLUMN

public static final String RENAME_COLUMN

When changing a column, specify new column name.

See Also:

Constant Field Values

VALIDATE_CHANGE_COLUMN

public static final String 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:

• TRUE: true
• FALSE: false

The default value is TRUE.

See Also:

Constant Field Values

TRUE

public static final String TRUE

true

See Also:

Constant Field Values

FALSE

public static final String FALSE

false

See Also:

Constant Field Values