Xuefu Zhang created HIVE-11835: ---------------------------------- Summary: Type decimal(1,1) reads 0.0, 0.00, etc from text file as NULL Key: HIVE-11835 URL: https://issues.apache.org/jira/browse/HIVE-11835 Project: Hive Issue Type: Bug Components: Types Affects Versions: 1.1.0, 1.2.0, 2.0.0 Reporter: Xuefu Zhang Assignee: Xuefu Zhang
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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)