[
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
Another round of updates and fixes.
I added double literals and used them in some places where it makes sense.. had
to make some changes to the parser to get around "code too large" errors.
Also adjusted the behavior of some fns to support decimal properly, and fixed
an unrelated bug in Lead/Lag fn exposed by this patch.
Still need to look at precision for operations, and incorrect results for
struct-in (probably related to decimal vs double in the struct), and ORC ppd
test (didn't look yet).
> 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.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)
