hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Grover (JIRA)" <>
Subject [jira] [Commented] (HIVE-2693) Add DECIMAL data type
Date Wed, 19 Dec 2012 01:14:14 GMT


Mark Grover commented on HIVE-2693:

That actually explains why where clauses aren't working because we are comparing BigDecimal
with Double.
I tried the same where clause but with a string and that worked:
3.14	3
3.14	3
3.14	3
3.140	4

So, here is the million dollar question. Our users (understandably so) are going to forget
about the quotes. Even if we introduce a new literal as a part of this JIRA, they are going
to forget about the literal. I can think of two options:
1. Somehow promote the double 3.14 to be a BigDecimal 3.14 (maintaining precision). Maybe
via a double->string->BigDecimal?
2. Throw an error like you suggested.

What do you think [~hagleitn]?
> Add DECIMAL data type
> ---------------------
>                 Key: HIVE-2693
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor, Types
>    Affects Versions: 0.10.0
>            Reporter: Carl Steinbach
>            Assignee: Prasad Mujumdar
>         Attachments: 2693_7.patch, 2693_8.patch, 2693_fix_all_tests1.patch, HIVE-2693-10.patch,
HIVE-2693-11.patch, HIVE-2693-12-SortableSerDe.patch, HIVE-2693-13.patch, HIVE-2693-1.patch.txt,
HIVE-2693-all.patch, HIVE-2693-fix.patch, HIVE-2693.patch, HIVE-2693-take3.patch, HIVE-2693-take4.patch
> Add support for the DECIMAL data type. HIVE-2272 (TIMESTAMP) provides a nice template
for how to do this.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message