andygrove opened a new issue, #1429: URL: https://github.com/apache/datafusion-comet/issues/1429
### Describe the bug I see a HashAggregate falling back to Spark but the root cause is hidden: ``` HashAggregate [COMET: Unsupported result expressions found in: List((0.2 * cast((avg(UnscaledValue(l_quantity#130))#124 / 100.0) as decimal(15,6))) AS (0.2 * avg(l_quantity))#125, l_partkey#127L)] ``` After adding some debug logging I discover the root cause: ``` Comet does not guarantee correct results for cast from DoubleType to DecimalType(15,6) with timezone Some(America/Denver) and evalMode LEGACY (There can be rounding differences). To enable all incompatible casts, set spark.comet.cast.allowIncompatible=true ``` I should not need to add debug logging to discover this. ### Steps to reproduce _No response_ ### Expected behavior _No response_ ### Additional context _No response_ -- 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-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
