Release Note 2.0.12

[xiaokang]

Previous Release Note 2.0.11

Thanks to our community developers and users for their contributions. Doris version 2.0.12 will bring 99 improvements and bug fixes.

You can access the full list through the GitHub link , with the key features and improvements highlighted below.

1 Behavior change

• No longer set the default table comment to the table type. Instead, set it to be empty by default, for example, change COMMENT 'OLAP' to COMMENT ''. This new behavior is more friendly for BI software that relies on table comments.
  • [fix](DDL) not set table type as default comment when create table #35855
• Change the type of the @@autocommit variable from BOOLEAN to BIGINT to prevent errors from certain MySQL clients (such as .NET MySQL.Data).
  • [fix](variables) change column type of @@autocommit to BIGINT #33282

2 New features

N/A

3 Improvement and optimizations

• Remove the disable_nested_complex_type parameter and allow the creation of nested ARRAY, MAP, and STRUCT types by default.

  • [Improve](complex type) delete fe config disable_nested_complex_type #36255

• The HMS catalog supports the SHOW CREATE DATABASE command.

  • [Improvement](hms catalog) support show_create_database for hms catalog #28145

• Add more inverted index metrics to the query profile.

  • [opt](index) add more inverted index query profile #36545

• Cross-Cluster Replication (CCR) supports inverted indices.

  • [improvement](binlog)Support inverted index in CCR #31743

Big Thanks

Thanks all who contribute to this release:
@airborne12
@amorynan
@BiteTheDDDDt
@cambyzju
@caoliang-web
@dataroaring
@eldenmoon
@feiniaofeiafei
@felixwluo
@gavinchou
@HappenLee
@hello-stephen
@jacktengg
@Jibing-Li
@Johnnyssc
@liaoxin01
@LiBinfeng-01
@luwei16
@mongo360
@morningman
@morrySnow
@mrhhsg
@Mryange
@mymeiyi
@qidaye
@qzsee
@starocean999
@w41ter
@wangbo
@wsjz
@wuwenchi
@xiaokang
@XuPengfei-1020
@xy720
@yongjinhou
@yujun777
@Yukang-Lian
@Yulei-Yang
@zclllyybb
@zddr
@zhannngchen
@zhiqiang-hhhh
@zy-kkk
@zzzxl1993

[xiaokang]

中文版本

1 行为变更

• 不再将建表的默认注释设置为表的类型，而是改成默认为空，比如COMMENT 'OLAP' 变成 COMMENT ''，这样对于依赖注释的BI软件更加友好
  • [fix](DDL) not set table type as default comment when create table #35855
• 将autocommit变量的类型从BOOLEAN改成BIGINT，以免有些mysql客户端（比如.NET MySQL.Data）报错
  • [fix](variables) change column type of @@autocommit to BIGINT #33282

2 新功能

无

3 改进和优化

• 删除 disable_nested_complex_type 参数，默认允许创建嵌套的 ARRAY MAP STRUCT 类型

  • [Improve](complex type) delete fe config disable_nested_complex_type #36255

• HMS catalog 支持 SHOW CREATE DATABASE 命令

  • [Improvement](hms catalog) support show_create_database for hms catalog #28145

• 在query profile中增加更多倒排索引的指标

  • [opt](index) add more inverted index query profile #36545

• 跨集群数据复制（CCR）支持倒排索引

  • [improvement](binlog)Support inverted index in CCR #31743