hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patcharee Thongtra <Patcharee.Thong...@uni.no>
Subject Re: compare float column
Date Tue, 13 Jan 2015 09:21:38 GMT
It works. Thanks!

Patcharee

On 01/13/2015 10:15 AM, Devopam Mittra wrote:
> 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 <mailto: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