[HIVE-3820] Consider creating a literal like "D" or "BD" for representing Decimal type constants

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Assignee: Gunther Hagleitner
• Reporter: Mark Grover
• Created: 19/Dec/12 01:20
• Updated: 16/May/13 21:10
• Resolved: 21/Mar/13 13:21

Description

When the HIVE-2693 gets committed, users are going to see this behavior:

hive> select cast(3.14 as decimal) from decimal_3 limit 1;
3.140000000000000124344978758017532527446746826171875

That's intuitively incorrect but is the case because 3.14 (double) is being converted to BigDecimal because of which there is a precision mismatch.

We should consider creating a new literal for expressing constants of Decimal type as Gunther suggested in HIVE-2693.

Issue Links

• is related to: HIVE-2693 Add DECIMAL data type