You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Simhadri G (Jira)" <ji...@apache.org> on 2022/07/18 06:39:00 UTC
[jira] [Assigned] (HIVE-26396) The trunc function has a problem with precision interception and the result has many 0
[ https://issues.apache.org/jira/browse/HIVE-26396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Simhadri G reassigned HIVE-26396:
---------------------------------
Assignee: Simhadri G
> 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
> Fix For: 3.2.0, 4.0.0, 4.0.0-alpha-2
>
>
> 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)