andygrove opened a new issue, #4834: URL: https://github.com/apache/datafusion-comet/issues/4834
Comet accelerates window functions with `RANGE` frames, but falls back to Spark when the frame uses an explicit `PRECEDING`/`FOLLOWING` offset and the `ORDER BY` column is `DATE` or `DECIMAL`. See the fallbacks in `spark/src/main/scala/org/apache/spark/sql/comet/CometWindowExec.scala` (the RANGE-frame checks around lines 377-391): - DATE ORDER BY: falls back with "RANGE frame with explicit offset on DATE ORDER BY is not supported" because Date32 + Int32 frame arithmetic is not handled in the native comparator. - DECIMAL ORDER BY: falls back with "RANGE frame with explicit offset on DECIMAL ORDER BY is not supported" because decimal precision widening breaks the frame comparator. Pure `UNBOUNDED`/`CURRENT ROW` RANGE frames on these order-by types already run natively; only explicit numeric offsets fall back. Documented as a current limitation in the window function compatibility guide. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
