[HIVE-5022] Decimal Arithmetic generates NULL value

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.13.0
• Component/s: Types

Environment

Hortonworks 1.3 running Hive 0.11.0.1.3.0.0-107

• Assignee: Xuefu Zhang
• Reporter: Kevin Soo Hoo
• Created: 07/Aug/13 22:24
• Updated: 04/Dec/13 03:11
• Resolved: 04/Dec/13 03:11

Description

When a decimal division is the first operation, the quotient cannot be multiplied in a subsequent calculation. Instead, a NULL is returned.

The following yield NULL results:
select (cast (4.53 as decimal) / cast(25.86 as decimal)) * cast(0.087 as decimal) from <tablename> limit 1;

select cast (4.53 as decimal) / cast(25.86 as decimal) * cast(0.087 as decimal) from <tablename> limit 1;

If we move the multiplication operation to be first, then it will successfully calculate the result.

Issue Links

• is related to: HIVE-3976 Support specifying scale and precision with Hive decimal type