Filter null rows before aggregation

[jackychen718]

Description

Filter rows with all fileds null before aggregation.

Motivation and Context

The issue comes from #17486 Add optimiztion to drop groups/rows with all fields null

Impact

Add another opitimization rule: RemoveNullRowInAggregation.java

Test Plan

Test if any error made after applying the new optimization rule.

Contributor checklist

• [ ] Please make sure your submission complies with our development, formatting, commit message, and attribution guidelines.
• [ ] PR description addresses the issue accurately and concisely. If the change is non-trivial, a GitHub Issue is referenced.
• [ ] Documented new properties (with its default value), SQL syntax, functions, or other functionality.
• [ ] If release notes are required, they follow the release notes guidelines.
• [ ] Adequate tests were added if applicable.
• [ ] CI passed.

Release Notes

Please follow release notes guidelines and fill in the release notes below.

== RELEASE NOTES ==

General Changes
* ... :pr:`12345`
* ... :pr:`12345`

Hive Connector Changes
* ... :pr:`12345`
* ... :pr:`12345`

== NO RELEASE NOTE ==

[jaystarshot]

Can you add unit tests? Also there must be a feature flag controlling this since I am not sure if this optimization will be always effective. What happens in count(*) case?

[jackychen718]

Can you add unit tests? Also there must be a feature flag controlling this since I am not sure if this optimization will be always effective. What happens in count(*) case?

I will add unit tests. Currently, I did not consider count(*) as a special way. From your reminding, I do not think I can still add filter before aggregation in this scenario. I will exclude this scenario in the pattern match process. Is it ok? @jaystarshot

[tdcmeehan]

@jackychen718 are you still working on this PR?

[jackychen718]

@tdcmeehan I keep in mind this task is not done yet. After I merge other PRs, I will come back to this one.