cast column float

2015-05-27 Thread patcharee 

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

Re: cast column float

2015-05-27 Thread Bhagwan S. Soni 
could you also provide some sample dataset for these two columns?

On Wed, May 27, 2015 at 7:17 PM, patcharee patcharee.thong...@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