gortiz opened a new issue, #9079: URL: https://github.com/apache/pinot/issues/9079
Most SQL databases support `REGEXP_REPLACE` function ([Oracle](https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions130.htm), [Postgres](https://www.postgresql.org/docs/current/functions-matching.html), [Vertica](https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/RegularExpressions/REGEXP_REPLACE.htm), [MySQL](https://dev.mysql.com/doc/refman/8.0/en/regexp.html#function_regexp-replace)). Pinot instead supports `REPLACE`, which just looks for exact string matches and replace them with another simple string. It shouldn't be very difficult to support this operation in Pinot. Current implementation of `ltrim` and `rtrim` already uses Java regex. The main difference is that, for performance reasons, the pattern should be stored somewhere in the AST to be compiled only once. -- 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: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
