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)

Reply via email to