joseph-isaacs opened a new issue, #25036:
URL: https://github.com/apache/datafusion/issues/25036
We should use the new placement API for more scalar fns. This allows better
query plans for example in vortex we get a large speed up for clickbench query
q29 (below) when pushing down `OCTET_LENGTH("URL")` since we never need load
the URL str bytes
```sql
SELECT "CounterID", AVG(OCTET_LENGTH("URL")) AS l, COUNT(*) AS c FROM hits
WHERE "URL" <> '' GROUP BY "CounterID" HAVING COUNT(*) > 100000 ORDER BY l DESC
LIMIT 25; -- ClickHouse's length counts bytes, not code points as standard SQL.
```
Scalar fn:
- [ ] bit/octet/''-length
- [ ] todo
--
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]
