[Doris Weekly] 2020.08.17 - 2020.08.23

[陈明雨 <mo...@163.com>]

This is the Doris Weekly Report of 2020.08.17 - 2020.08.23




# Statistic




A total of 14 authors submitted 29 Commits this week. Thanks to the contributions of the following authors:




Mingyu Chen, ZhangYu0123, EmmyMiao87, HappenLee, lichaoyong, Zhengguo Yang, zhbinbin,
xinghuayu007, caoyang10, bigdataplumber, Yingchun Lai, WangCong, Stalary, Janko



This week, the 7462 lines were added and the 1427 lines were deleted, involving a total of 3963 files.




# Main progress

## New Feature（Merged）

https://github.com/apache/incubator-doris/pull/4255

Support repairing damaged tablets by filling in empty tablets




https://github.com/apache/incubator-doris/pull/4347

Added replace() function




## New Feature（WIP）

https://github.com/apache/incubator-doris/pull/4310

Support Batch Delete function




## Bug Fixed

https://github.com/apache/incubator-doris/pull/4350

Fix the problem that the BE process crashed due to the orc::TimezoneError not being caught when loading ORC format files




https://github.com/apache/incubator-doris/pull/4369

Fix the issue that the result of the Except operator is incorrect




https://github.com/apache/incubator-doris/pull/4352

Fix the problem that when querying ES data, the query is always routed to the same BE node




https://github.com/apache/incubator-doris/pull/4324

Fix the problem that the operation is not correctly persisted when setting the global variable




https://github.com/apache/incubator-doris/pull/4345

Fixed the issue that the MemTracker was not constructed correctly in PushHandler which caused the BE process to crash




https://github.com/apache/incubator-doris/pull/4379

Fix the problem of loading blank lines when loading Json data format




https://github.com/apache/incubator-doris/pull/4382

Fix the problem that the SQL rewriting rules failed to correctly handle count distinct




https://github.com/apache/incubator-doris/pull/4375

Fix the problem that the data model type of the materialized view is not set correctly when creating the materialized view




https://github.com/apache/incubator-doris/pull/4417

Fix the problem of wrong query result of left semi/anti join




## Enhancement

https://github.com/apache/incubator-doris/pull/4365  

SQL supports collate utf8_general_ci syntax to improve MySQL syntax compatibility




https://github.com/apache/incubator-doris/pull/4212

A new compaction selection algorithm is implemented, providing lower write amplification and a more reasonable compaction strategy




https://github.com/apache/incubator-doris/pull/4366

Optimize bit operation efficiency in variable length coding




## Others

https://github.com/apache/incubator-doris/pull/4198

Added third-party UDF to support more efficient set calculation of orthogonal bitmap data




https://github.com/apache/incubator-doris/pull/4377

Added UnixODBC third-party library dependency to support ODBC external table function




# Main features in development

https://github.com/apache/incubator-doris/issues/2581

Support SQL result cache




https://github.com/apache/incubator-doris/issues/4376

Support to access external tables through ODBC protocol




https://github.com/apache/incubator-doris/issues/4308

Support the separation of the front-end UI and back-end service of the FE module, providing a more powerful UI interface




https://github.com/apache/incubator-doris/issues/3926

Support data spill in query process




https://github.com/apache/incubator-doris/issues/4051

Support the Batch Delete function on the Unique Key model




https://github.com/apache/incubator-doris/issues/3930

Supports sorting according to the specified Sequence column when loading data to the Unique Key model




--

此致！Best Regards
陈明雨 Mingyu Chen

Email:
chenmingyu@apache.org