databendlabs / databend

๐——๐—ฎ๐˜๐—ฎ, ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ & ๐—”๐—œ. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com
https://docs.databend.com
Other
7.71k stars 732 forks source link

chore(query): refactor like function #16493

Closed sundy-li closed 2 days ago

sundy-li commented 3 days ago

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/

Summary

  1. refactor like function in filter and functions
  2. make spilt agg run at the last of rule optimizations
  3. use multiversion to dispatch sum agg
  4. introduce volnitsky search algorithm

perf:

select count() from numbers(100000000) where number::string like '%12345%';

improves ~10%

Tests

Type of change


This change isโ€‚Reviewable