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

1 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 #38268

2 Improvements

  • Optimizes the primary key point query performance for MOW tables with sequence columns #38287

  • Enhances the performance of inverted index queries with many conditions #35346

  • Automatically enables the support_phrase option when creating a tokenized inverted index to accelerate match_phrase phrase queries #37949

  • Supports simplified SQL hints, for example: SELECT /*+ query_timeout(3000) */ * FROM t; #37720

  • Automatically retries reading from object storage when encountering a 429 error to improve stability #35396

  • LEFT SEMI / ANTI JOIN terminates subsequent matching execution upon matching a qualifying data row to enhance performance. #34703

  • Prevents coredump when returning illegal data to MySQL results. #28069

  • Unifies the output of type names in lowercase to maintain compatibility with MySQL and be more friendly to BI tools. #38521

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

Credits

Thanks all who contribute to this release:

@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