What is the problem the feature request solves?
When casting from intergral types to decimal, we currently delegate to DataFusion if COMET_CAST_ALLOW_INCOMPATIBLE config is enabled. The DataFusion implementation is not compatible with Spark.
We should implement a Spark-compatible cast implementation within Comet instead. Once this is implemented, we should also update the native is_datafusion_spark_compatible function to no longer return true for casts from integer to decimal.
There is an existing test in CometCastSuite which is currently ignored and should be enabled (and updated as required).
Describe the potential solution
No response
Additional context
No response