Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Decimal datatype is truncating 1st digit of the number while storing into Parquet file

Highlighted

Decimal datatype is truncating 1st digit of the number while storing into Parquet file

New Contributor

We declared one of the Hive Parquet table column as Decimal (38,20) .
We have inserted data into this table  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.