Release Note 2.0.7

[xiaokang]

Previous Release Note 2.0.6

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

1 Behavior change

• round function defaults to rounding normally as MySQL, eg. round(5/2) return 3 instead of 2.
  • [feature](function) round function defaults to rounding normally #31583
• round datetime with scale from string literal as MySQL, eg. round '2023-10-12 14:31:49.666' to '2023-10-12 14:31:50' .
  • [FIX](serde)fix datetimev2 serde parse from string with scale #27965

2 New features

• Support make miss slot as null alias when converting outer join to anti join to speed up query
  • [feature](Nereids): support make miss slot as null alias when converting anti join #31854
• Enable proxy protocol to support IP transparency for Nginx and HAProxy.
  • [feature](proxy-protocol) Support proxy protocol v1 #32338

3 Improvement and optimizations

• Add DEFAULT_ENCRYPTION column in information_schema table and add processlist table for better compatibility for BI tools
• Automatically test connectivity by default when creating a JDBC Catalog.
• Enhance auto resume to keep routine load stable
• Use lowercase by default for Chinese tokenizer in inverted index
• add error msg if exceeded maximum default value in repeat function
• skip hidden file and dir in hive table
• reduce file meta cache size and disable cache for some cases to avoid OOM
• Reduce jvm heap memory consumed by profiles of BrokerLoadJob
• Remove sort which is under table sink to speed up query like INSERT INTO t1 SELECT * FROM t2 ORDER BY k.

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

Big Thanks

Thanks all who contribute to this release:

@924060929
@airborne12
@amorynan
@ByteYue
@dataroaring
@deardeng
@feiniaofeiafei
@felixwluo
@freemandealer
@gavinchou
@hello-stephen
@HHoflittlefish777
@jacktengg
@jackwener
@jeffreys-cat
@Jibing-Li
@KassieZ
@LiBinfeng-01
@luwei16
@morningman
@mrhhsg
@Mryange
@nextdreamblue
@platoneko
@qidaye
@rohitrs1983
@seawinde
@shuke987
@starocean999
@swjtu-zhanglei
@w41ter
@wsjz
@wuwenchi
@xiaokang
@XieJiann
@XuJianxu
@yujun777
@Yulei-Yang
@zhangstar333
@zhiqiang-hhhh
@zy-kkk
@zzzxl1993

[xiaokang]

中文版本：

1 行为变更

• round 函数行为跟MySQL保持一致, 例如 round(5/2) 返回3而不是2.
  • [feature](function) round function defaults to rounding normally #31583
• 时间精度转换行为跟MySQL保持一致, 例如 '2023-10-12 14:31:49.666' 四舍五人到 '2023-10-12 14:31:50' .
  • [FIX](serde)fix datetimev2 serde parse from string with scale #27965

2 新功能

• 在更多的情况下可以将OUTER JOIN转换成ANTI JOIN来加速查询
  • [feature](Nereids): support make miss slot as null alias when converting anti join #31854
• 支持通过Nginx, HAProxy等代理连接的IP透传
  • [feature](proxy-protocol) Support proxy protocol v1 #32338

3 改进和优化

• 通过在information_schema中增加DEFAULT_ENCRYPTION列、增加processlist表，提升BI工具的兼容性
• 创建JDBC Catalog时默认自动检测连通性
• 增强自动恢复提升kafka routine load的稳定性
• 倒排索引中文分词对英文默认做小写转换
• repeat函数的重复次数超过限制时报错
• 自动跳过Hive外表中的隐藏文件和目录
• 在某些极端情况下减少file meta cache避免OOM
• 减少broker load的jvm内存占用
• 加速带排序的INSERT INTO SELECT 比如 INSERT INTO t1 SELECT * FROM t2 ORDER BY k

[Mockito-0723]

2.0.7 何时能下载

[github-actions]

We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!