LindormTable release notes - Lindorm - Alibaba Cloud Documentation Center

Lindorm periodically releases new versions to add features and fix bugs. This topic describes the version updates for LindormTable. You can upgrade the LindormTable version of your instance during off-peak hours.

View or upgrade the LindormTable version of an instance

View wide table engine version

You can view the current LindormTable version in the console, as shown in the following figure: View version

Upgrade the engine version

For more information about upgrading versions, see Upgrade versions.

Warning

The cluster restarts during a version upgrade, which may cause slight jitter in application access. Perform the upgrade during off-peak hours.
The system automatically checks the LindormTable version of your instance. If the Upgrade Minor Version button does not appear, your instance already uses the latest LindormTable version.
Version release schedules may vary by region. The version displayed in the console takes precedence.

2.8.x

2.8.6

Release date

Type

Description

2026-01-21

New features

Set SQL query memory limits using the system parameter QUERY_MAX_MEM.
Support the INSERT INTO SELECT syntax.
Enable batch update/delete by default to improve performance.
Support multiple JSON functions.
Show or kill queries initiated by HBase clients using SQL.

Optimized features

Optimize HBase compatibility layer performance.
Optimize SQL read and write performance when handling tables with many columns.
Optimize write performance for Multi-zone Deployment (Basic).
Optimize the index building process.
Include additional stability fixes.

2.8.2

Release date

Type

Description

2025-09-07

New features

Estimate table row counts using Lindorm SQL. For more information, see Estimate table row count.

Optimized features

Improve usability for range deletion, column deletion, and index building.
Optimize load balancing performance when an instance contains many tables.
Optimize SQL-on-HBase features.
Optimize HBase protocol compatibility.
Include additional stability fixes.

2.8.0

Release date

Type

Description

2025-03-27

New features

Enable SQL Audit Log.
Add cursor pagination (in public preview).
Add time functions for processing time data.
Add the ERROR_LANG configuration item to ALTER SYSTEM to set the language for SQL error messages.
Add the HEAD function to aggregate functions.
Lindorm-cli supports connecting to LindormTable using the MySQL protocol. For more information, see Connect to LindormTable using the MySQL protocol.

Optimized features

Add SQL query memory protection to prevent queries from exhausting server memory.
Fix performance regression when rolling back the SQL version to sqlv2.
Optimize pushdown performance for global queries (SELECT *).
Fix performance regression after enabling Secure Sockets Layer (SSL) encryption for SQL.
Optimize HBase protocol compatibility.
Optimize SQL-on-HBase compatibility.
Optimize cache replacement speed during drastic query pattern changes to improve query stability.

2.7.x

2.7.6

Release date

Type

Description

2024-12-06

New features

Support MySQL-style time zone configuration. For more information, see Specify a time zone for a LindormTable connection.
Support the full-text search MATCH function. For more information, see MATCH function.
View SQL audit logs in the console. For more information, see SQL audit logs.
Connect to LindormTable using the Python connector mysql-connector-python. For more information, see Develop applications using Python (mysql-connector-python).

Optimized features

Optimize aggregate request execution logic to improve performance.
Optimize secondary index historical data building logic to resolve occasional build failures.
Optimize request execution retry logic to reduce errors during shard movement or splitting.
Optimize IN request execution logic to improve efficiency for queries with many IN clauses.
Fine-tune hotspot self-healing logic to detect and resolve hotspot shard issues at a finer granularity.
Improve HBase protocol compatibility.
Enhance MySQL syntax compatibility and coverage.
Include additional stability fixes.

2.7.1

Release date

Type

Description

2024-07-11

New features

Use MD5 or SHA256 function expressions as secondary index keys. For more information, see Secondary index function expression.
Set the maximum connections for LindormTable using SQL. For more information, see ALTER SYSTEM configuration items.
GanosBase spatio-temporal service adds S2 secondary indexes. For more information, see S2 secondary indexes.
S2 indexes support intersection queries.

Optimized features

Optimize SQL point query performance.
Build indexes for historical data across multiple index tables of a single table simultaneously.
Provide richer progress information during secondary index historical data building.
Include additional stability fixes and enhance MySQL syntax compatibility and coverage.

2.6.x

2.6.5

Release date

Type

Description

2024-03-25

New features

Add parameters to search indexes: index attribute INDEX_SETTINGS and index key attribute mapping. For more information, see Index key definition (index_key_definition) and Search index key attributes.
GanosBase spatio-temporal service supports S2 secondary indexes. For more information, see S2 secondary indexes.
GanosBase spatio-temporal service supports H3 functions for efficient H3-grid-based spatio-temporal queries and analysis. For more information, see H3 functions.

Optimized features

Enhance MySQL syntax compatibility and coverage.
Lindorm SQL supports physical plan reuse to optimize query performance.
Secondary index historical data building is unaffected by cold storage.
Fix several HBase native client protocol compatibility issues. Users accessing Lindorm with open source HBase clients should upgrade LindormTable to this version or later.

2.6.2

Release date	Type	Description
2023-11-08	New features	Support MySQL-compatible protocol. For more information, see Use the MySQL protocol (recommended).

2.5.x

2.5.6

Release date	Type	Description
2023-08-18	Optimized features	Fix HBase protocol compatibility issues. Fix load imbalance across multiple groups. Include additional stability fixes.

2.5.3

Release date

Type

Description

2023-05-24

New features

Support wildcard columns.

Optimized features

The following issue is fixed: A short-circuit read or write that is performed using an SQL statement may time out.
Note
For better read and write experience, all SQL users should upgrade LindormTable to version 2.5.3 or later.
Fix compatibility issues with the open source HBase client batch interface.
Fix excessive meta requests when using the open source HBase client.

