Support Questions
Find answers, ask questions, and share your expertise

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.


Can anyone please help me on this?