[
https://issues.apache.org/jira/browse/SPARK-34037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kent Yao updated SPARK-34037:
-----------------------------
Description:
The type-coercion for numeric types of average and sum is not necessary at all,
as the resultType and sumType can prevent the overflow.
was:
TakeOrderedAndProject
[ca_state,cd_gender,cd_marital_status,{color:red}aggOrder{color},cd_dep_employed_count,cd_dep_college_count,cnt1,min(cd_dep_count),max(cd_dep_count),avg(cd_dep_count),cnt2,min(cd_dep_employed_count),max(cd_dep_employed_count),avg(cd_dep_employed_count),cnt3,min(cd_dep_college_count),max(cd_dep_college_count),avg(cd_dep_college_count)]
The TPCDS plan results for q35 q85 are messed up with this attribute
> aggOrder should not be output as a auxiliary internal attribute
> ---------------------------------------------------------------
>
> Key: SPARK-34037
> URL: https://issues.apache.org/jira/browse/SPARK-34037
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Kent Yao
> Priority: Blocker
>
> The type-coercion for numeric types of average and sum is not necessary at
> all, as the resultType and sumType can prevent the overflow.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
