Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

Hive stores a double datatype with 'Exponent'

NIFI CSVtoAvroConverter Processor does not support decimal data type. We have replaced decimal with double instead.

When decimal is replaced with double in the outgoing schema option, we are facing the below issue.

Number which has precision=”25” , scale=”3” eg 1234567890123456789012345.123 is stored as 1.2345678901234568E24 in Hive. If someother process in the future tries to read this value in hive as a string, the meaning of the field completely changes.

Can you please provide a solution for this.

1 REPLY 1

Can anyone please help me on this?