LindormTable release notes - Lindorm - Alibaba Cloud Documentation Center

View or upgrade the LindormTable version

View the LindormTable version

You can view the current LindormTable version in the console. In the engine list for the instance, the LindormTable row displays the version number, such as 2.8.0.5, in the Version column.

Upgrade the engine version

For the upgrade procedure and important notes, see Minor version update.

Warning

A version upgrade restarts the cluster, which may cause brief application instability. We recommend performing this operation during off-peak hours.
The system automatically checks the LindormTable version of your instance. If the Upgrade Minor Version button is not displayed, the instance is already running the latest version.
The availability of new LindormTable versions may vary by region. The information displayed in the console is authoritative.

2.8.x

2.8.6

Release date	Type	Description
2026-01-21	New features	You can now set memory limits for SQL queries with the QUERY_MAX_MEM system parameter. Now supports the `INSERT INTO SELECT` syntax. Enabled batch updates and deletes by default to improve performance. Added multiple new JSON functions. You can now use SQL to show or kill queries from HBase clients.
2026-01-21	Enhancements	Optimized the performance of the HBase compatibility layer. Improved the performance of SQL read and write operations on tables with a large number of columns. Improved the write performance for Multi-AZ Basic Edition instances. Optimized the index-building process. Other stability fixes.

2.8.2

Release date	Type	Description
2025-09-07	New features	You can now estimate the number of rows in a table with Lindorm SQL.
2025-09-07	Enhancements	Improved the user experience of range deletion, column deletion, and index building. Improved the load balancing performance for instances that contain a large number of tables. Improved SQL-on-HBase features. Improved HBase protocol compatibility. Other stability fixes.

2.8.0

Release date	Type	Description
2025-03-27	New features	Added the SQL audit log feature. Introduced cursor pagination (in public preview). Added new time functions. Added the `ERROR_LANG` configuration item to the ALTER SYSTEM statement to specify the language of SQL error messages. Added the HEAD function as an aggregate function. Lindorm-cli now supports the MySQL protocol to connect to LindormTable.
2025-03-27	Enhancements	Added a memory protection mechanism for SQL queries to prevent server memory exhaustion. Fixed a performance degradation issue that occurred when the SQL version was rolled back to `sqlv2`. Improved the pushdown performance for global queries (`SELECT *`). Fixed a performance degradation issue that occurred after SSL encryption was enabled. Improved HBase protocol compatibility. Improved SQL-on-HBase compatibility. Improved cache replacement speed during significant fluctuations in query patterns to enhance query stability.

2.7.x

2.7.6

Release date	Type	Description
2024-12-06	New features	Supports MySQL-style time zone configurations. For more information, see How to set the connection time zone. Supports the MATCH full-text search function. For more information, see MATCH function. You can now view SQL audit logs in the console. For more information, see SQL audit logs. You can now use the mysql-connector-python connector to connect to LindormTable. For more information, see Develop an application based on Python (mysql-connector-python).
2024-12-06	Improvements	Improved the performance of aggregate requests by optimizing their execution logic. Optimized the historical data build logic for secondary indexes to resolve occasional build failures. Optimized the retry logic for request execution to reduce potential errors during shard movement or splitting. Optimized the execution logic for `IN` requests, improving the execution efficiency for requests that contain a large number of `IN` queries. Further optimized the self-healing logic for hotspots to detect and resolve hotspot sharding issues with finer granularity. Improved compatibility with the HBase protocol. Expanded support for and improved compatibility with MySQL syntax. Made miscellaneous stability improvements.

2.7.1

Release date	Type	Description
2024-07-11	New features	You can now use expressions containing the MD5 or SHA256 function as secondary index keys. For more information, see Secondary index function expressions. You can now use SQL to set the maximum number of connections to LindormTable. For more information, see ALTER SYSTEM configuration items. Lindorm GanosBase now supports S2 secondary indexes. For more information, see S2 secondary index. S2 indexes now support intersection queries.
2024-07-11	Improvements	Improved SQL point query performance. You can simultaneously build indexes for historical data in multiple index tables of a single table. Provided more detailed progress information for historical data builds on secondary indexes. Improved stability and enhanced MySQL syntax compatibility and coverage.

