What is the problem the feature request solves?
CometStringExpressionBenchmark shows poor performance for contains:
OpenJDK 64-Bit Server VM 11.0.22+7-LTS on Mac OS X 14.6.1
Apple M3 Max
contains: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Spark 10 69 27 0.1 9603.6 1.0X
Comet (Scan) 11 81 26 0.1 10928.1 0.9X
Comet (Scan + Exec) 44 91 20 0.0 42889.5 0.2X
Describe the potential solution
Review benchmark to make sure it is valid, then try and optimize performance.
Additional context
No response
What is the problem the feature request solves?
CometStringExpressionBenchmarkshows poor performance forcontains:Describe the potential solution
Review benchmark to make sure it is valid, then try and optimize performance.
Additional context
No response