You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "jayzhan211 (via GitHub)" <gi...@apache.org> on 2025/02/21 14:54:56 UTC

Re: [PR] Implemented `simplify` for the `starts_with` function to convert it into a LIKE expression. [datafusion]

jayzhan211 commented on PR #14119:
URL: https://github.com/apache/datafusion/pull/14119#issuecomment-2674769799

   I wonder if converting `starts_with` to `like` add overhead.
   
   https://github.com/apache/arrow-rs/blob/a0c3186c55ac8ed3f6b8a15d1305548fd6305ebb/arrow-string/src/predicate.rs#L45-L60
   
   The difference between `starts_with` and `like` is that `like` check string to find a suitable kernel for processing whereas `starts_with` directly checks for a prefix match.
   
   While benchmarking is necessary to confirm the exact performance difference, converting `starts_with` to `like` is likely slower, though the impact may be negligible


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org