[FLINK-31059] Release Testing: Verify FLINK-29717 Supports hive udaf such as sum/count by native implementation

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.17.0
• Component/s: Connectors / Hive
• Assignee: miamiaoxyz
• Reporter: dalongliu
• Created: 14/Feb/23 08:31
• Updated: 23/Feb/23 08:12
• Resolved: 21/Feb/23 09:13

Description

This task aims to verify FLINK-29717 which improves the hive udaf performance.

As the document PR description, please veriy:
1. Enabling the option `table.exec.hive.native-agg-function.enabled`, use the sum/count/avg/min/max functions separately in the query to verify if the hash-agg strategy is chosen via plan, and verify if the data results are the same as when the option `table.exec.hive.native-agg-function.enabled` is disabled.
2. Enabling the option `table.exec.hive.native-agg-function.enabled`, combine sum/count/avg/min/max functions in query, verify if the hash-agg strategy is chosen via plan, and verify if the data results are the same as when option `table.exec.hive.native-agg-function.enabled` is disabled.
3. Enabling the option `table.exec.hive.native-agg-function.enabled`, count or max array&struct and other complex types in query, verify whether the sort-agg strategy is chosen via plan, verify whether the data result is the same as when option `table.exec.hive.native-agg-function.enabled` is disabled.
4. Enabling the option `table.exec.hive.native-agg-function.enabled`, use the sum/count and first_value/last_value functions in the query simultaneously, verify that the sort-agg strategy is chosen via plan, verify that the data is the same as when option `table.exec.hive.native-agg-function.enabled` is disabled.
5. Enabling the option `table.exec.hive.native-agg-function.enabled`, use the sum/count/avg/min/max functions in the query and open sort-agg strategy forcibly, verify that the data results are the same as when option `table.exec.hive.native-agg-function.enabled` is disabled.