alamb commented on PR #11627:
URL: https://github.com/apache/datafusion/pull/11627#issuecomment-2254499708
I spent some time this morning playing around with ClickBench query 32
locally and I agree any slowdown does not look significant or a blocker.
Q32
```sql
SELECT "WatchID", "ClientIP", COUNT(*) AS c, SUM("IsRefresh"),
AVG("ResolutionWidth") FROM hits GROUP BY "WatchID", "ClientIP" ORDER BY c DESC
LIMIT 10;
```
Running from datafusion-cli:
```shell
./datafusion-cli-skip-partial -c "SELECT \"WatchID\", \"ClientIP\", COUNT(*)
AS c, SUM(\"IsRefresh\"), AVG(\"ResolutionWidth\") FROM 'hits.parquet' GROUP BY
\"WatchID\", \"ClientIP\" ORDER BY c DESC LIMIT 10;"
```
```shell
datafusion-cli -c "SELECT \"WatchID\", \"ClientIP\", COUNT(*) AS c,
SUM(\"IsRefresh\"), AVG(\"ResolutionWidth\") FROM 'hits.parquet' GROUP BY
\"WatchID\", \"ClientIP\" ORDER BY c DESC LIMIT 10;"
```
Here are the timings I got:
| skip-partial |
|--------|
| 4.570 |
| 4.280 |
| 4.528 |
| main |
|--------|
| 4.564 |
| 4.444 |
| 4.441 |
--
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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
