hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szehon Ho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11835) Type decimal(1,1) reads 0.0, 0.00, etc from text file as NULL
Date Mon, 28 Sep 2015 22:47:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14934244#comment-14934244
] 

Szehon Ho commented on HIVE-11835:
----------------------------------

Latest change looks good to me to address this issue, +1.

I am curious what is the expected behavior when a non-zero value is read from text file for
decimal(1,1).

> 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.2.0, 1.1.0, 2.0.0
>            Reporter: Xuefu Zhang
>            Assignee: Xuefu Zhang
>         Attachments: HIVE-11835.1.patch, HIVE-11835.2.patch, HIVE-11835.patch
>
>
> 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