You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Gopinath (Jira)" <ji...@apache.org> on 2022/11/13 09:50:00 UTC
[jira] [Updated] (HIVE-26731) UDF trunc produces incorrect result for higher values
[ https://issues.apache.org/jira/browse/HIVE-26731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gopinath updated HIVE-26731:
----------------------------
Description:
The trunc function produces an incorrect result for higher values。
The test is as follows:
{quote}
0: jdbc:hive2://localost> select trunc(123456711889.122345897, 8);
+----------------------------------+
| _c0 |
+----------------------------------+
| -61010728847.97317027 |
+----------------------------------+{{{}{}}}{{{}{}}}
{quote}
Expected Value - 123456711889.12234589
was:
The trunc function produces an incorrect result for higher values。
The test is as follows:
{{{quote}}}
0: jdbc:hive2://localost> select trunc(123456711889.122345897, 8);
+----------------------------------+
| _c0 |
+----------------------------------+
| -61010728847.97317027 |
+----------------------------------+{{{}{}}}{{{}{}}}
{{{}{}}}{{{}{quote}{}}}
Expected Value - 123456711889.12234589
> UDF trunc produces incorrect result for higher values
> -----------------------------------------------------
>
> Key: HIVE-26731
> URL: https://issues.apache.org/jira/browse/HIVE-26731
> Project: Hive
> Issue Type: Bug
> Reporter: Gopinath
> Assignee: Gopinath
> Priority: Major
>
> The trunc function produces an incorrect result for higher values。
> The test is as follows:
>
>
> {quote}
> 0: jdbc:hive2://localost> select trunc(123456711889.122345897, 8);
> +----------------------------------+
> | _c0 |
> +----------------------------------+
> | -61010728847.97317027 |
> +----------------------------------+{{{}{}}}{{{}{}}}
> {quote}
>
> Expected Value - 123456711889.12234589
--
This message was sent by Atlassian Jira
(v8.20.10#820010)