You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/05/02 18:51:48 UTC
[GitHub] [arrow-datafusion] andygrove opened a new issue, #2420: Type-coercion error with decimal type
andygrove opened a new issue, #2420:
URL: https://github.com/apache/arrow-datafusion/issues/2420
**Describe the bug**
I am trying to run query `SELECT round(c1/3, 2) FROM aggregate_simple order by c1` where `c1` is a decimal. The query fails with `Coercion from [Decimal(29, 23), Int64] to the signature Uniform(1, [Float64, Float32]) failed.`.
**To Reproduce**
Run the query shown above.
**Expected behavior**
Query should work.
**Additional context**
None
--
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@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb closed issue #2420: Type-coercion errors calling `round` function with two arguments
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #2420: Type-coercion errors calling `round` function with two arguments
URL: https://github.com/apache/arrow-datafusion/issues/2420
--
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@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] andygrove commented on issue #2420: Type-coercion errors calling `round` function with two arguments
Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #2420:
URL: https://github.com/apache/arrow-datafusion/issues/2420#issuecomment-1122631644
@WinkerDu I created https://github.com/apache/arrow-datafusion/pull/2503 to address this at the logical plan level but perhaps you could fix this in the physical planner to close this issue?
--
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@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] WinkerDu commented on issue #2420: Type-coercion error with decimal type
Posted by GitBox <gi...@apache.org>.
WinkerDu commented on issue #2420:
URL: https://github.com/apache/arrow-datafusion/issues/2420#issuecomment-1115895149
It seems `round` in df is an unary function with signature: `signature Uniform(1, [Float64, Float32])`
The possible approach to solve this issue is:
- Extends the `round` signature to `one_of`
- Introduce the new `round` expression implementation in `math_expressions.rs`
I can take this ticket as appropriate. @andygrove Can you assign this issue to me? Thank you.
--
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@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] viirya commented on issue #2420: Type-coercion errors calling `round` function with two arguments
Posted by "viirya (via GitHub)" <gi...@apache.org>.
viirya commented on issue #2420:
URL: https://github.com/apache/arrow-datafusion/issues/2420#issuecomment-1491049534
Unassigned this as it is more than 6 months ago.
--
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@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] andygrove commented on issue #2420: Type-coercion error with decimal type
Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #2420:
URL: https://github.com/apache/arrow-datafusion/issues/2420#issuecomment-1122586564
Sorry @WinkerDu I just saw your request here, I am hitting this error in multiple places and I created this ticket using `round` as one example. I assigned this to you but I am also going to take a look because I am not very familiar with this type-coercion signature code and I will probably have some questions for you.
--
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@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org