hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From patcharee <Patcharee.Thong...@uni.no>
Subject cast column float
Date Wed, 27 May 2015 13:47:06 GMT
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

Mime
View raw message