Edit

StarRocks version 2.5

2.5.3

Release date: March 10, 2023

Improvements

  • Optimized query rewrite for materialized views (MVs).
    • Supports rewriting queries with Outer Join and Cross Join. #18629
    • Optimized the data scan logic for MVs, further accelerating the rewritten queries. #18629
    • Enhanced rewrite capabilities for single-table aggregate queries. #18629
    • Enhanced rewrite capabilities in View Delta scenarios, which is when the queried tables are a subset of the MV's base tables. #18800
  • Optimized the performance and memory usage when the window function RANK() is used as a filter or a sort key. #17553

Bug Fixes

The following bugs are fixed:

  • Errors caused by null literals [] in ARRAY data. #18563
  • Misuse of the low-cardinality optimization dictionary in some complex query scenarios. The dictionary mapping check is now added before applying the dictionary. #17318
  • In a single BE environment, Local Shuffle causes GROUP BY to produce duplicate results. #17845
  • Misuses of partition-related PROPERTIES for a non-partitioned MV may cause the MV refresh to fail. The partition PROPERTIES check is now performed when users create an MV. #18741
  • Errors in parsing Parquet Repetition columns. #17626 #17788 #18051
  • The obtained column's nullable information is incorrect. Solution: When CTAS is used to create a Primary Key table, only the primary key columns are non-nullable; non-primary key columns are nullable. #16431
  • Some issues caused by deleting data from Primary Key tables. #18768

2.5.2

Release date: February 21, 2023

New Features

  • Supports using the Instance Profile and Assumed Role-based credential methods to access AWS S3 and AWS Glue. #15958
  • Supports the following bit functions: bit_shift_left, bit_shift_right, and bit_shift_right_logical. #14151

Improvements

  • Optimized the memory release logic, which significantly reduces peak memory usage when a query contains a large number of aggregate queries. #16913
  • Reduced the memory usage of sorting. The memory consumption is halved when a query involves window functions or sorting. #16937 #17362 #17408

Bug Fixes

The following bugs are fixed:

  • Apache Hive external tables that contain MAP and ARRAY data cannot be refreshed. #17548
  • Superset cannot identify column types of materialized views. #17686
  • BI connectivity fails because SET GLOBAL/SESSION TRANSACTION cannot be parsed. #17295
  • The bucket number of dynamic partitioned tables in a Colocate Group cannot be modified and an error message is returned. #17418
  • Potential issues caused by a failure in the Prepare stage. #17323

Behavior Change

  • Added CHARACTER to the reserved keyword list. #17488

2.5.1

Release date: February 5, 2023

Improvements

  • Asynchronous materialized views created based on external catalogs support query rewrite. #11116 #15791
  • Allows users to specify a collection period for automatic CBO statistics collection, which prevents cluster performance jitter caused by automatic full collection. #14996
  • Added Thrift server queue. Requests that cannot be processed immediately during INSERT INTO SELECT can be pending in the Thrift server queue, preventing requests from being rejected. #14571
  • Deprecated the FE parameter default_storage_medium. If storage_medium is not explicitly specified when users create a table, the system automatically infers the storage medium of the table based on BE disk type. For more information, see description of storage_medium in CREATE TABLE. #14394

Bug Fixes

The following bugs are fixed:

  • Null pointer exception (NPE) caused by SET PASSWORD. #15247
  • JSON data with empty keys cannot be parsed. #16852
  • Data of invalid types can be successfully converted into ARRAY data. #16866
  • Nested Loop Join cannot be interrupted when an exception occurs. #16875

Behavior Change

  • Deprecated the FE parameter default_storage_medium. The storage medium of a table is automatically inferred by the system. #14394

2.5.0

Release date: January 22, 2023

New Features

