LindormTable release notes - Lindorm - Alibaba Cloud Documentation Center

View or upgrade the LindormTable version

View the wide table engine version

View the current LindormTable version in the Lindorm console:

Upgrade the engine version

For upgrade instructions, see Upgrade versions.

Warning

The cluster restarts during an upgrade, which may cause slight jitter in application access. Schedule upgrades during off-peak hours.

The console checks your LindormTable version automatically. If the Upgrade Minor Version button does not appear, your instance is already on the latest version. Version release schedules vary by region — the version shown in the console takes precedence.

Version history

Jump to a version series: 2.8.x · 2.7.x · 2.6.x · 2.5.x · 2.4.x · 2.3.x · 2.2.x · 2.1.x

2.8.x

2.8.6

Release date: 2026-01-21

New features

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

Performance improvements and fixes

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

2.8.2

Release date: 2025-09-07

New features

Estimate table row counts using Lindorm SQL. See Estimate table row count.

Performance improvements and fixes

Improve usability for range deletion, column deletion, and index building.
Improve load balancing on instances with many tables.
Optimize SQL-on-HBase features.
Improve HBase protocol compatibility.
Additional stability fixes.

2.8.0

Release date: 2025-03-27

New features

Enable SQL Audit Log.
Add cursor pagination (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 aggregate function.
lindorm-cli now supports connecting to LindormTable using the MySQL protocol. See Connect to LindormTable using the MySQL protocol.

Performance improvements and fixes

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

2.7.x

2.7.6

Release date: 2024-12-06

New features

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

Performance improvements and fixes

Improve aggregate request execution performance.
Fix occasional secondary index historical data build failures.
Reduce errors during shard movement or splitting by improving request retry logic.
Improve IN clause execution efficiency for queries with many IN clauses.
Detect and resolve hotspot shard issues at finer granularity through improved hotspot self-healing logic.
Improve HBase protocol compatibility.
Improve MySQL syntax compatibility and coverage.
Additional stability fixes.

2.7.1

Release date: 2024-07-11

New features

Use MD5 or SHA256 function expressions as secondary index keys. See Secondary index function expression.
Set the maximum connection count for LindormTable using SQL. See ALTER SYSTEM configuration items.
GanosBase spatio-temporal service adds S2 secondary indexes. See GanosBaseGanosBaseGanosBaseGanosBaseGanosBaseS2 secondary indexes.
S2 indexes support intersection queries.

Performance improvements and fixes

Improve 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.
Additional stability fixes and improved MySQL syntax compatibility and coverage.

2.6.x

2.6.5

Release date: 2024-03-25

New features

Add parameters to search indexes: the INDEX_SETTINGS index attribute and the mapping index key attribute. See Index key definition and Search index key attributes.
GanosBase spatio-temporal service supports S2 secondary indexes. See S2 secondary indexes.
GanosBase spatio-temporal service supports H3 functions for H3-grid-based spatio-temporal queries and analysis. See H3 functions.

Performance improvements and fixes

Improve MySQL syntax compatibility and coverage.
Lindorm SQL now supports physical plan reuse to improve query performance.
Secondary index historical data building is now unaffected by cold storage.
Fix several HBase native client protocol compatibility issues.

If you access Lindorm with open-source HBase clients, upgrade to LindormTable 2.6.5 or later.

2.6.2

Release date: 2023-11-08

New features

2.5.x

2.5.6

Release date: 2023-08-18

Performance improvements and fixes

Fix HBase protocol compatibility issues.
Fix load imbalance across multiple groups.
Additional stability fixes.

2.5.3

Release date: 2023-05-24

New features

Support wildcard columns.

Performance improvements and fixes

Fix a timeout that could occur when performing short-circuit reads or writes using SQL.
Fix compatibility issues with the open-source HBase client batch interface.
Fix excessive meta requests when using the open-source HBase client.

For better read and write performance, upgrade all SQL workloads to LindormTable 2.5.3 or later.

2.5.2

Release date: 2023-04-19

New features

Lindorm SQL now supports dropping existing columns. See ALTER TABLE.

Lindorm SQL supports dropping existing columns. For more information, see ALTER TABLE.

Performance improvements and fixes

Improve the experience of accessing HBase tables using SQL.
Improve query experience in hot and cold data separation scenarios.
Improve asynchronous audit log performance.
Improve HBase client protocol compatibility.
Increase the file count limit for Region monitoring.
Improve AGGREGATE statement execution efficiency.
Reduce CPU consumption from data expiration in short TTL scenarios.

2.4.x

2.4.3

Release date: 2023-03-10

Performance improvements and fixes

Improve Lindorm SQL usability.
Additional stability fixes.

2.4.2

Release date: 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).

