[HIVE-12394] 0 is added when you insert decimal value which number of fractional digits is less than defined scale

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 2.0.0
• Target Version/s: 2.0.0
• Assignee: Unassigned
• Reporter: Takahiko Saito
• Created: 12/Nov/15 18:16
• Updated: 12/Nov/15 20:47
• Resolved: 12/Nov/15 18:45

Description

hive> create table test_decimal (d decimal(3,2));
hive> insert into table test_decimal values (0.1);
hive> select * from test_decimal;
0.10

Extra 0 is added to the end of the result.

Issue Links

• relates to: HIVE-12063 Pad Decimal numbers with trailing zeros to the scale of the column