docs/en/release_notes/release-3.0.md
Release date: January 2, 2024
max_tablet_rowset_num for setting the maximum allowed number of rowsets. This metric helps detect possible compaction issues and thus reduces the occurrences of the error "too many versions". #36539GROUP_CONCAT_LEGACY is added to the session variable sql_mode to provide compatibility with the implementation logic of the group_concat function in versions earlier than v2.5. #36150be_tablets view in the information_schema database provides a new field INDEX_DISK, which records the disk usage (measured in bytes) of persistent indexes #35615% or _, the LIKE operator is converted into the = operator. #37515enable_materialized_view_for_insert, which controls whether materialized views rewrite the queries in INSERT INTO SELECT statements. The default value is false. #37505enable_new_publish_mechanism to a static parameter from a dynamic one. You must restart the FE after you modify the parameter settings. #35338cbo_decimal_cast_string_strict, which controls how the CBO converts data from the DECIMAL type to the STRING type. If this variable is set to true, the logic built in v2.5.x and later versions prevails and the system implements strict conversion (namely, the system truncates the generated string and fills 0s based on the scale length). If this variable is set to false, the logic built in versions earlier than v2.5.x prevails and the system processes all valid digits to generate a string. The default value is true. #34208transaction_read_only and tx_read_only to specify the transaction access mode, which are compatible with MySQL versions 5.7.20 and above. #37249routine_load_unstable_threshold_second. #36222http_worker_threads_num, which specifies the number of threads for HTTP server to deal with HTTP requests. The default value is 0. If the value for this parameter is set to a negative value or 0, the actual thread number is twice the number of CPU cores. #37530default_mv_refresh_immediate, which specifies whether to immediately refresh the materialized view after the materialized view is created. The default value is true. #37093enable_stream_load_verbose_log. The default value is false. With this parameter set to true, StarRocks can record the HTTP requests and responses for Stream Load jobs, making troubleshooting easier. #36113pindex_major_compaction_limit_per_disk to configure the maximum concurrency of compaction on a disk. This addresses the issue of uneven I/O across disks due to compaction. This issue can cause excessively high I/O for certain disks. The default value is 1. #37694object_storage_connect_timeout_ms: Timeout duration to establish socket connections with object storage. The default value is -1, which means to use the default timeout duration of the SDK configurations.object_storage_request_timeout_ms: Timeout duration to establish HTTP connections with object storage. The default value is -1, which means to use the default timeout duration of the SDK configurations.Fixed the following issues:
recover_with_empty_tablet to true may cause FEs to crash. #33071show proc '/statistic' may cause a deadlock. #34237enable_collect_query_detail_info is set to true. #35945INFORMATION_SCHEMA is queried by using the database driver MariaDB ODBC, the CATALOG_NAME column returned in the schemata view holds only null values. #34627/) at the end of the HDFS storage path causes the backup and restore of the data from HDFS to fail. #34601partition_live_number property added by using the ALTER TABLE statement does not take effect. #34842bitmap_to_string may return incorrect result due to data type overflow. #37405Release date: November 17, 2023
COLUMNS view in the system database INFORMATION_SCHEMA can display ARRAY, MAP, and STRUCT columns. #33431Fixed the following issues:
show proc '/current_queries'; is being executed and meanwhile a query begins to be executed, BEs may crash. #34316cast() function is the same as the original data type. #31465DATA_TYPE and COLUMN_TYPE for BINARY or VARBINARY data types are displayed as unknown in the information_schema.columns view. #32678Release date: October 18, 2023
Fixed the following issues:
NOT NULL but have no default value specified, an error "Unsupported dataFormat value is : \N" is thrown. #30799information_schema.COLUMNS. As a result, DELETE operations cannot be performed when data is loaded by using Flink Connector. #31458Release date: September 12, 2023
enable_strict_type. The default value of this session variable is false. #21870enable_orc_late_materialization is set to true, an unexpected result is returned when a Hive catalog is used to query STRUCT-type data in ORC files. #27971show_data for cloud-native tables are incorrect. #29473Default field values returned by the SHOW FULL COLUMNS statement for columns of the BITMAP or HLL data type are incorrect. #29510max_broker_load_job_concurrency using the ADMIN SET FRONTEND CONFIG command does not take effect.unknown error is returned when select count(distinct(int+double)) from table_name is executed. #29691Release date: August 16, 2023
xxx too many versions xxx. #28397Fixed the following issues:
CANCELED. #26913information_schema.task_runs table. #28060Release date: July 18, 2023
Queries can be rewritten even when the queries contain a different type of join than the materialized view. #25099
sql_dialect) is set to trino, table aliases are not case-sensitive. #26094 #25282table_id to the table Information_schema.tables_config. You can join the table tables_config with the table be_tablets on the column table_id in the database Information_schema to query the names of the database and table to which a tablet belongs. #24061Fixed the following issues:
ERROR xxx: Unknown table property xxx occurs when the ALTER TABLE statement is used to modify the table's property default.storage_medium. #25870Release date: June 28, 2023
Fixed the following issues:
enable_profile is set to true. #25060Release date: June 13, 2023
Fixed the following issues:
pipeline_profile_level is set to 0. #23873cloud_native_storage_type is set to S3.If your system has a database named starrocks, change it to another name using ALTER DATABASE RENAME before the upgrade. This is because starrocks is the name of a default system database that stores privilege information.
Release date: June 1, 2023
load_tracking_logs to Information Schema to record recent loading errors.Fixed the following issues:
If your system has a database named starrocks, change it to another name using ALTER DATABASE RENAME before the upgrade. This is because starrocks is the name of a default system database that stores privilege information.
Release date: April 28, 2023
sql_dialect.pipeline_dop parameter for query concurrency.ORDER BY when you create a table.show full fields from 'table'. #17233count(distinct) and count(distinct) is applied to the DISTRIBUTED BY column. #16558You can upgrade from v2.5 to v3.0 or downgrade from v3.0 to v2.5.
In theory, an upgrade from a version earlier than v2.5 is also supported. To ensure system availability, we recommend that you first upgrade your cluster to v2.5 and then to v3.0.
Take note of the following points when you perform a downgrade from v3.0 to v2.5.
StarRocks upgrades the BDB library in v3.0. However, BDBJE cannot be rolled back. You must use BDB library of v3.0 after a downgrade. Perform the following steps:
After you replace the FE package with a v2.5 package, copy fe/lib/starrocks-bdb-je-18.3.13.jar of v3.0 to the fe/lib directory of v2.5.
Delete fe/lib/je-7.*.jar.
The new RBAC privilege system is used by default after you upgrade to v3.0. You can only downgrade to v2.5.
After a downgrade, run ALTER SYSTEM CREATE IMAGE to create a new image and wait for the new image to be synchronized to all follower FEs. If you do not run this command, some of the downgrade operations may fail. This command is supported from 2.5.3 and later.
For details about the differences between the privilege system of v2.5 and v3.0, see "Upgrade notes" in Privileges supported by StarRocks.