pepijnve opened a new issue, #17838: URL: https://github.com/apache/datafusion/issues/17838
### Is your feature request related to a problem or challenge? The implementation of `regexp_like` is less optimised compared to the `~` and `~*` operators. In particular, the operators have optimised paths for `array ~ scalar` while `regexp_like` will expand scalars to arrays. The consequence is that the function will always use the `regexp_is_match` kernel while the operators can make use of `regexp_is_match_scalar`. This in turn results in `regex_like(column, 'pattern')` having different performance characteristics compared to `column ~ pattern` which can be a pitfall. ### Describe the solution you'd like Try to align the two implementations as well as possible so there is no practical difference between the two. ### Describe alternatives you've considered _No response_ ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
