itschrispeck opened a new issue, #11618: URL: https://github.com/apache/pinot/issues/11618
Take the query, `REGEXP_LIKE(direct_tags, '^.*"key":[^\]]*"value".*$'))` which searches for some array element = "value" in array "key". This query, and the minimized syntax `REGEXP_LIKE(direct_tags, '"key":[^\]]*"value"'))` are both performant. But when the anchors are dropped like so, `REGEXP_LIKE(direct_tags, '.*"key":[^\]]*"value".*'))`, the query times out on very small numbers of documents. As a user it's difficult to tell why some regexp patterns are so slow. Since prefixing/suffixing a search string with `.*` is a common user behavior it seems to make sense to optimize this. -- 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
