Table Alter Manager

更新时间:
复制 MD 格式

Lindorm wide tables support various table attributes, such as the number of versions to retain for column values, data compression methods, time-to-live (TTL), and cold storage thresholds. You can add or modify table attributes for existing wide tables in the cluster management system.

Procedure

  1. Log in to the cluster management system.

  2. In the left navigation pane, choose Data Manager > Table Alter Manager.

  3. From the Alter type drop-down list, select the table attribute to modify. The following table describes the available table attributes:

    Parameter

    Description

    Consistency

    The consistency level of the table. By default, the base table and index tables are eventually consistent. The following levels are supported:

    • eventual: The default value. The base table and index tables become consistent over time.

    • strong: The data in the base table and index tables are synchronized and consistent at all times.

    Mutability

    An index-related attribute that specifies the write pattern for the base table.

    Supported values:

    • IMMUTABLE

    • IMMUTABLE_ROWS

    • MUTABLE_LATEST

    • MUTABLE_ALL

    For more information, see secondary index.

    Enable dynamic columns

    Enables the dynamic column feature for the table. For more information, see dynamic column.

    Modify version

    The number of versions to retain for column values. The value must be an integer of 1 or greater. The default is 1.

    Compaction Period

    The interval for a major compaction, in milliseconds (ms). The minimum value is 3,600,000, which is equivalent to 1 hour.

    Modify TTL

    The time-to-live (TTL) for data, in seconds (s). To retain data permanently, enter -1.

    Modify compression type

    The data compression algorithm. By default, no compression is used (NONE). Supported algorithms include SNAPPY, ZSTD, and LZ4.

    Modify cold storage threshold

    The cold storage threshold, in seconds (s). The minimum value is 1.

    Note

    For more information about table attributes, see Table attributes (table_options).

  4. Select the Namespace and the wide table that you want to modify.

  5. Set the attribute value, and then click Submit.