You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "phZhou (Jira)" <ji...@apache.org> on 2022/07/15 08:22:00 UTC
[jira] [Created] (HIVE-26396) The trunc function has a problem with precision interception and the result has many 0
phZhou created HIVE-26396:
-----------------------------
Summary: 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
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)