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 >
