Jefffrey commented on issue #14633:
URL: https://github.com/apache/datafusion/issues/14633#issuecomment-3364438632
Filter clause for aggregations is now supported in generic dialect, see
#17807 (and its references #16516 and #15719)
e.g. on main:
```sh
datafusion-cli$ cargo run
Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.22s
Running `/Users/jeffrey/.cargo_target_cache/debug/datafusion-cli`
DataFusion CLI v50.0.0
> create table test_table(c2 int);
0 row(s) fetched.
Elapsed 0.041 seconds.
> SELECT SUM(c2) FILTER (WHERE true) FROM test_table;
+-------------------------------------------------+
| sum(test_table.c2) FILTER (WHERE Boolean(true)) |
+-------------------------------------------------+
| NULL |
+-------------------------------------------------+
1 row(s) fetched.
Elapsed 0.042 seconds.
```
--
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]
