Hi, I queried a table based on value of two float columns
select count(*) from u where xlong_u = 7.1578474 and xlat_u = 55.192524;select count(*) from u where xlong_u = cast(7.1578474 as float) and xlat_u = cast(55.192524 as float);
Both query returned 0 records, even though there are some records matched the condition. What can be wrong? I am using Hive 0.14
BR, Patcharee