2.6.x

2.6.5

Release date	Category	Description
March 25, 2024	New features	Added support for two new parameters in search indexes: INDEX_SETTINGS for index attributes and mapping for index key attributes. For more information, see Index key definition (index_key_definition) and Search index key attributes. Lindorm Ganos now supports the S2 secondary index. For more information, see S2 secondary index. Lindorm Ganos now supports H3 functions for efficient spatio-temporal queries and analysis based on the H3 grid. For more information, see H3 functions.
March 25, 2024	Optimized features	Enhanced MySQL syntax compatibility and support. Lindorm SQL now supports physical plan reuse to improve query performance. Building a secondary index on historical data is now independent of cold storage. Resolved several compatibility issues for the Apache HBase client. If you use an Apache HBase client to access Lindorm, upgrade LindormTable to this version or later.

2.6.2

Release date	Category	Description
November 8, 2023	New features	Added support for the MySQL compatibility feature. For more information, see Use the MySQL protocol (Recommended).

2.5.x

2.5.6

Release date	Category	Description
August 18, 2023	Enhancements	Fixed an HBase protocol compatibility issue. Fixed load imbalances in multi-group deployments. Fixed other stability issues.

2.5.3

Release date

Category

Description

May 24, 2023

New features

Added support for wildcard column.

Enhancements

Fixed SQL request timeouts during short-circuit read and write operations.

Note
For optimal read and write performance, we recommend that users of Lindorm SQL upgrade to LindormTable version 2.5.3 or later.
Fixed a compatibility issue with the batch API of the Apache HBase client.
Fixed an issue that caused an excessive number of meta requests when using an Apache HBase client.

2.5.2

Release date	Category	Description
April 19, 2023	New features	Lindorm SQL now supports dropping columns from a table (drop column). For more information, see ALTER TABLE.
April 19, 2023	Enhancements	Improved SQL access to HBase tables. Improved query performance in hot and cold data separation scenarios. Improved the performance of asynchronous audit log processing. Improved compatibility with the Apache HBase client protocol. Increased the maximum number of files for region monitoring. Improved the execution efficiency of AGGREGATE statements. Reduced CPU consumption caused by data expiration in short time to live (TTL) scenarios.

2.4.x

2.4.3

Release date	Type	Description
March 10, 2023	Optimized features	Improved the Lindorm SQL user experience. Other stability fixes.

2.4.2

Release date	Type	Description
December 13, 2022	New features	You can now directly access LindormTable by using open source HBase clients. Added support for hot and cold data separation based on a custom time column (recommended for Lindorm SQL users).
December 13, 2022	Optimized features	Improved the user experience of the JSON data type. Other stability fixes.

2.4.1

Release date	Type	Description
November 1, 2022	Optimized features	Improved the user experience of the Lindorm GanosBase spatiotemporal feature. Fixed Lindorm SQL bugs.

2.4.0

Release date	Type	Description
October 9, 2022	New features	Added support for using SQL to access HBase tables.
October 9, 2022	Optimized features	Improved the Lindorm SQL user experience.

2.3.x

2.3.4

Release date	Type	Description
August 30, 2022	Optimized features	Improves the Lindorm SQL user experience.

2.3.3

Release date	Type	Description
August 16, 2022	Optimized features	Automatically identifies and processes hot data. Lindorm Ganos supports the ST_DWithin and ST_DWithinSphere functions. Fixed other stability issues.

2.3.2

Release date	Type	Description
August 2, 2022	Optimized features	Enhanced Lindorm SQL syntax. Supports more Lindorm GanosBase features. For more information, see Overview.

2.3.1

Release date	Type	Description
June 30, 2022	New features	Introduced the spatial-temporal service. For more information, see the Overview.

2.2.x

