Create a table in the Lindorm console-Lindorm(Lindorm)-阿里云帮助中心

The Overview page of the cluster management system provides details about all tables in the LindormTable of a Lindorm instance. These details include table size, shard information, data preview, table schema, and throttling information. This topic describes how to manage wide tables by 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

In the cluster management system, you can create two types of tables: SQL tables and HBase tables.

Create a SQL table

Click Create SQL table.

In the panel that appears, configure the following parameters:

Parameter	Required	Description
Namespace	Yes	The namespace to which the table belongs.
Table name	Yes	The name of the table.
Versions	No	The number of data versions to retain.
TTL	No	The time to live (TTL) for the data. Data that exceeds its TTL is automatically deleted. Tables created in the cluster management system must have a TTL. Note To permanently store data, you can set the TTL to `-1` by modifying the table. For more information, see Manage table changes.
TTLUnit	No	The unit for the TTL. Valid values: DAYS, HOURS, and MINUTES.
Compression type	No	The data compression algorithm. Valid values: LZO, SNAPPY, ZSTD, LZ4, and None. None indicates that no compression is used.
Start key	No	The start key for the partition.
End key	No	The end key for the partition.
Number of regions	No	The number of regions.
Primary key	Yes	Click Add One Row to add a primary key column. After you configure the column information, click Save. You must configure the following information for each primary key column: The name of the column. Type: The data type of the primary key column. For more information about supported data types, see Basic data types. Sort order: The sort order of the column. Valid values: Ascending (ASC) and Descending (DESC).
Non-primary key	Yes	A non-primary key column. You must specify the column name and data type.

Click Determine.

Create an HBase table

Click Create HBase table.

In the panel that appears, configure 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 One Row and configure the following parameters.

Parameter	Required	Description
Column family name	Yes	The name of the column family.
Maximum versions	No	The number of data versions to retain.
TTL	No	The time to live (TTL) for the data. Data that exceeds its TTL is automatically deleted. Tables created in the cluster management system must have a TTL. Note To permanently store data, you can set the TTL to `-1` by modifying the table. For more information, see Manage table changes.
TTLUnit	No	The unit for the TTL. Valid values: DAYS, HOURS, and MINUTES.
Compression type	No	The data compression algorithm. Valid values: LZO, SNAPPY, ZSTD, LZ4, and None. None indicates that no compression is used.
Encoding type	No	The data encoding algorithm. Valid values: None, DIFF, and INDEX. None indicates that no encoding is used.

Optional: In the pre-partitioning section, enter the partition keys. Separate multiple partition keys with a comma (,).
Click Determine.

View table details

The details of a wide table include the number of rows, hot and cold storage usage, the table schema, the maximum versions, TTL, and compression type for each column family, a data preview, and information about shards such as the number and size of each shard.

On the Overview page, you can filter tables by IDC, group, namespace, or table name. Click Query to display the results in the list below.

Note
You can click the settings icon in the upper-right corner of the list to customize the columns that are displayed.

Click a table name to view its details. The details are organized into the following sections:

Section	Description
Basic information	Displays the name of the table.
Table schema	Displays the detailed structure of the table, including column names, data types, the primary key, and sort order.
Secondary index	Displays details about the secondary indexes on the table, including the index name, status, build progress, and index type.
Shard information	Displays information such as the table's shards, nodes, shard sizes, and the number of files in each shard. You can click the settings icon in the upper-right corner to customize the columns that are displayed.
Region distribution	Displays information such as the number and size of regions on each node, and the volume of data involved in read and write requests for each node.
Data preview	Displays a preview of the first 20 rows of data.

Move a table to a different group

Warning

Do not move a table to a group that does not contain any RegionServer nodes. Otherwise, the table will become inaccessible.

On the Overview page, click Move group in the Operation column for the target table.
In the Move group dialog box, select a Target group.
Click Determine.