Running Query in Hive, it runs fine but provides no results!

0 views

Skip to first unread message

Ayesha Basit

unread,

Mar 5, 2019, 5:33:44 PM3/5/19

to Hands On Hadoop, Hive, Pig Training

Hi!

I uploaded data into hive, created a database and a table within it. Then I run a query but it provides me with no answer (I know there should be an answer because I did this in the past).

This is what I get (what am I doing wrong?):

hive> SELECT COUNT(trip_id) AS trip_TotalCount, bike_number
> FROM trip2
> WHERE start_station != end_station
> GROUP BY bike_number
> ORDER BY trip_TotalCount DESC
> LIMIT 4;
Query ID = root_20190305213656_8c2664ad-4d50-45d5-8c46-c5a4840e5679
Total jobs = 1
Launching Job 1 out of 1

Status: Running (Executing on YARN cluster with App id application_1551210151279_0024)

--------------------------------------------------------------------------------
VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
--------------------------------------------------------------------------------
Map 1 .......... SUCCEEDED 3 3 0 0 0 0
Reducer 2 ...... SUCCEEDED 1 1 0 0 0 0
Reducer 3 ...... SUCCEEDED 1 1 0 0 0 0
--------------------------------------------------------------------------------
VERTICES: 03/03 [==========================>>] 100% ELAPSED TIME: 13.06 s
--------------------------------------------------------------------------------
OK
Time taken: 16.546 seconds
hive>