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.