Starrocks

Bugfix

The following bugs are fixed:
- BEs may crash if an expression encounters an error in the initial stage. [11395](https://github.com/StarRocks/starrocks/pull/11395)
- BEs may crash if invalid JSON data is loaded. [10804](https://github.com/StarRocks/starrocks/issues/10804)
- Parallel writing encounters an error when the pipeline engine is enabled. [11451](https://github.com/StarRocks/starrocks/issues/11451)
- BEs crash when the ORDER BY NULL LIMIT clause is used. [11648](https://github.com/StarRocks/starrocks/issues/11648)
- BEs crash if the column type defined in the external table is different from the column type in the source Parquet file. [11839](https://github.com/StarRocks/starrocks/issues/11839)

Bug Fixes
The following bugs are fixed:
- Data may be lost when JSON data is loaded. [11054](https://github.com/StarRocks/starrocks/issues/11054)
- The output from SHOW FULL TABLES is incorrect. [11126](https://github.com/StarRocks/starrocks/issues/11126)
- In previous versions, to access data in a view, users must have permissions on both the base tables and the view. In the current version, users are only required to have permissions on the view. [11290](https://github.com/StarRocks/starrocks/pull/11290)
- The result from a complex query that is nested with EXISTS or IN is incorrect. [11415](https://github.com/StarRocks/starrocks/pull/11415)
- REFRESH EXTERNAL TABLE fails when the schema of the corresponding Hive table is changed. [11406](https://github.com/StarRocks/starrocks/pull/11406)
- An error may occur when a non-leader FE replays the bitmap index creation operation. [11261](https://github.com/StarRocks/starrocks/pull/11261)

Bug Fixes
The following bugs are fixed:
- The result of order by... limit...offset is incorrect when the subquery contains LIMIT.
- The BE crashes when partial update is performed on a table with large data volume.
- Compaction causes memory to overflow when the size of BITMAP data exceeds 2 GB.
- The like() and regexp() functions do not work if the pattern length exceeds 16 KB.

Behavior Changes
- The format used to represent array<json> values in the output is modified. Escape characters are no longer used in the returned JSON values. For example, [{"k1":"v1"}] is returned, instead of "[{\"k1\":\"v1\"}]".

Release date: August 18, 2022

Improvements

- Improved the system performance when the pipeline engine is enabled. [9580](https://github.com/StarRocks/starrocks/pull/9580)
- Improved the accuracy of memory usage metrics for index metadata. [9837](https://github.com/StarRocks/starrocks/pull/9837)

Bug Fixes

The following bugs are fixed:
- BEs may be stuck in querying Kafka partition offsets (get_partition_offset) during Routine Load. [9937](https://github.com/StarRocks/starrocks/pull/9937)
- An error occurs when multiple Broker Load threads attempt to load the same HDFS file. [9507](https://github.com/StarRocks/starrocks/pull/9507)

Improvements
- Supports synchronizing schema changes on Hive table to the corresponding external table. [9010](https://github.com/StarRocks/starrocks/pull/9010)
- Supports loading ARRAY data in Parquet files via Broker Load. [9131](https://github.com/StarRocks/starrocks/pull/9131)

Bug Fixes
The following bugs are fixed:
- Broker Load cannot handle Kerberos logins with multiple keytab files. [8820](https://github.com/StarRocks/starrocks/pull/8820) [#8837](https://github.com/StarRocks/starrocks/pull/8837)
- Supervisor may fail to restart services if **stop_be.sh** exits immediately after it is executed. [9175](https://github.com/StarRocks/starrocks/pull/9175)
- Incorrect Join Reorder precedence causes error "Column cannot be resolved". [9063](https://github.com/StarRocks/starrocks/pull/9063) [#9487](https://github.com/StarRocks/starrocks/pull/9487)

Release date: July 25, 2022


Bug Fixes
The following bugs are fixed:
- An error occurs when users delete a resource group. [8036](https://github.com/StarRocks/starrocks/pull/8036)
- Thrift server exits when the number of threads is insufficient. [7974](https://github.com/StarRocks/starrocks/pull/7974)
- In some scenarios, join reorder in CBO returns no results. [7099](https://github.com/StarRocks/starrocks/pull/7099) [#7831](https://github.com/StarRocks/starrocks/pull/7831) [#6866](https://github.com/StarRocks/starrocks/pull/6866)