spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Apache Spark (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (SPARK-28235) Decimal sum return type
Date Tue, 02 Jul 2019 19:56:00 GMT

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

Apache Spark reassigned SPARK-28235:
------------------------------------

    Assignee: Apache Spark

> Decimal sum return type
> -----------------------
>
>                 Key: SPARK-28235
>                 URL: https://issues.apache.org/jira/browse/SPARK-28235
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Marco Gaido
>            Assignee: Apache Spark
>            Priority: Major
>
> Our implementation of decimal operations follows SQLServer behavior. As per https://docs.microsoft.com/it-it/sql/t-sql/functions/sum-transact-sql?view=sql-server-2017,
the result of sum operation should be `DECIMAL(38, s)` while currently we are setting it to
`DECIMAL(10 + p, s)`. This means that with large datasets, we may incur in overflow, even
though we may have been able to represent the value with higher precision and SQLServer returns
correct results in that case.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message