[HIVE-27553] After upgrading from Hive1 to Hive3, Decimal computation experiences a loss of precision

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.3, 4.0.0
• Component/s: HiveServer2
• Labels: pull-request-available
• Assignee: ZhengBowen
• Reporter: ZhengBowen
• Due: 31/Jul/23
• Created: 31/Jul/23 12:40
• Updated: 13/Feb/24 00:19

Description

I can reproduce this bug.

create table decimal_test(
    id int,
    quantity decimal(38,8),
    cost decimal(38,8)
) stored as textfile;
 
insert into decimal_test values(1,0.00008000, 0.00015000);
 
select quantity * cost from decimal_test;

1、The following are the execution results and execution plan on Hive-1.0.1：

2、The following are the execution results and execution plan on Hive-3.1.3：

 

Issue Links

• relates to: HIVE-15331 Decimal multiplication with high precision/scale often returns NULL
• links to: GitHub Pull Request #4739