chenboat commented on PR #16364: URL: https://github.com/apache/pinot/pull/16364#issuecomment-3120494731
> > We will support SQL's LIKE() function as mentioned in the issue. So there is no need to introduce a new UDF. It can be extended to support regex_like() in Pinot today too -- it just involves more regex parsing. > > Pinot's LIKE is case insensitive so this is not possible. You can refer to #10609. Thanks for the link to this discussion. To support case insensitive matching, we can during index time lower case all the ngrams (it may save a bit of ngrams here) and then during query time lower case all query strings too. Then we can support the current Pinot LIKE() case insensitive behavior. This is the preferred solution. There is also a query time expansion approach (i.e, *ab* becomes *(AB|ab|Ab|aB)* but it is too many combinations for long strings. Also -- 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]
