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
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
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.thong...@uni.no mailto:patcharee.thong...@uni.no