alamb opened a new issue, #3166:
URL: https://github.com/apache/arrow-datafusion/issues/3166
**Is your feature request related to a problem or challenge? Please describe
what you are trying to do.**
DataFusion does not support `SUM` or `AVG` on `Time` type columns a standard
SQL feature that could be used to sum how much cumulative time was spent doing
some operation, for example
Reproducer is as follows:
```sql
select
sum(t),
avg(t)
from
(select cast ('11:00:00' as TIME) as t) as sq;
```
Doing so today will result in
```sql
❯ select
sum(t),
avg(t)
from
(select cast ('11:00:00' as TIME) as t) as sq;
Plan("The function Sum does not support inputs of type Time64(Nanosecond).")
❯
```
**Describe the solution you'd like**
A clear and concise description of what you want to happen.
**Describe alternatives you've considered**
N/A
**Additional context**
As described in https://github.com/apache/arrow-datafusion/issues/200
--
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]