Version	Release date	Type	Description
2.2.21	April 25, 2022	Feature Optimizations	Optimized DirectMemory consumption during write operations. Optimized the load balancing strategy. Optimized compaction parameters and enabled support for adaptive tuning. Improved index building speed. Optimized the read and write performance of Lindorm SQL.
2.2.20	March 16, 2022	Feature Optimizations	Optimized write performance for large key-value pairs. Lindorm SQL now supports reading multiple data versions and writing data with custom timestamps. Fixed other performance issues.
2.2.19	February 9, 2022	New Features	Added support for dynamic columns and SQL-layer monitoring in Lindorm SQL.
2.2.19	February 9, 2022	Feature Optimizations	Fixed delayed metadata updates after modifying Lindorm SQL table properties. Fixed stability issues.
2.2.18	January 5, 2022	Feature Optimizations	Optimized the performance of Lindorm SQL. Fixed time zone issues with the `Date` and `Time` data types in Lindorm SQL. Fixed stability issues.
2.2.17	December 17, 2021	Feature Optimizations	Fixed bugs in Lindorm SQL. Improved startup speed for cold storage regions. If you use cold storage, we recommend upgrading LindormTable to version 2.2.17 or later.
2.2.16	November 12, 2021	Feature Optimizations	Enhanced the syntax of Lindorm SQL. If you use SQL, we recommend upgrading LindormTable to version 2.2.16 or later. Optimized the disk flushing logic to prevent out-of-memory errors when a large number of regions exist. Fixed other bugs.
2.2.15	October 18, 2021	Feature Optimizations	Fixed issues in Lindorm SQL that could cause table creation to fail or block access to tables with strong consistency. We recommend upgrading to this or a later version.
2.2.12	September 6, 2021	Feature Optimizations	Optimized the compaction strategy to improve efficiency. Optimized the amount of data returned by scan operations.
2.2.11	August 25, 2021	New Features	Added support for Lindorm SQL. Added support for secondary indexes.
2.2.10	August 12, 2021	Feature Optimizations	Fixed an issue where requests to cold storage could fail during network jitters.
2.2.9	June 9, 2021	New Features	The SearchIndex feature now supports dynamically generating analyzer configurations and includes several bug fixes.
2.2.8	March 25, 2021	Feature Optimizations	Optimized memory usage during zstd compression.
2.2.7	March 11, 2021	New Features	Added support for exporting data from Lindorm in sequence. This feature requires Lindorm Tunnel Service.
2.2.5	January 7, 2021	New Features	Added support for exporting incremental data from Lindorm. This feature requires Lindorm Tunnel Service.
2.2.1	September 9, 2020	Feature Optimizations	Enhanced SearchIndex and fixed several bugs.

2.1.x

Version	Release date	Type	Description
2.1.30	October 26, 2020	Feature optimization	Optimized the flush region selection algorithm in write hotspot scenarios.
2.1.26	October 9, 2020	Feature optimization	Optimized the memory overhead of BucketCache for lower-specification instances.
2.1.25	September 30, 2020	Feature optimization	Reduced the amount of redundant data retrieved during a reverse scan.
2.1.23	September 22, 2020	Feature optimization	Optimized memory management for low-memory instances.
2.1.21	July 20, 2020	Feature optimization	This is a recommended upgrade. Optimized write throughput. Optimized reverse scan performance. Optimized data archival speed from hot storage to cold storage for the hot and cold data separation feature.
2.1.17	March 20, 2020	Feature optimization	Improved the user experience of SearchIndex.
2.1.15	February 6, 2020	Feature optimization	Optimized SearchIndex and fixed some defects.
2.1.12	December 16, 2019	Feature optimization	Optimized SearchIndex and fixed bulk loading issues.
2.1.10	November 16, 2019	New feature	Added support for SearchIndex.
2.1.10	November 16, 2019	Feature optimization	Optimized hot and cold data separation.
2.1.9	October 8, 2019	New feature	Added support for SearchIndex and fixed some defects.
2.1.8	September 9, 2019	New feature	Added support for cold storage and hot and cold data separation.