Improvements

  • Optimized the metadata access performance when you query external data using Hive catalogs, Hudi catalogs, and Iceberg catalogs. #11349
  • Supports querying ARRAY data using Elasticsearch external tables. #9693
  • Optimized the following aspects of materialized views:
    • Asynchronous materialized views support automatic and transparent query rewrite based on the SPJG-type materialized views. For more information, see Materialized view. #13193
    • Asynchronous materialized views support multiple async refresh mechanisms. For more information, see Materialized view. #12712 #13171 #13229 #12926
    • The efficiency of refreshing materialized views is improved. #13167
  • StarRocks automatically sets an appropriate number of tablets when you create a table, eliminating the need for manual operations. For more information, see CREATE TABLE. #10614
  • Optimized the following aspects of data loading:
    • Optimized loading performance in multi-replica scenarios by supporting the "single leader replication" mode. Data loading gains a one-fold performance lift. For more information about "single leader replication", see replicated_storage in CREATE TABLE. #10138
    • Broker Load and Spark Load no longer need to depend on brokers for data loading when only one HDFS cluster or one Kerberos user is configured. However, if you have multiple HDFS clusters or multiple Kerberos users, you still need to deploy a broker. For more information, see Load data from HDFS or cloud storage and Bulk load using Apache Spark™. #9049 #9228
    • Optimized the performance of Broker Load when a large number of small ORC files are loaded. #11380
    • Reduced the memory usage when you load data into tables of the Primary Key Model.
  • Optimized the information_schema database and the tables and columns tables within. Adds a new table table_config. For more information, see Information Schema. #10033
  • Optimized data backup and restore:
    • Supports backing up and restoring data from multiple tables in a database at a time. For more information, see Backup and restore data. #11619
    • Supports backing up and restoring data from Primary Key tables. For more information, see Backup and restore. #11885
  • Optimized the following functions:
    • Added an optional parameter for the time_slice function, which is used to determine whether the beginning or end of the time interval is returned. #11216
    • Added a new mode INCREASE for the window_funnel function to avoid computing duplicate timestamps. #10134
    • Supports specifying multiple arguments in the unnest function. #12484
    • lead() and lag() functions support querying HLL and BITMAP data. For more information, see Window function. #12108
    • The following ARRAY functions support querying JSON data: array_agg, array_sort, array_concat, array_slice, and reverse. #13155
    • Optimized the use of some functions. The current_date, current_timestamp, current_time, localtimestamp, and localtime functions can be executed without using (), for example, you can directly run select current_date;. # 14319
  • Removed some redundant information from FE logs. # 15374

Bug Fixes

The following bugs are fixed:

  • The append_trailing_char_if_absent() function may return an incorrect result when the first argument is empty. #13762
  • After a table is restored using the RECOVER statement, the table does not exist. #13921
  • The result returned by the SHOW CREATE MATERIALIZED VIEW statement does not contain the database and catalog specified in the query statement when the materialized view was created. #12833
  • Schema change jobs in the waiting_stable state cannot be canceled. #12530
  • Running the SHOW PROC '/statistic'; command on a Leader FE and non-Leader FE returns different results. #12491
  • The position of the ORDER BY clause is incorrect in the result returned by SHOW CREATE TABLE. # 13809
  • When users use Hive Catalog to query Hive data, if the execution plan generated by FE does not contain partition IDs, BEs fail to query Hive partition data. # 15486.

Behavior Change

  • Changed the default value of the AWS_EC2_METADATA_DISABLED parameter to False, which means that the metadata of Amazon EC2 is obtained to access AWS resources.
  • Renamed session variable is_report_success to enable_profile, which can be queried using the SHOW VARIABLES statement.
  • Added four reserved keywords: CURRENT_DATE, CURRENT_TIME, LOCALTIME, and LOCALTIMESTAMP. # 14319
  • The maximum length of table and database names can be up to 1023 characters. # 14929 # 15020
  • BE configuration items enable_event_based_compaction_framework and enable_size_tiered_compaction_strategy are set to true by default, which significantly reduces compaction overheads when there are a large number of tablets or a single tablet has large data volume.

Upgrade Notes

  • You can upgrade your cluster to 2.5.0 from 2.0.x, 2.1.x, 2.2.x, 2.3.x, or 2.4.x. However, if you need to perform a rollback, we recommend that you roll back only to 2.4.x.