[HIVE-18291] An exception should be raised if the result is outside the range of decimal

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Marco Gaido
• Created: 18/Dec/17 12:50
• Updated: 05/Apr/19 12:27

Description

Citing SQL:2011 on page 27 available at http://standards.iso.org/ittf/PubliclyAvailableStandards/c053681_ISO_IEC_9075-1_2011.zip:

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.

Currently Hive is returning NULL instead of throwing an exception if the result is out of range, eg.:

> select 1000000000000000000.000001*1000000000000000000.000001;
+-------+
|  _c0  |
+-------+
| NULL  |
+-------+

Issue Links

• is related to: SPARK-23179 Support option to throw exception if overflow occurs during Decimal arithmetic