Lindorm:Overview

Prerequisites

You are logged on to the cluster management system of your Lindorm instance. For more information, see Log on to the cluster management system.

Create a table

You can create two types of tables in the cluster management system: SQL tables and HBase tables.

Create a SQL table

1. Click Create SQL table.

2. On the pane that appears, configure the parameters described in the following table.

   Parameter	Required	Description
   Namespace	Yes	The namespace of the table.
   Table name	Yes	The name of the table.
   versions	Yes	The number of versions that you want to retain for data in the table.
   TTL	Yes	TTL The time-to-live (TTL) of the data in the table. Data that exceeds the TTL is automatically cleared. You must specify this parameter when you create a table in the cluster management system. Note To permanently retain data in a table, you can change the value of this parameter to -1. For more information, see Manage table changes.
   TTLUnit	Yes	The unit of TTL. Valid values: DAYS, HOURS, and MINUTES.
   Compression type	Yes	The algorithm used to compress the data in the table. Valid values: NONE, SNAPPY, ZSTD, and LZ4.
   Start key	No	The start key of the partition.
   End key	No	The end key of the partition.
   Number Regions	No	The number of partitions.
   Primary key	Yes	Click add a row of data to add a primary key column. After you add a column, click Save. You can configure the following fields for each primary key column that you add: Col: The name of the column. type: The data type of the primary key column. For more information, see Basic data types. Sort: The sorting order of the column. Valid values: Ascending and Descending.
   Non-primary key	Yes	The columns that are not contained in the primary key. You must specify the name and data type of each non-primary key column.

3. Click OK.

Create an HBase table

1. Click Create HBase table.

2. On the pane that appears, configure the parameters described in the following table.

   Parameter	Required	Description
   Namespace	Yes	The namespace of the table.
   Table name	Yes	The name of the table.

3. In the Column family information section, click add a row of data and specify the parameters described in the following table.

   Parameter	Required	Description
   Column family name	Yes	The name of the column family.
   Maximum Versions	Yes	The number of versions that you want to retain for data in the table.
   TTL	Yes	TTL The TTL of the data in the table. Data that exceeds the TTL is automatically cleared. You must specify this parameter when you create a table in the cluster management system. Note To permanently retain data in a table, you can change the value of this parameter to -1. For more information, see Manage table changes.
   TTLUnit	Yes	The unit of TTL. Valid values: DAYS, HOURS, and MINUTES.
   Compression type	Yes	The algorithm used to compress the data in the table. Valid values: NONE, SNAPPY, ZSTD, and LZ4.

4. (Optional) In the Pre partition section, enter the partition keys for pre-partitioning. Separate multiple partition keys with commas (,).

5. Click OK.

View the details of a table

The detailed information of a wide table includes the number of rows in the table, the storage capacity used by hot and cold data, the table schema, the maximum number of retained versions, TTL, and data compression type, data preview, the number of shards, and the size of each shard.

1. On the Overview page, you can specify filter conditions such as IDCs, groups, namespaces, and tables and then click Query to view the table information.

   Note

   You can click the icon to specify the columns that you want to view.

2. Click the name of a table to view its detailed information. The following table describes the detailed information that you can view in different sections.

   Section	Description
   Current table details	Displays the name of the table.
   Schema	Displays the schema of the table, including the column names, column data types, primary key columns, and the sorting order of the primary key columns.
   Secondary Index	Displays the detailed information about the secondary index of the table, including the index name, status, building progress, and index type.
   Shard information	Displays the shard to which the table belongs, the node, the size of the shard, and the number of files contained in the shard. You can click the icon to specify the columns that you want to view.
   Region distribution	Displays the number and size of shards in each node and the amount of data involved in the read and write requests for a node.
   Data Preview	Previews the first 20 rows of data in the table.

Move a table to a group

1. On the Overview page, click Move group in the Operation column.

2. In the Move To Group dialog box, select the group to which you want to move the table from the Target group drop-down list.

3. Click OK.

Delete a table

1. On the Overview page, choose More > Delete in the Actions column corresponding to the table you want to delete.

2. In the Delete Table dialog box, click OK.

   Important

   Before you delete a table, make sure that the table is in the offline state and no data is being read from or written to the table.