I am doing the Hive lab exercise but finding issue with querying data. I have created the temperature table loaded the temperature.csv into the hive table as per the steps given.
The temperature table contains celsius filed which is of float type
I am querying the record where celsius value is -66.6, however I get empty result, but if I change the value to -61.5 then I get the right results. I have checked the data set and records exist in table with both -66.6 and -61.5 values.
Can someone explain me about this unexpected behaviour of results.