The Overview page of the cluster management system displays details for all tables in the LindormTable of a Lindorm instance. These details include table size, shards, data preview, table schema, and throttling information. This topic describes how to manage wide tables using the cluster management system.
Prerequisites
You have logged on to the cluster management system of the target 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
Click Create SQL Table.
In the panel that appears, specify the following parameters.
Parameter
Required
Description
Namespace
Yes
The namespace to which the table belongs.
Table name
Yes
The name of the table.
Max versions
No
The number of data versions to retain.
TTL
No
The time-to-live (TTL) of the data. Data that exceeds the TTL is automatically deleted. You must specify the TTL parameter for tables that are created in the cluster management system.
NoteIf you want to permanently retain data, you can change the value of the TTL parameter to
-1using change management. For more information, see Change management.TTLUnit
No
The unit of the TTL. Valid values: DAYS, HOURS, and MINUTES.
Compression type
No
The data compression algorithm. The following options are available: LZO, SNAPPY, ZSTD, LZ4, and NONE. NONE indicates that no compression algorithm is used.
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 specify the column information, click Save.
You must specify the following column information:
Column name.
Type: The data type of the primary key column. For more information about the supported data types, see Basic data types.
Sorting method: Ascending (ASC) and Descending (DESC).
Non-primary key
Yes
The non-primary key columns. You must specify the name and data type for each non-primary key column.
Click OK.
Create an HBase table
Click Create HBase Table.
In the panel that appears, specify the following parameters.
Parameter
Required
Description
Namespace
Yes
The namespace to which the table belongs.
Table name
Yes
The name of the table.
In the Column Family Information section, click Add a Row of Data and specify the following parameters.
Parameter
Required
Description
Column family name
Yes
The name of the column family.
Max versions
No
The number of data versions to retain.
TTL
No
The TTL of the data. Data that exceeds the TTL is automatically deleted. You must specify the TTL parameter for tables that are created in the cluster management system.
NoteIf you want to permanently retain data, you can change the value of the TTL parameter to
-1using change management. For more information, see Change management.TTLUnit
No
The unit of the TTL. Valid values: DAYS, HOURS, and MINUTES.
Compression type
No
The data compression algorithm. The following options are available: LZO, SNAPPY, ZSTD, LZ4, and NONE. NONE indicates that no compression algorithm is used.
Encoding type
No
The data encoding algorithm. The following options are supported: NONE, DIFF, and INDEX. NONE indicates that no encoding algorithm is used.
Optional: In the Pre-partition section, enter the partition keys for pre-partitioning. Separate multiple partition keys with a comma (,).
Click OK.
View the details of a table
The details of a wide table include the number of rows, the amount of hot and cold storage space used, the table schema, the max versions of the column family, TTL, the data compression type, a data preview, the number of shards, and the size of each shard.
On the Overview page, you can filter tables by dimensions such as IDC, group, namespace, and table name. Then, click Query to view the table information in the list that appears.
NoteYou can click the
icon in the upper-right corner of the table to specify which columns are displayed.Click the name of the target table to view its details. The details include the following information:
Section
Description
Current details table
The name of the table.
Table schema information
The detailed structure of the table, including column names, column data types, the primary key, and the column sorting method.
Index information
The details of the secondary indexes in the table, including the index name, status, build progress, and index type.
Shard information
The shard to which the table belongs, the node, the size of the shard, the number of files in the shard, and more. You can click the
icon in the upper-right corner of the table to specify the columns to be displayed.Region distribution information
The number and size of shards on the node, the amount of data involved in read and write requests on the node, and more.
Data preview
A preview of the first 20 rows of data in the table.
Move the group of a table
Do not move a table to a group that contains no servers. Otherwise, the table becomes inaccessible.
On the Overview page, click Move Group in the Operation column.
In the Move Group dialog box, select a Target Group.
Click OK.