[
https://issues.apache.org/jira/browse/HIVE-26396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Simhadri G resolved HIVE-26396.
-------------------------------
Resolution: Fixed
> The trunc function has a problem with precision interception and the result
> has many 0
> --------------------------------------------------------------------------------------
>
> Key: HIVE-26396
> URL: https://issues.apache.org/jira/browse/HIVE-26396
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 3.1.3
> Environment: CDP7.1.7 ,RedHat7.6
> Reporter: phZhou
> Assignee: Simhadri G
> Priority: Blocker
> Labels: pull-request-available
> Fix For: 3.2.0, 4.0.0, 4.0.0-alpha-2
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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。
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
