hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Kolbasov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17844) Hive JDBC driver converts floats to doubles, changing values slightly
Date Fri, 20 Oct 2017 17:43:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16212942#comment-16212942
] 

Alexander Kolbasov commented on HIVE-17844:
-------------------------------------------

According to the discussion that Zoltan refers to, the double represents float precisely,
but the printed representation is different.

> Hive JDBC driver converts floats to doubles, changing values slightly
> ---------------------------------------------------------------------
>
>                 Key: HIVE-17844
>                 URL: https://issues.apache.org/jira/browse/HIVE-17844
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC
>            Reporter: Zoltan Ivanfi
>
> When querying data through Hive's JDBC driver, float values are automatically converted
to doubles and will slightly differ from values seen when directly querying the data using
a textual SQL interface.
> Please note that by slight difference I don't only mean additional zeroes at the end,
but an actual numeric difference in the displayed value. This is the result of the different
precision used when displaying double values, as discussed [here|https://stackoverflow.com/questions/17504833/why-converting-from-float-to-double-changes-the-value],
for example.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message