You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Surendranatha Reddy (JIRA)" <ji...@apache.org> on 2017/04/24 09:30:04 UTC

[jira] [Created] (HIVE-16514) Decimal datatype is truncating 1st digit of the number while storing into Parquet file

Surendranatha Reddy created HIVE-16514:
------------------------------------------

             Summary: Decimal datatype is truncating 1st digit of the number while storing into Parquet file
                 Key: HIVE-16514
                 URL: https://issues.apache.org/jira/browse/HIVE-16514
             Project: Hive
          Issue Type: Bug
          Components: File Formats, Hive
    Affects Versions: 1.1.0
         Environment: CDH 5.7
            Reporter: Surendranatha Reddy
            Priority: Blocker


We declared one of the Hive Parquet table column as Decimal (38,20) .
We have inserted data from one of the intermediate table using sum function with "insert into select " statement. 
Sum value is 9389587.19800467 . 
Where as it is getting stored as 389587.19800467
 First digit of number is getting truncated  while it getting stored in Table. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)