3.1.3
Release date: September 25, 2023
New Features
- The aggregate function group_concat supports the DISTINCT keyword and the ORDER BY clause. #28778
- Stream Load, Broker Load, Kafka Connector, Flink Connector, and Spark Connector support partial updates in column mode on a Primary Key table. #28288
- Data in partitions can be automatically cooled down over time. (This feature is not supported for list partitioning.) #29335 #29393
Improvements
- Executing SQL commands with invalid comments now returns results consistent with MySQL. #30210
Bug Fixes
Fixed the following issues:
- If the BITMAP or HLL data type is specified in the WHERE clause of a DELETE statement to be executed, the statement cannot be properly executed. #28592
- After a follower FE is restarted, CpuCores statistics are not up-to-date, resulting in query performance degradation. #28472 #30434
- The execution cost of the to_bitmap() function is incorrectly calculated. As a result, an inappropriate execution plan is selected for the function after materialized views are rewritten. #29961
- In certain use cases of the shared-data architecture, after a follower FE is restarted, queries submitted to the follower FE return an error that reads "Backend node not found. Check if any backend node is down". #28615
- If data is continuously loaded into a table that is being altered by using the ALTER TABLE statement, an error "Tablet is in error state" may be thrown. #29364
- Modifying the FE dynamic parameter max_broker_load_job_concurrency using the ADMIN SET FRONTEND CONFIG command does not take effect. #29964 #29720
- BEs crash if the time unit in the date_diff() function is a constant but the dates are not constants. #29937
- In the shared-data architecture, automatic partitioning does not take effect after asynchronous load is enabled. #29986
- If users create a Primary Key table by using the CREATE TABLE LIKE statement, an error "Unexpected exception: Unknown properties: {persistent_index_type=LOCAL}" is thrown. #30255
- Restoring Primary Key tables causes metadata inconsistency after BEs are restarted. #30135
- If users load data into a Primary Key table on which truncate operations and queries are concurrently performed, an error "java.lang.NullPointerException" is thrown in certain cases. #30573
- If predicate expressions are specified in materialized view creation statements, the refresh results of those materialized views are incorrect. #29904
- After users upgrade their StarRocks cluster to v3.1.2, the storage volume properties of the tables created before the upgrade are reset to null. #30647
- If checkpointing and restoration are concurrently performed on tablet metadata, some tablet replicas will be lost and cannot be retrieved. #30603
- If users use CloudCanal to load data into table columns that are set to NOT NULL but have no default value specified, an error "Unsupported dataFormat value is : \N" is thrown. #30799