[HIVE-11835] Type decimal(1,1) reads 0.0, 0.00, etc from text file as NULL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0, 1.2.0, 2.0.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Types
• Assignee: Xuefu Zhang Assign to me
• Reporter: Xuefu Zhang
• Created: 16/Sep/15 00:16
• Updated: 16/Feb/16 23:53
• Resolved: 05/Oct/15 12:50

Description

Steps to reproduce:
1. create a text file with values like 0.0, 0.00, etc.
2. create table in hive with type decimal(1,1).
3. run "load data local inpath ..." to load data into the table.
4. run select * on the table.
You will see that NULL is displayed for 0.0, 0.00, .0, etc. Instead, these should be read as 0.0.

Issue Links

• duplicates: HIVE-8559 DECIMAL field can not store 0 if precision = scale
• requires: HIVE-12035 branch-1 build broken