[
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)
