Release Note 2.0.13

[xiaokang]

Previous Release Note 2.0.12

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

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

1 Behavior Change

• SQL input is treated as multiple statements only when the CLIENT_MULTI_STATEMENTS setting is enabled on the client side, enhancing compatibility with MySQL.
  • [fix](protocol) only return multi result when CLIENT_MULTI_STATEMENTS been set #36759

2 New Features

• A new BE configuration allow_zero_date has been added, allowing dates with all zeros. When set to false, 0000-00-00 is parsed as NULL, and when set to true, it is parsed as 0000-01-01. The default value is false to maintain consistency with previous behavior.
  • [feature](datatype) add BE config to allow zero date #34961
• LogicalWindow and LogicalPartitionTopN support multi-field predicate pushdown to improve performance.
  • [feat](Nereids) push down predicates with multi columns through LogicalWindow and LogicalPartitionTopN #36828
• The ES Catalog now maps ES nested or object types to Doris JSON types.
  • [feature](ES Catalog) map nested/object type in ES to JSON type in Doris #37101

3 Improvement and Optimizations

• Queries with LIMIT end reading data earlier to reduce resource consumption and improve performance.

  • [improve](scan)scanner could eos early when reached limit #36535

• Special JSON data with empty keys is now supported.

  • [improve](json)improve json support empty keys #36762

• Stability and usability of routine load have been improved, including load balancing, automatic recovery, exception handling, and more user-friendly error messages.

  • [chore](routine-load) optimize out of range error message #36450
  • [improve](routine-load) add retry when get Kafka meta info #35376
  • [improve](routine-load) optimize routine load job auto resume policy #35266
  • [improve](routine-load) timely pause job if Kafka cluster exception when consume #33372
  • [opt](routine-load) optimize routine load task thread pool and related param #32282
  • [opt](routine-load) end Kafka consume when meets partition EOF #32046
  • [opt](routine-load) optimize allocate task to be algorithm for load balance #32021
  • [improve](routine-load) increase routing load max_batch _size max limit #31846
  • [improve](routine-load) optimize routine load task schedule to make consume real-time and balanced #31273

• BE load balancing selection of hard disk strategy and speed optimization.

  • [improvement](balance) partition rebalance chose disk by rr #36826
  • [improvement](clone) dead be will abort sched task #36795
  • [improvement](partition rebalance) improve partition rebalance choose candidate speed #36509

• Stability and usability of the JDBC catalog have been improved, including encryption, thread pool connection count configuration, and more user-friendly error messages.

  • [branch-2.0][improvement](sqlserver catalog) Can configure whether to use encryption when connecting to SQL Server using the catalog #36940
  • [improvement](jdbc catalog) Modify the maximum number of connections in the connection pool to 30 by default #36720
  • [improvement](jdbc catalog) Delete unnecessary schema and optimize insert logic #30880
  • [improvement](jdbc catalog) Change JdbcExecutor's error reporting from UDF to JDBC #35692

Big Thanks

Thanks all who contribute to this release:

@DarvenDuan
@Gabriel39
@Jibing-Li
@Johnnyssc
@Lchangliang
@LiBinfeng-01
@swjtu-zhanglei
@Thearas
@Yukang-Lian
@Yulei-Yang
@airborne12
@amorynan
@bobhan1
@cambyzju
@csun5285
@dataroaring
@deardeng
@eldenmoon
@englefly
@feiniaofeiafei
@hello-stephen
@jacktengg
@kaijchen
@liutang123
@luwei16
@morningman
@morrySnow
@mrhhsg
@mymeiyi
@platoneko
@qidaye
@sollhui
@starocean999
@w41ter
@xiaokang
@xy720
@yujun777
@zclllyybb
@zddr
@zhangstar333
@zhannngchen
@zy-kkk
@zzzxl1993