The Overview page in the cluster management system lists all tables in the LindormTable of a Lindorm instance. For each table, the page shows the table size, shard count, data preview, table schema, and throttling information. Use this page to create tables, inspect table details, and move tables between groups.
Prerequisites
Before you begin, ensure that 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
LindormTable supports two table types: 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. Max versions No The number of data versions to retain. TTL No The time-to-live (TTL) of data. Data that exceeds the TTL is automatically deleted. TTL must be specified for tables created in the cluster management system. TTLUnit No The unit of the TTL. Valid values: DAYS, HOURS, MINUTES. Compression type No The compression algorithm. Options: LZO, SNAPPY, ZSTD, LZ4, NONE. NONE disables compression. 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. Specify the column name, data type (see Basic data types), and sorting method (ASC or DESC). Click Save. Non-primary key Yes The non-primary key columns. Specify the name and data type for each column. To permanently retain data, you can change the value of the TTL parameter to
-1using change management. For more information, see Change management.Click OK.
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 a Row of Data and configure the following parameters.
To permanently retain data, you can change the value of the TTL parameter to
-1using change management. For more information, see Change management.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 time-to-live (TTL) of data. Data that exceeds the TTL is automatically deleted. TTL must be specified for tables created in the cluster management system. TTLUnit No The unit of the TTL. Valid values: DAYS, HOURS, MINUTES. Compression type No The compression algorithm. Options: LZO, SNAPPY, ZSTD, LZ4, NONE. NONE disables compression. Encoding type No The data encoding algorithm. Options: NONE, DIFF, INDEX. NONE disables encoding. Optional: In the Pre-partition section, enter partition keys for pre-partitioning. Separate multiple partition keys with a comma (,).
Click OK.
View table details
On the Overview page, filter tables by IDC, group, namespace, or table name. Click Query to load the results.
Click the
icon in the upper-right corner of the table to select which columns to display.Click the name of a table to view its details. The details page contains the following sections.
Section Content Current details table The name of the table. Table schema information Column names, data types, primary key designation, and column sorting method. Index information Secondary index name, status, build progress, and index type. Shard information The shard to which the table belongs, the node, shard size, and file count. Click the icon to select which columns to display.Region distribution information Number and size of shards on each node, and the volume of data handled by read and write requests. Data preview The first 20 rows of data in the table. The details page also shows the total row count, hot and cold storage usage, max versions, TTL, and compression type.
Move the group of a table
Do not move a table to a group that contains no servers. 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.