[jira] [Commented] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC

["Carl Steinbach (JIRA)" <ji...@apache.org>]

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