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

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Component/s: File Formats, Hive

Environment

CDH 5.7

• Flags: Important
• Assignee: Unassigned
• Reporter: Surendranatha Reddy
• Created: 24/Apr/17 09:29
• Updated: 20/Sep/17 14:02

Description

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.