Liu Zhenlong
Liu Zhenlong
### Task Description close #1939 ### Solution Description Hashing with SIMD instructions: process multiple fix-length(such as 1, 2, 4, 8 bytes and etc.) data elements simultaneously in a single instruction...
**Enhancement** In vectorized operators, such as Hash Group By, there are many scenarios where fixed-length data batches are being hashed in bulk. In such cases, we can use SIMD to...
## Proposed changes Issue Number: close #31348 Add a new command to support delete db/table/partition in catalog recycle bin instantly. For example: 1. Delete the database by id: ```sql DROP...
**Enhancement** Refer to doris, starrocks, clickhouse and etc., optimize our like func impl. The Q21, Q22, Q23, Q24 query in clickbench will benefit from the enhancement. ```sql # Q21: SELECT...
### Task Description close #2015 ### Solution Description According to doris(sr, ck) optimization idea, when collation is utf8mb4_bin, the specific pattern(without escape and `_`) is optimized: - Begin and end...
**Enhancement** In some scenarios, hyperscan performes better than the current regexp engine(ICU). In particular, the Q29 query in clickbench will benefit from the enhancement. ```sql SELECT REGEXP_REPLACE(Referer, '^https?://(?:www\.)?([^/]+)/.*$', '\1') AS...
### Task Description close #1992 ### Solution Description Because ICU and Hyperscan are not fully compatible, Hyperscan cannot replace ICU. Therefore, add a tenant parameter to choose the engine between...