hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
Date Sat, 12 Sep 2015 00:15:45 GMT

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

Carl Steinbach commented on HIVE-11802:
---------------------------------------

I guess the fact that the patch doesn't include any test updates means that there's no test
coverage for this right now? If that's the case can you add some?

Also, does the HiveCLI behave correctly in this scenario, and is there any test coverage provided
for this there?

> Float-point numbers are displayed with different precision in Beeline/JDBC
> --------------------------------------------------------------------------
>
>                 Key: HIVE-11802
>                 URL: https://issues.apache.org/jira/browse/HIVE-11802
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>            Reporter: Sergio Peña
>            Assignee: Sergio Peña
>         Attachments: HIVE-11802.1.patch
>
>
> When inserting float-point numbers to a table, the values displayed on beeline or jdbc
are with different precision.
> How to reproduce:
> {noformat}
> 0: jdbc:hive2://localhost:10000> create table decimals (f float, af array<float>,
d double, ad array<double>) stored as parquet;
> No rows affected (0.294 seconds)
> 0: jdbc:hive2://localhost:10000> insert into table decimals select 1.10058, array(cast(1.10058
as float)), 2.0133, array(2.0133) from dummy limit 1;
> ...
> No rows affected (20.089 seconds)
> 0: jdbc:hive2://localhost:10000> select f, af, af[0], d, ad[0] from decimals;
> +---------------------+------------+---------------------+---------+---------+--+
> |          f          |     af     |         _c2         |    d    |   _c4   |
> +---------------------+------------+---------------------+---------+---------+--+
> | 1.1005799770355225  | [1.10058]  | 1.1005799770355225  | 2.0133  | 2.0133  |
> +---------------------+------------+---------------------+---------+---------+--+
> {noformat}
> When displaying arrays, the values are displayed correctly, but if I print a specific
element, it is then displayed with more decimal positions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message