Performance improvements and fixes

Improve JSON usability.
Additional stability fixes.

2.4.1

Release date: 2022-11-01

Performance improvements and fixes

Improve GanosBase spatio-temporal feature usability.
Fix Lindorm SQL bugs.

2.4.0

Release date: 2022-10-09

New features

Support accessing HBase tables using SQL.

Performance improvements and fixes

Improve Lindorm SQL usability.

2.3.x

2.3.4

Release date: 2022-08-30

Performance improvements and fixes

Improve Lindorm SQL usability.

2.3.3

Release date: 2022-08-16

Performance improvements and fixes

Add automatic hotspot detection and handling.
Add ST_DWithin and ST_DWithinSphere functions to the spatio-temporal engine.
Additional stability fixes.

2.3.2

Release date: 2022-08-02

Performance improvements and fixes

Improve Lindorm SQL syntax.
Support additional Lindorm GanosBase spatio-temporal features. See Introduction to the spatio-temporal service.

2.3.1

Release date: 2022-06-30

New features

Support spatio-temporal services.

2.2.x

Version	Release date	Type	Description
2.2.21	2022-04-25	Performance improvements and fixes	Reduce DirectMemory consumption during writes. Improve load balancing policy. Optimize compaction parameters with automatic adjustment. Improve index building speed. Improve SQL read and write performance.
2.2.20	2022-03-16	Performance improvements and fixes	Improve write performance for large key-value pairs. Lindorm SQL now supports reading multiple versions and writing with custom timestamps. Additional performance fixes.
2.2.19	2022-02-09	New features and fixes	Lindorm SQL now supports dynamic columns and SQL-layer monitoring. Fix delayed metadata updates after modifying Lindorm SQL table properties. Fix stability issues.
2.2.18	2022-01-05	Performance improvements and fixes	Improve Lindorm SQL performance. Fix time zone issues for DATE and TIME types in Lindorm SQL. Fix stability issues.
2.2.17	2021-12-17	Performance improvements and fixes	Fix Lindorm SQL bugs. Improve cold storage Region online speed. Note Upgrade cold storage instances to 2.2.17 or later.
2.2.16	2021-11-12	Performance improvements and fixes	Improve Lindorm SQL syntax. Optimize flush logic to prevent out-of-memory issues when too many Regions exist. Additional bug fixes. Note Upgrade SQL instances to 2.2.16 or later.
2.2.15	2021-10-18	Performance improvements and fixes	Improve Lindorm SQL usability. Fix table creation failures and strong consistency table access failures under certain conditions. Note Upgrade to 2.2.15 or later.
2.2.12	2021-09-06	Performance improvements and fixes	Improve compaction policies for better efficiency. Reduce 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	Performance improvements and fixes	Fix request errors in cold storage during network jitter.
2.2.9	2021-06-09	New features	SearchIndex supports dynamic analyzer configuration generation. Additional bug fixes.
2.2.8	2021-03-25	Performance improvements and fixes	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	Performance improvements and fixes	Improve SearchIndex and fix several bugs.

2.1.x

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