Release date: August 16, 2023
New Features
- Supports aggregate functions COVAR_SAMP, COVAR_POP, and CORR.
- Supports the following window functions: COVAR_SAMP, COVAR_POP, CORR, VARIANCE, VAR_SAMP, STD, and STDDEV_SAMP.
Improvements
- Added more prompts in the error message xxx too many versions xxx. #28397
- Dynamic partitioning further supports the partitioning unit to be year. #28386
- The partitioning field is case-insensitive when expression partitioning is used at table creation and INSERT OVERWRITE is used to overwrite data in a specific partition. #28309
Bug Fixes
Fixed the following issues:
- Incorrect table-level scan statistics in FE cause inaccurate metrics for table queries and loading. #27779
- The query result is not stable if the sort key is modified for a partitioned table. #27850
- The version number for a tablet is inconsistent between the BE and FE after data is restored. #26518
- If the bucket number is not specified when users create a Colocation table, the number will be inferred as 0, which causes failures in adding new partitions. #27086
- When the SELECT result set of INSERT INTO SELECT is empty, the load job status returned by SHOW LOAD is CANCELED. #26913
- BEs may crash when the input values of the sub_bitmap function are not of the BITMAP type. #27982
- BEs may crash when the AUTO_INCREMENT column is being updated. #27199
- Outer join and Anti join rewrite errors for materialized views. #28028
- Inaccurate estimation of average row size causes Primary Key partial updates to occupy excessively large memory. #27485
- Activating an inactive materialized view may cause a FE to crash. #27959
- Queries can not be rewritten to materialized views created based on external tables in a Hudi catalog. #28023
- The data of a Hive table can still be queried even after the table is dropped and the metadata cache is manually updated. #28223
- Manually refreshing an asynchronous materialized view via a synchronous call results in multiple INSERT OVERWRITE records in the information_schema.task_runs table. #28060
- FE memory leak caused by blocked LabelCleaner threads. #28311