Import DecimalAggregates and apply the rule directly on your structured queries to learn how the rule works. import org.apache.spark.sql.catalyst.optimizer.DecimalAggregates val da = DecimalAggregates ...
This exception is happening because the SQL decimal type will map to the C# decimal type, and the default Parse behavior for decimal doesn't allow scientific notation. I'm reluctant to change that ...