hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Peña (JIRA) <j...@apache.org>
Subject [jira] [Updated] (HIVE-11802) Float-point numbers are displayed with different precision in Beeline/JDBC
Date Mon, 14 Sep 2015 20:21:45 GMT

     [ https://issues.apache.org/jira/browse/HIVE-11802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sergio Peña updated HIVE-11802:
-------------------------------
    Attachment: HIVE-11802.3.patch

> 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.3.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