[jira] [Commented] (HIVE-17844) Hive JDBC driver converts floats to doubles, changing values slightly

["Vihang Karajgaonkar (JIRA)" <ji...@apache.org>]

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

Vihang Karajgaonkar commented on HIVE-17844:
--------------------------------------------

[~zi] Can you give a example query which can lead to incorrect results? Thanks for reporting this..

> 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
>            Priority: Major
>
> 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
(v7.6.3#76005)