Release date: June 14, 2023
New features
- Inactive materialized views can be manually activated using ALTER MATERIALIZED VIEW <mv_name> ACTIVE. You can use this SQL command to activate materialized views whose base tables were dropped and then recreated. For more information, see ALTER MATERIALIZED VIEW. #24001
- StarRocks can automatically set an appropriate number of tablets when you create a table or add a partition, eliminating the need for manual operations. For more information, see Determine the number of tablets. #10614
Improvements
- Optimized the I/O concurrency of Scan nodes used in external table queries, which reduces memory usage and improves the stability of data loading from external tables. #23617 #23624 #23626
- Optimized the error message for Broker Load jobs. The error message contains retry information and the name of erroneous files. #18038 #21982
Optimized the error message returned when CREATE TABLE times out and added parameter tuning tips. #24510 - Optimized the error message returned when ALTER TABLE fails because the table status is not Normal. #24381
Ignores full-width spaces in the CREATE TABLE statement. #23885 - Optimized the Broker access timeout to increase the success rate of Broker Load jobs. #22699
- For Primary Key tables, the VersionCount field returned by SHOW TABLET contains Rowsets that are in the Pending state. #23847
- Optimized the Persistent Index policy. #22140
Bug Fixes
Fixed the following issues:
- When users load Parquet data into StarRocks, DATETIME values overflow during type conversion, causing data errors. #22356
- Bucket information is lost after Dynamic Partitioning is disabled. #22595
- Using unsupported properties in the CREATE TABLE statement causes null pointer exceptions (NPEs). #23859
- Table permission filtering in information_schema becomes ineffective. As a result, users can view tables they do not have permission to. #23804
- Information returned by SHOW TABLE STATUS is incomplete. #24279
- Schema change for Primary Key tables is hung if data loading occurs simultaneously with schema change. #23456
- RocksDB WAL flush blocks the brpc worker from processing bthreads, which interrupts high-frequency data loading into Primary Key tables. #22489
- TIME-type columns that are not supported in StarRocks can be successfully created. #23474
- Materialized view Union rewrite fails. #22922