hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13945) Decimal value is displayed as rounded when selecting where clause with that decimal value.
Date Wed, 29 Jun 2016 02:30:45 GMT

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

Sergey Shelukhin updated HIVE-13945:
------------------------------------
    Attachment: HIVE-13945.03.patch

Changed the default decimal precision in division, not sure why it was so low by default.
May break more tests than it fixes in terms of result changes... we'll see

> Decimal value is displayed as rounded when selecting where clause with that decimal value.
> ------------------------------------------------------------------------------------------
>
>                 Key: HIVE-13945
>                 URL: https://issues.apache.org/jira/browse/HIVE-13945
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.1.0
>            Reporter: Takahiko Saito
>            Assignee: Sergey Shelukhin
>            Priority: Critical
>         Attachments: HIVE-13945.01.patch, HIVE-13945.02.patch, HIVE-13945.03.patch, HIVE-13945.03.patch,
HIVE-13945.patch
>
>
> Create a table withe a column of decimal type(38,18) and insert '4327269606205.029297'.
Then select with that value displays its rounded value, which is 4327269606205.029300000000000000
> {noformat}
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4> drop table if exists test;
> No rows affected (0.229 seconds)
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4>
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4> create table test (dc decimal(38,18));
> No rows affected (0.125 seconds)
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4>
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4> insert into table test values (4327269606205.029297);
> No rows affected (2.372 seconds)
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4>
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4> select * from test;
> +-----------------------------------+--+
> |              test.dc              |
> +-----------------------------------+--+
> | 4327269606205.029297000000000000  |
> +-----------------------------------+--+
> 1 row selected (0.123 seconds)
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4>
> 0: jdbc:hive2://os-r7-mvjkcu-hiveserver2-11-4> select * from test where dc = 4327269606205.029297000000000000;
> +-----------------------------------+--+
> |              test.dc              |
> +-----------------------------------+--+
> | 4327269606205.029300000000000000  |
> +-----------------------------------+--+
> 1 row selected (0.109 seconds)
> {noformat}



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

Mime
View raw message