[ 
https://issues.apache.org/jira/browse/FLINK-31059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

dalongliu updated FLINK-31059:
------------------------------
    Description: 
This task aims to verify 
[FLINK-29717|https://issues.apache.org/jira/browse/FLINK-29717] which improves 
the hive udaf performance.

As the document [PR|https://github.com/apache/flink/pull/21789] 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.

> Release Testing: Verify FLINK-29717 Supports hive udaf such as sum/count by 
> native implementation
> -------------------------------------------------------------------------------------------------
>
>                 Key: FLINK-31059
>                 URL: https://issues.apache.org/jira/browse/FLINK-31059
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Connectors / Hive
>    Affects Versions: 1.17.0
>            Reporter: dalongliu
>            Assignee: Yunhong Zheng
>            Priority: Blocker
>             Fix For: 1.17.0
>
>
> This task aims to verify 
> [FLINK-29717|https://issues.apache.org/jira/browse/FLINK-29717] which 
> improves the hive udaf performance.
> As the document [PR|https://github.com/apache/flink/pull/21789] 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to