2.5.2

Release date	Type	Description
2023-04-19	New features	Lindorm SQL supports dropping existing columns. For more information, see ALTER TABLE.
2023-04-19	Optimized features	Improve the experience of accessing HBase tables using SQL. Improve query experience in hot and cold data separation scenarios. Improve asynchronous audit log performance. Optimize HBase client protocol compatibility. Increase the file count limit for Region monitoring. Optimize AGGREGATE statement execution efficiency. Reduce CPU consumption caused by data expiration in short TTL scenarios.

2.4.x

2.4.3

Release date	Type	Description
2023-03-10	Optimized features	Optimize Lindorm SQL usability. Include additional stability fixes.

2.4.2

Release date	Type	Description
2022-12-13	New features	Access LindormTable directly using open source HBase clients. Support hot and cold data separation based on a custom time column (recommended for Lindorm SQL users).
2022-12-13	Optimized features	Optimize JSON usability. Include additional stability fixes.

2.4.1

Release date	Type	Description
2022-11-01	Optimized features	Optimize GanosBase spatio-temporal feature usability. Fix Lindorm SQL bugs.

2.4.0

Release date	Type	Description
2022-10-09	New features	Support accessing HBase tables using SQL.
2022-10-09	Optimized features	Optimize Lindorm SQL usability.

2.3.x

2.3.4

Release date	Type	Description
2022-08-30	Optimized features	Optimize Lindorm SQL usability.

2.3.3

Release date	Type	Description
2022-08-16	Optimized features	Add automatic hotspot detection and handling. Add ST_DWithin and ST_DWithinSphere functions to the spatio-temporal engine. Include additional stability fixes.

2.3.2

Release date	Type	Description
2022-08-02	Optimized features	Optimize Lindorm SQL-related syntax. Support more Lindorm GanosBase spatio-temporal features. For more information, see Introduction to the spatio-temporal service.

2.3.1

Release date	Type	Description
2022-06-30	New features	Support spatio-temporal services.

2.2.x

Version	Release date	Type	Description
2.2.21	2022-04-25	Optimized features	Reduce DirectMemory consumption during writes. Optimize load balancing policy. Optimize compaction parameters and support automatic adjustment. Improve index building speed. Optimize SQL read and write performance.
2.2.20	2022-03-16	Optimized features	Optimize write performance for large key-value pairs. Lindorm SQL supports reading multiple versions and writing with custom timestamps. Fix other performance issues.
2.2.19	2022-02-09	New features	Lindorm SQL supports dynamic columns and SQL-layer monitoring.
2.2.19	2022-02-09	Optimized features	Fix delayed metadata updates after modifying Lindorm SQL table properties. Fix stability issues.
2.2.18	2022-01-05	Optimized features	Optimize Lindorm SQL performance. Fix time zone issues for DATE and TIME types in Lindorm SQL. Fix stability issues.
2.2.17	2021-12-17	Optimized features	Fix Lindorm SQL bugs. Improve cold storage Region online speed. Cold storage users should upgrade to LindormTable version 2.2.17 or later.
2.2.16	2021-11-12	Optimized features	Improve Lindorm SQL syntax. SQL users should upgrade to LindormTable version 2.2.16 or later. Optimize flush logic to prevent out-of-memory issues when too many Regions exist. Fix other bugs.
2.2.15	2021-10-18	Optimized features	Optimize Lindorm SQL usage. Fix table creation failures and strong consistency table access failures under certain conditions. Upgrade to this version or later.
2.2.12	2021-09-06	Optimized features	Optimize compaction policies to improve efficiency. Optimize data volume returned by Scan operations.
2.2.11	2021-08-25	New features	Support Lindorm SQL. Support secondary indexes.
2.2.10	2021-08-12	Optimized features	Fix request errors in cold storage during network jitter.
2.2.9	2021-06-09	New features	SearchIndex supports dynamic analyzer configuration generation and fixes several bugs.
2.2.8	2021-03-25	Optimized features	Optimize memory usage during zstd compression.
2.2.7	2021-03-11	New features	Support sequential Lindorm data export. Use with LTS.
2.2.5	2021-01-07	New features	Support Lindorm incremental data export. Use with LTS.
2.2.1	2020-09-09	Optimized features	Optimize SearchIndex and fix several bugs.

2.1.x

Version	Release date	Type	Description
2.1.30	2020-10-26	Optimized features	Optimize flush region selection algorithm under write hotspot conditions.
2.1.26	2020-10-09	Optimized features	Optimize BucketCache memory overhead for small-specification instances.
2.1.25	2020-09-30	Optimized features	Reduce redundant data retrieved during Reverse Scan.
2.1.23	2020-09-22	Optimized features	Optimize memory management for low-memory instances.
2.1.21	2020-07-20	Optimized features	Upgrade to this version or later. Optimize write throughput. Optimize Reverse Scan performance. Optimize hot data archival speed to cold storage in hot and cold data separation.
2.1.17	2020-03-20	Optimized features	Optimize SearchIndex usability.
2.1.15	2020-02-06	Optimized features	Optimize SearchIndex and fix several bugs.
2.1.12	2019-12-16	Optimized features	Optimize SearchIndex and fix bulkload issues.
2.1.10	2019-11-16	New features	Support SearchIndex.
2.1.10	2019-11-16	Optimized features	Optimize hot and cold data separation.
2.1.9	2019-10-08	New features	Support SearchIndex and fix several bugs.
2.1.8	2019-09-09	New features	Support cold storage and hot and cold data separation.