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