Add ANSI support in SUM and AVG

[andygrove]

What is the problem the feature request solves?

Spark has specific handling of overflows when ANSI mode is enabled and we need to add the same in Comet.

Describe the potential solution

No response

Additional context

No response

[dharanad]

hello @andygrove i want to work on this issue, can you please assign it to me

[viirya]

Thanks @dharanad.

[SatyaKuppam]

@dharanad Checking if you are still working on this, if not I can take a stab at it. Thanks.

[dharanad]

@SatyaKuppam go ahead.

[coderfender]

Picking this up

[coderfender]

Working on SUM (which setup a base framework in terms of setting ANSI support given that we leverage DF's UDAF functionality

[coderfender]

Given that SUM function 's ANSI implementation is spark specific, I will be moving ahead in implementing a comet native function (with integral support) and probably raise a draft PR by early next week