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)
