You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "alamb (via GitHub)" <gi...@apache.org> on 2024/08/08 15:26:31 UTC
[I] Can not compare [datafusion]
alamb opened a new issue, #11891:
URL: https://github.com/apache/datafusion/issues/11891
### Is your feature request related to a problem or challenge?
(broken out from https://github.com/apache/datafusion/pull/11876 for more visibility)
@samuelcolvin writes:
We regularly want to allow queries of the form
```sql
SELECT * FROM records WHERE end_timestamp - start_timestamp > interval '2 seconds'
```
Until now that failed with
```
type_coercion: Cannot infer common argument type for comparison operation Duration(Microsecond) > Interval(MonthDayNano)
```
### Describe the solution you'd like
The query should work
### Describe alternatives you've considered
_No response_
### Additional context
(broken out from https://github.com/apache/datafusion/pull/11876 for more visibility)
--
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-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Can not compare durations and intervals [datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #11891: Can not compare durations and intervals
URL: https://github.com/apache/datafusion/issues/11891
--
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-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org