Hi, I have a column where float values were stored as STRING type, e.g. 9989.64 When I cast that column to obtain a FLOAT like so "SELECT a, cast(a AS FLOAT) ... " I obtain the following: a cast(a AS FLOAT) 5724.95  5724.9501953125   Why does Hive alter the decimal part? How can I get the exact number? BTW, casting the STRING to DOUBLE does render the expected behaviour BR ... View more