AnthonyZhOon commented on PR #26046:
URL: https://github.com/apache/datafusion/pull/26046#issuecomment-6007462496
@alamb
Didn't run an end-to-end that shows this before but here's a query I
generated on the clickbench `hits` table with a 1.17x speedup. Cases or joining
against patterns should hit caching
```sql
SELECT SUM(regexp_count(
"URL",
CASE WHEN "SearchEngineID" = 0
THEN '[?&](from|utm_[^=&#]+)='
ELSE '[?&](q|query|text|search)='
END
)) AS parameter_matches
FROM hits;
```
--
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]
