All Products
Search

This Product

    Lindorm:Manage table changes

    Document Center

    Lindorm:Manage table changes

    Last Updated:Feb 28, 2024

    Lindorm wide tables have various attributes, such as the number of retained column data versions, data compression method, data validity period, and the time period after which data is stored by using cold storage. You can add attributes to or modify the attributes of existing tables in the cluster management system of LindormTable.

    Procedure

    1. Log on to the cluster management system of Lindorm.

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

    3. Select the attribute that you want to change from the Alter Type drop-down list. The following table describes the attributes that you can modify for a table.

      Table attribute

      Description

      Consistency

      The consistency level of the table. Default value: eventual. Valid values:

      • eventual: Data in the base table and index table become consistent after a point in time.

      • strong: Data in the base table and index table are consistent at all points in time.

      Mutability

      An option related to indexes. This option specifies the mutability of the base table.

      Valid values:

      • IMMUTABLE

      • IMMUTABLE_ROWS

      • MUTABLE_LATEST

      • MUTABLE_ALL

      For more information, see Secondary indexes.

      Enable dynamic columns

      Specifies whether to enable dynamic columns for the table. For more information, see Dynamic columns

      modify version

      The number of versions that are retained for column data. The value of this option is an integer greater than or equal to 1. The default value of this option is 1, which indicates that only one version is retained for column data.

      Compaction period

      The interval at which the major compaction operation is performed. Unit: millisecond. The minimum value of this option is 3600000, which is equal to one hour.

      modify TTL

      The TTL of data in the table. Unit: second. To permanently retain data in the table, set this option to -1.

      modify compression type

      The algorithm used to compress data in the table. Default value: NONE. The following algorithms are supported: SNAPPY, ZSTD, and LZ4.

      modify chs

      The time period after which data is stored by using cold storage. Unit: second. The minimum value of this option is 1 second.

      Note

      For more information about table attributes, see the "Table options" section in CREATE TABLE.

    4. Select the namespace from the Namespace drop-down list and the table whose attributes you want to modify.

    5. Specify the attribute value and then click submit.