Explorer
Posts: 6
Registered: ‎07-25-2015
Hive server query hanging when issue ing select count(*) on CLI
[ Edited ]

Hi,

 

I am running select count(*) on a hive table created on hive schema on a freshly installed cdh 5.3 version for POC purpose.

 

But the query hangs after executing upto kill command .

 

Any help in resolving this will be appreciated

 

hive> select count(*) from id;               
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1437996970870_0002, Tracking URL = http://01HW******************com:8088/proxy/application_1437996970870_0002/
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_1437996970870_0002

 

 

Running on debugger the process is stuck at

 

15/07/27 18:33:35 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getApplicationReport took 1ms
15/07/27 18:33:35 [main]: DEBUG security.UserGroupInformation: PrivilegedAction as:root (auth:SIMPLE) from:org.apache.hadoop.mapreduce.Job.updateStatus(Job.java:311)
15/07/27 18:33:35 [IPC Parameter Sending Thread #0]: DEBUG ipc.Client: IPC Client (1253487275) connection to 01HW310845.xxxxx.com/172.26.204.182:8032 from root sending #268
15/07/27 18:33:35 [IPC Client (1253487275) connection to 01HW310845.xxxxxx.com/172.26.204.182:8032 from root]: DEBUG ipc.Client: IPC Client (1253487275) connection to 01HW310845.xxxxxx.com/172.26.204.182:8032 from root got value #268
15/07/27 18:33:35 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getApplicationReport took 1ms

 

 

 

 

Thanks Udaya

Who Me Too'd this topic