Hive data query issues

Discussion created by neerajmahajan82 on Mar 16, 2017
Latest reply on Mar 24, 2017 by neerajmahajan82



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.