hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devopam Mittra <devo...@gmail.com>
Subject Re: compare float column
Date Tue, 13 Jan 2015 09:15:36 GMT
please try the following and report observation:

WHERE long = CAST(-41.338276 AS FLOAT)


regards
Devopam


On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra <
Patcharee.Thongtra@uni.no> wrote:

> Hi,
>
> I have a table with float columns. I tried to query based on the condition
> on a float column (called 'long'), but it failed (nothing returned).
>
> hive> select * from test_float where long == -41.338276;
> select * from test_float where long == -41.338276
> Status: Finished successfully
> OK
> Time taken: 14.262 seconds
>
> hive> select long from test_float;
> select long from test_float
> Status: Finished successfully
> OK
> -41.338276
> Time taken: 6.843 seconds, Fetched: 1 row(s)
>
>
> Any ideas? I am using hive version 0.13.
>
> BR,
> Patcharee
>
>
>
>
>


-- 
Devopam Mittra
Life and Relations are not binary

Mime
View raw message