[jira] [Updated] (SPARK-34037) aggOrder should not be output as a auxiliary internal attribute

2021-01-15 Thread Kent Yao (Jira) 


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

Kent Yao updated SPARK-34037:
-
Issue Type: Improvement  (was: Bug)

> 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: Improvement
>  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

[jira] [Updated] (SPARK-34037) aggOrder should not be output as a auxiliary internal attribute

2021-01-15 Thread Kent Yao (Jira) 


 [ 
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

[jira] [Updated] (SPARK-34037) aggOrder should not be output as a auxiliary internal attribute

2021-01-15 Thread Kent Yao (Jira) 


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

Kent Yao updated SPARK-34037:
-
Priority: Major  (was: Blocker)

> 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: Improvement
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Kent Yao
>Priority: Major
>
> 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