Release Note 2.0.14

[xiaokang]

Previous Release Note 2.0.13

Thanks to our community users and developers, about 110 improvements and bug fixes have been made in Doris 2.0.14 version

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

1 Behavior change

NA

2 New features

• Adds a REST interface to retrieve the most recent query profile: curl http://user:password@127.0.0.1:8030/api/profile/text
  • [feat](FE) add rest api to get last profile #38268

3 Improvement and optimizations

• Optimizes the primary key point query performance for MOW tables with sequence columns
  • [opt](mow) opt mow lookup with sequence column #38287
• Enhances the performance of inverted index queries with many conditions
  • [opt](inverted index) performance optimization for need_read_data in compound #35346
• Automatically enables the support_phrase option when creating a tokenized inverted index to accelerate match_phrase phrase queries
  • [opt](inverted index) set support_phrase default true if parser is set #37949
• Supports simplified SQL hints, for example: SELECT /*+ query_timeout(3000) */ * FROM t;
  • [opt](Nereids) support no-key hint parameter #37720
• Automatically retries reading from object storage when encountering a 429 error to improve stability
  • [opt](s3) auto retry when meeting 429 error #35396
• LEFT SEMI / ANTI JOIN terminates subsequent matching execution upon matching a qualifying data row to enhance performance.
  • [opt](join) For left semi/anti join without mark join conjunct and without other conjucnts, stop probing after matching one row #34703
• Prevents coredump when returning illegal data to MySQL results
  • [opt](mysql serde) Avoid core dump when converting invalid block to mysql result #28069
• Unifies the output of type names in lowercase to maintain compatibility with MySQL and be more friendly to BI tools
  • [fix](compatibility) type toSql should return lowercase string (#38012) #38521

Big Thanks

Thanks all who contribute to this release:

@924060929
@BiteTheDDDDt
@ByteYue
@CalvinKirs
@GoGoWen
@HappenLee
@Jibing-Li
@Lchangliang
@LiBinfeng-01
@Mryange
@XieJiann
@Yukang-Lian
@Yulei-Yang
@airborne12
@amorynan
@biohazard4321
@cambyzju
@csun5285
@eldenmoon
@englefly
@freemandealer
@hello-stephen
@hubgeter
@kaijchen
@liaoxin01
@luwei16
@morningman
@morrySnow
@mymeiyi
@qidaye
@sollhui
@starocean999
@w41ter
@wuwenchi
@xiaokang
@xy720
@yujun777
@zclllyybb
@zddr
@zhangstar333
@zhiqiang-hhhh
@zy-kkk
@zzzxl1993

[xiaokang]

中文版本：

1 行为变更

无

2 新功能

• 增加获取最近一个查询 Profile 的 REST 接口 curl http://user:password@127.0.0.1:8030/api/profile/text
  • [feat](FE) add rest api to get last profile #38268

3 改进和优化

• 优化 MOW 表带有 sequence 列的主键点查性能
  • [opt](mow) opt mow lookup with sequence column #38287
• 优化倒排索引在查询条件很多时的性能
  • [opt](inverted index) performance optimization for need_read_data in compound #35346
• 创建带分词的倒排索引时,自动开启 support_phrase 选项加速 match_phrase 系列短语查询
  • [opt](inverted index) set support_phrase default true if parser is set #37949
• 支持简化的 SQL hint, 例如 SELECT /*+ query_timeout(3000) */ * FROM t;
  • [opt](Nereids) support no-key hint parameter #37720
• 读对象存储遇到 429 错误时自动重试提升稳定性
  • [opt](s3) auto retry when meeting 429 error #35396
• LEFT SEMI / ANTI JOIN 在匹配到符合的数据行时，终止后续的匹配执行提升性能
  • [opt](join) For left semi/anti join without mark join conjunct and without other conjucnts, stop probing after matching one row #34703
• 避免非法数据返回 MySQL 结果时出发 coredump
  • [opt](mysql serde) Avoid core dump when converting invalid block to mysql result #28069
• 输出类型名字时统一使用小写, 保持跟 MySQL 兼容对 BI 工具更加友好
  • [fix](compatibility) type toSql should return lowercase string (#38012) #38521