alamb commented on issue #17721: URL: https://github.com/apache/datafusion/issues/17721#issuecomment-3499326391
> This would suggest mostly regressions, including in Q23 which is very surprising to me Yes indeed this is also surprising to me Q23 is ```sql SELECT * FROM hits WHERE "URL" LIKE '%google%' ORDER BY "EventTime" LIMIT 10; ``` Namely the query that benefits the most from the new dynamic filter pushdown In my unscientific experiments locally (Mac M3) I see q23 going significantly faster on 50.3.0 than 47.0.0: ```shell time ~/Software/datafusion-cli/datafusion-cli-47.0.0 -c "SELECT * FROM hits WHERE \"URL\" LIKE '%google%' ORDER BY \"EventTime\" LIMIT 10;" ``` 0m5.377s 0m4.507s 0m5.144s ```shell time ~/Software/datafusion-cli/datafusion-cli-50.3.0 -c "SELECT * FROM hits WHERE \"URL\" LIKE '%google%' ORDER BY \"EventTime\" LIMIT 10;" ``` 0m5.016s 0m3.652s 0m3.927s -- 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]
