You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Marco Gaido (JIRA)" <ji...@apache.org> on 2017/12/18 12:51:00 UTC
[jira] [Created] (HIVE-18291) An exception should be raised if the
result is outside the range of decimal
Marco Gaido created HIVE-18291:
----------------------------------
Summary: An exception should be raised if the result is outside the range of decimal
Key: HIVE-18291
URL: https://issues.apache.org/jira/browse/HIVE-18291
Project: Hive
Issue Type: Sub-task
Affects Versions: 2.3.0
Reporter: Marco Gaido
Citing SQL:2011 on page 27 available at http://standards.iso.org/ittf/PubliclyAvailableStandards/c053681_ISO_IEC_9075-1_2011.zip:
{noformat}
If the result cannot be represented exactly in the result type, then whether it is rounded
or truncated is implementation-defined. An exception condition is raised if the result is
outside the range of numeric values of the result type, or if the arithmetic operation
is not defined for the operands.
{noformat}
Currently Hive is returning NULL instead of throwing an exception if the result is out of range, eg.:
{code}
> select 1000000000000000000.000001*1000000000000000000.000001;
+-------+
| _c0 |
+-------+
| NULL |
+-------+
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)