Floating Point Calculations Show Variances and Inaccurate Values
(Doc ID 2211898.1)
Last updated on APRIL 03, 2019
Applies to:Big Data Appliance Integrated Software - Version 4.6.0 and later
Slight variances are seen in results for calculations that involve floating point values. Some examples of this are:
- Hive command line results differ slightly from Hue Impala/Hive results (This manifests as what appears to be rounding differences).
- .39999999999999999 stored as a double displays as .39999999999999999 in Hue Impala/Hive but 0.4 in Hive CLI
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document