hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bhagwan S. Soni" <bhgwnsson...@gmail.com>
Subject Re: cast column float
Date Wed, 27 May 2015 16:12:25 GMT
could you also provide some sample dataset for these two columns?

On Wed, May 27, 2015 at 7:17 PM, patcharee <Patcharee.Thongtra@uni.no>
wrote:

> 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