hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11835) Type decimal(1,1) reads 0.0, 0.00, etc from text file as NULL
Date Wed, 16 Sep 2015 00:16:46 GMT
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)

Mime
View raw message