[HIVE-26396] The trunc function has a problem with precision interception and the result has many 0

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 3.1.3
• Fix Version/s: 3.2.0, 4.0.0-alpha-2
• Component/s: Hive
• Labels: pull-request-available

Environment

CDP7.1.7 ,RedHat7.6

• Hadoop Flags: Reviewed
• Flags: Patch

Language

English

• Assignee: Simhadri Govindappa
• Reporter: phZhou
• Due: 15/Jul/23
• Created: 15/Jul/22 08:21
• Updated: 16/Nov/22 13:50
• Resolved: 22/Jul/22 07:50

Description

The trunc function has a problem with precision interception and the result has many 0，There is a problem with the return when the data is of decimal type, and it is displayed normally when the data is of double type。The test is as follows:

1：Execute on beeline：

 SELECT  trunc(15.8963,3);

------------------------

_c0

------------------------

15.896000000000000000

------------------------
1 row selected (0.074 seconds)

need return “15.896”is correct。

Issue Links

• links to: GitHub Pull Request #3463