[GitHub] [arrow-datafusion] alamb opened a new issue #201: Improve the errors that result when a aggregate type is not supported

[GitBox <gi...@apache.org>]

alamb opened a new issue #201:
URL: https://github.com/apache/arrow-datafusion/issues/201


   *Note*: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-12319
   
   When you try and run a query such as
   
   {code}
   select AVG(ts_colum) from t;
   {code}
   
   where ts_column has `DataType::Timestamp` type, you get a pretty unintelligible error message
   
   "Coercion from [Timestamp(Nanosecond, None)] to the signature Uniform(1, [Int8, Int16, Int32, Int64, UInt8, UInt16, UInt32, UInt64, Float32, Float64]) failed."
   
   This error should be improved to say something more like "AVG is not supported for {datatype} try an explicit cast."
   


-- 
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] alamb commented on issue #201: Improve the errors that result when a aggregate type is not supported

[GitBox <gi...@apache.org>]

alamb commented on issue #201:
URL: https://github.com/apache/arrow-datafusion/issues/201#issuecomment-826839543


   Comment from Andrew Lamb(alamb) @ 2021-04-09T21:12:18.292+0000:
   <pre>I spent some non trivial time in IOx trying to figure out what this message meant when trying to do MIN(timestamp) column</pre>


-- 
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org