Double data type in Hive will present the data differently unlike RDBMS.
See the double type data below:
14324.0
342556.0
1.28893E4
E4 represents 10^4 here. So, the value1.28893E4 represents 12889.3. All the
calculations will be accurately performed using double type
It is crucial while exporting the double type data to any RDBMS since the type may be
wrongly interpreted. So, it is advised to cast the double type into appropriate type before
exporting.
