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.thong...@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
