Hi,
There is really some data, but with these two queries return nothing...
so weird
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);
Here is sample data.
select xlong_u, xlat_u from u order by abs(xlong_u - 7.1578474),
abs(xlat_u - 55.192524) limit 5;
Query ID = patcharee_20150529115353_4eeacf47-d2d1-468e-811c-729be80bb750
Total jobs = 1
Launching Job 1 out of 1
Status: Running (Executing on YARN cluster with App id
application_1432633634512_0109)
--------------------------------------------------------------------------------
VERTICES STATUS TOTAL COMPLETED RUNNING PENDING
FAILED KILLED
--------------------------------------------------------------------------------
Map 1 .......... SUCCEEDED 289 289 0 0 0 0
Reducer 2 ...... SUCCEEDED 1 1 0 0 0 0
--------------------------------------------------------------------------------
VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME:
391.59 s
--------------------------------------------------------------------------------
OK
7.1578474 55.192524
7.1578474 55.192524
7.1578474 55.192524
7.1578474 55.192524
7.1578474 55.192524
Patcharee
On 27. mai 2015 18:12, Bhagwan S. Soni wrote:
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
<mailto: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
