28828
DISCUSSIONS
102360
MEMBERS
3165
ARTICLES
Created on 07-27-2015 02:10 AM - edited 07-27-2015 06:13 AM
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