Release Note 2.0.9

[xiaokang]

Previous Release Note 2.0.8

Thanks to our community users and developers, about 68 improvements and bug fixes have been made in Doris 2.0.9 version.

Thank you for providing the text. Here is a modified version of the paragraph you've given:

We are grateful to our community users and developers for contributing to Doris 2.0.9, resulting in approximately 68 enhancements and bug fixes.

1. Behavioral Changes**

N/A

2. New Features**

• Allow predicate appearing on both key and value mv columns.
• Enable mv with bitmap_union(bitmap_from_array()).
• Introduce a configuration to forcibly replicate allocation for all olap tables within the cluster.
• Add timezone support for date literals in the new optimizer Nereids.
• Enable the use of "slop" in full-text search's match_phrase to specify word distances.
• Display index ID in SHOW PROC INDEXES.

3. Improvements and Optimizations**

• Incorporate a secondary argument in first_value/last_value to overlook NULL values.
• Allow the use of 0 as the offset parameter in the lead/lag function.
• Adjust the priority of the materialized view match rule for improved performance.
• Optimize topn operations by reading only a limited number of records for improved performance.
• Add profiling for the delete_bitmap get_agg function.
• Refine the meta cache for better performance.
• Introduce a fe configuration for autobucket_max_buckets.

See the complete list of improvements and bug fixes on github .

Big Thanks

Thanks all who contribute to this release:

@adonis0147
@airborne12
@amorynan
@AshinGau
@BePPPower
@BiteTheDDDDt
@CalvinKirs
@cambyzju
@csun5285
@eldenmoon
@englefly
@feiniaofeiafei
@HHoflittlefish777
@htyoung
@hust-hhb
@jackwener
@Jibing-Li
@kaijchen
@kylinmac
@liaoxin01
@luwei16
@morningman
@mrhhsg
@qidaye
@starocean999
@SWJTU-ZhangLei
@w41ter
@xiaokang
@xiedeyantu
@xy720
@zclllyybb
@zhangstar333
@zhannngchen
@zy-kkk
@zzzxl1993

[xiaokang]

中文版本：

1 行为变更

无

2 新功能

• 物化视图的key和value列都允许出现谓词
• 物化视图支持bitmap_union(bitmap_from_array())
• 增加一个fe配置强制集群中所有表的replicate allocation
• 新优化器支持日期字面量指定时区
• MATCH_PHRASE全文检索支持slop参数指定搜索词之间的距离

3 改进和优化

• first_value/last_value 函数增加第二个参数指定忽略NULL值
• lead/lag function 的offset参数可以为0
• 调整物化视图匹配的顺序优先利用索引和预聚合加速查询
• 优化topn查询ORDER BY k LIMIT n的性能
• 优化meta cache的性能
• 为delete_bitmap get_agg函数增加profile便于性能分析
• 增加fe参数设置autobucket的最大bucket数

[sdhzwc]

雾化试图支持
这里面有错别字

[xiaokang]

雾化试图支持 这里面有错别字

谢谢反馈，@adonis0147 帮忙修正了