Release Note 2.0.4

[xiaokang]

Previous Release Note 2.0.3

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

1 Behavior change

• more reasonable and accurate precision and scale inference for decimal data type
  • [improvement](decimal) use new way for decimal arithmetic precision promotion(#27787) #28034
• support drop policy for user or role
  • [fix](polixy)support drop policy for user or role #29488

2 New features

• support datev1, datetimev1 and decimalv2 datatypes in new optimizer Nereids.
• support ODBC table for new optimizer Nereids.
• add lower_case and ignore_above option for inverted index
• support match_regexp and match_phrase_prefix optimization by inverted index
• support paimon native reader in datalake
• support audit-log for insert into SQL
• support reading parquet file in lzo compressed format

3 Improvement and optimizations

• improve storage management including balance, migration, publish and others.
• improve storage cooldown policy to use save disk space.
• performance optimization for substr with ascii string.
• improve partition prune when date function is used.
• improve auto analyze visibility and performance.

See the complete list of improvements and bug fixes on github dev/2.0.4-merged .

Big Thanks

Thanks all who contribute to this release:
@airborne12
@amorynan
@AshinGau
@BePPPower
@bingquanzhao
@BiteTheDDDDt
@bobhan1
@ByteYue
@caiconghui
@CalvinKirs
@cambyzju
@caoliang-web
@catpineapple
@csun5285
@dataroaring
@deardeng
@dutyu
@eldenmoon
@englefly
@feifeifeimoon
@fornaix
@Gabriel39
@gnehil
@HappenLee
@hello-stephen
@HHoflittlefish777
@hubgeter
@hust-hhb
@ixzc
@jacktengg
@jackwener
@Jibing-Li
@kaka11chen
@KassieZ
@LemonLiTree
@liaoxin01
@LiBinfeng-01
@lihuigang
@liugddx
@luwei16
@morningman
@morrySnow
@mrhhsg
@Mryange
@nextdreamblue
@Nitin-Kashyap
@platoneko
@py023
@qidaye
@shuke987
@starocean999
@SWJTU-ZhangLei
@w41ter
@wangbo
@wsjz
@wuwenchi
@Xiaoccer
@xiaokang
@XieJiann
@xingyingone
@xinyiZzz
@xuwei0912
@xy720
@xzj7019
@yujun777
@zclllyybb
@zddr
@zhangguoqiang666
@zhangstar333
@zhannngchen
@zhiqiang-hhhh
@zy-kkk
@zzzxl1993

[Mockito-0723]

什么时候发布啊

[xiaokang]

什么时候发布啊

刚刚发起投票，预计72小时候正式发布

[xiaokang]

中文版release note

1 行为变更

• 更加合理，精确的precision和scale的推导，满足金融场景的计算需求
  • [improvement](decimal) use new way for decimal arithmetic precision promotion(#27787) #28034
• drop policy 支持 user 和 role
• [fix](polixy)support drop policy for user or role #29488

2 新功能

• 新优化器支持 datev1, datetimev1 和 decimalv2 数据类型
• 新优化器支持 ODBC 外表
• 倒排索引支持 lower_case 和 ignore_above 选项
• 倒排索引支持 match_regexp 和 match_phrase_prefix 查询加速
• 数据湖支持paimon native reader
• 数据湖支持读取lzo压缩的parquet文件
• 审计日志支持 insert into

3 改进和优化

• 数据均衡、迁移等存储管控相关的改进
• 改进数据冷却策略节省本地硬盘存储空间
• ASCII字符串substr优化
• 使用date函数时分区裁剪优化
• 优化器自动统计信息收集的可观测性和性能优化